Results of 1 - 10 of about 19 for legacy (0.002 sec.)
- Legacy Parser Extension 14001
- New The legacy_parser extension was introduced in DuckDB 2.0. DuckDB 2.0.0 replaced the PostgreSQL-derived parser with a new PEG-based parser . The legacy_parser extension allows reverting to the old parser. The PEG parser is designed to be
...y that parsed on an earlier version fails on v2.0.0, please file an issue . Installing and Loading To install and load the legacy_parser extension, run: INSTALL AND LOAD legacy_parser; Usage To activate the legacy parser, run: SET enable_legacy_parser...= true; To switch back to the PEG parser, run: SET enable_legacy_parser = false;... - https://man.mtool.work/duckdb/2.0/core_extensions/legacy_parser.html
- PEG Parser 12362
- New Starting with DuckDB 2.0, the PEG parser is the default parser. In earlier versions it was an experimental, opt-in feature enabled with enable_peg_parser() , which is no longer required or available. DuckDB uses a parser based on PEG (
...42')::JSON->>'error' AS parse_error; ┌─────────────┐ │ parse_error │ │ varchar │ ├─────────────┤ │ true │ └─────────────┘ Legacy Parser New The legacy_parser extension was introduced in DuckDB 2.0. For exceptional cases, DuckDB 2.0 can fall back to th...e legacy PostgreSQL-style parser through the legacy_parser extension . Setting the following option autoloads the extension and swi...tches from the default PEG parser to the legacy parser: SET enable_legacy_parser = true; The legacy parser is intended as a bridge solution, for example to check a query... - https://man.mtool.work/duckdb/2.0/sql/peg_parser.html
- Legacy Authentication Scheme for S3 API 9391
- Prior to version 0.10.0, DuckDB did not have a Secrets manager . Hence, the configuration of and authentication to S3 endpoints was handled via variables. This page documents the legacy authentication scheme for the S3 API. Warning This pag
...e describes a legacy method to store secrets as DuckDB settings. This increases the risk of accidentally leaking secrets (e.g., by printing the...g these methods for storing secrets. The recommended way to configure and authenticate of S3 endpoints is to use secrets . Legacy Authentication Scheme To be able to read or write from S3, the correct region should be set: SET s3_region = 'us-east-1';...d disabled by default in DuckDB 2.0: the ? and the text following it are treated as part of the object key. To restore the legacy behavior, run SET s3_enable_deprecated_url_parameters = true; (URL compatibility mode must also be disabled). Once this se... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api_legacy_authentica...
- Migrating to DuckDB 2.0 8896
- DuckDB 2.0.0 is packed with new features and performance improvements, including query optimization and asynchronous I/O. It also ships a small set of breaking changes, most notably a new default storage format, which DuckDB versions before
...and BITSTRING values instead of the VARCHAR strings 'x…' and 'b…' . If you would like to revert to the old parser, use the legacy_parser extension . To install and activate it, run the following commands: INSTALL AND LOAD legacy_parser; SET enable_lega...non- NULL values. Cast the NULL to the intended type, e.g., NULL::VARCHAR AS x , or restore the previous behavior with SET legacy_disable_null_type = true; . Identifier Case Setting The preserve_identifier_case setting changed from a BOOLEAN to a VARCH...y default: the ? and the following text are now treated as part of the object key. Use secrets instead or, if you need the legacy behavior, opt in with SET s3_enable_deprecated_url_parameters = true (available after loading the httpfs extension). Remov... - https://man.mtool.work/duckdb/2.0/operations_manual/migration.html
- Core Extensions 8571
- List of Core Extensions Name Description Maintainer Support tier Aliases autocomplete Autocompletion for CLI client DuckDB team avro Avro files reading DuckDB team aws AWS S3 functionality DuckDB team azure Filesystem abstraction for Azure
...IP-related data types and functions DuckDB team json JSON operations DuckDB team lance Lance tables read/write Third party legacy_parser Legacy PostgreSQL-derived SQL parser DuckDB team motherduck MotherDuck connectivity Third party md mysql MySQL data... - https://man.mtool.work/duckdb/2.0/core_extensions/overview.html
- Configuration 8452
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...ion_max_rows The maximum amount of rows in the LIMIT/SAMPLE operator for which we trigger late materialization. UBIGINT 50 legacy_disable_null_type When enabled, prevent the NULL type from leaving the binder. This was the default behavior prior to Duck...can keep open before flushing to disk when writing using PARTITION_BY . UBIGINT 100 password The password to use. Kept for legacy compatibility. VARCHAR perfect_ht_threshold Threshold in bytes for when to use a perfect hash table. UBIGINT 12 pin_thread...he number of total background threads used by the system. BIGINT # CPU cores user , username The username to use. Kept for legacy compatibility. VARCHAR validate_external_file_cache The cache validation mode. VALIDATE_ ALL is the default, it validates... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- S3 and AWS Authentication 8452
- This page is the entry point for authenticating to S3 and other AWS services from DuckDB. Authentication is configured using secrets , and the detailed reference material lives on the S3 API Support and AWS Extension pages. The sections bel
...ew of S3 Secret Parameters . Platform-specific secret types for Cloudflare R2 and Google Cloud Storage are also available. Legacy Authentication Before DuckDB had a Secrets manager , credentials were loaded through the load_aws_credentials function. Th...is method is deprecated. See the Legacy Authentication Scheme for S3 API page if you are maintaining older setups.... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/authentication.html
- AWS Extension 8332
- The aws extension adds functionality, e.g., authentication, on top of the httpfs extension's S3 capabilities , using the AWS SDK. Installing and Loading The aws extension will be transparently autoloaded on first use from the official exten
...ECRET , attaching, and querying — see the Amazon RDS with IAM authentication guide or the Postgres secrets documentation . Legacy Features Deprecated The load_aws_credentials function is deprecated and is removed in later releases. Use a secret with th..., to load the credentials automatically, the AWS extension provided a special function to load the AWS credentials in the legacy authentication method . Function Type Description load_aws_credentials PRAGMA function Loads the AWS credentials through t...he AWS Default Credentials Provider Chain Load AWS Credentials (Legacy) To load the AWS credentials, run: CALL load_aws_credentials(); loaded_access_key_id loaded_secret_access_key loaded_sessi... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- Reading and Writing Parquet Files 7820
- Examples Read a single Parquet file: SELECT * FROM 'test.parquet'; Figure out which columns/types are in a Parquet file: DESCRIBE SELECT * FROM 'test.parquet'; Create a table from a Parquet file: CREATE TABLE test AS SELECT * FROM 'test.par
...n of type BOOL ) instead of throwing an error. Added in DuckDB 2.0. BOOL false binary_as_string Parquet files generated by legacy writers do not correctly set the UTF8 flag for strings, causing string columns to be loaded as BLOB instead. Set this to t...a Hive partitioned path . BOOL (auto-detected) int96_as How to read INT96 columns (a deprecated timestamp encoding used by legacy writers such as Impala and older Spark versions). Options are timestamp (microsecond precision), timestamp_ns (preserves n... - https://man.mtool.work/duckdb/2.0/data/parquet/overview.html
- Troubleshoot 7700
- Overview This page collects common issues encountered when using the DuckDB JDBC driver, together with their workarounds. If you run into a problem that is not covered here, search the driver's issue tracker on GitHub. Driver Class Not Foun
...ted, force refresh the Maven configuration in your IDE. Parquet String Column Returns a Blob Parquet files written by some legacy writers do not set the UTF8 flag on string columns, so DuckDB reads them as BLOB . ResultSet.getObject() then returns a Du... - https://man.mtool.work/duckdb/2.0/clients/java/troubleshoot.html
DuckDB 2.0 Documentation / man.mtool.work