duckdb / duckdb-web

DuckDB website and documentation
https://duckdb.org
MIT License
143 stars 275 forks source link

Issue found on page 'Reading Faulty CSV Files' Example throws Invalid named parameter error #2831

Open Rebolforces opened 1 month ago

Rebolforces commented 1 month ago

Please describe the problem you encountered in the DuckDB documentation and include the "Page URL" link shown below. Note: only create an issue if you wish to report a problem with the DuckDB documentation. For questions about DuckDB or the use of certain DuckDB features, use GitHub Discussions, Stack Overflow, or Discord.

Page URL: https://duckdb.org/docs/data/csv/reading_faulty_csv_files.html

Throws error 'Binder Error: Invalid named parameter "rejects_recovery_columns" for function read_csv'

When running example.

FROM read_csv(
    'faulty.csv',
    columns = {'name': 'VARCHAR', 'age': 'INTEGER'},
    rejects_table = 'rejects_table',
    rejects_recovery_columns = '[name]',
    ignore_errors = true
);
szarnyasg commented 1 month ago

Thanks! This feature was reworked and the rejects_recovery_columns was removed. I hid this section from the documentation. We'll give this page a more thorough rework soon.