Skip to content

Export to Parquet file with encryption #10752

@alexandroid11

Description

@alexandroid11

What happens?

Export to encrypted Parquet file failed with Error: Invalid Error: Unable to generate random data for Windows DuckDB client

To Reproduce

I'm doing very simple test for .10 version on fresh DuckDB client on windows instance.
(Downloaded latest version with winget install DuckDB.cli )

create table md (Id int);
select * from md;

Output:

┌────────┐
│ Id │
│ int32 │
├────────┤
│ 0 rows │
└────────┘
insert into md (Id) values (1);
insert into md (Id) values (2);
select * from md;

Output:

┌───────┐
│ Id │
│ int32 │
├───────┤
│ 1 │
│ 2 │
└───────┘
PRAGMA add_parquet_key('key256', '01234567891123450123456789112345');

Output:

┌─────────┐
│ Success │
│ boolean │
├─────────┤
│ 0 rows │
└─────────┘
COPY md TO 'tbl.parquet' (ENCRYPTION_CONFIG {footer_key: 'key256'});

Output:

Error: Invalid Error: Unable to generate random data

I tried with nightly build with the same results.
Also tried to use .open test.db first , also the same error.

OS:

Windows 10 Pro x64

DuckDB Version:

0.10.0

DuckDB Client:

Win DuckDB.cli

Full Name:

Alex Nikitin

Affiliation:

Partners Intl

Have you tried this on the latest nightly build?

I have tested with a nightly build

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

  • Yes, I have

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions