Results of 1 - 10 of about 38 for deprecated (0.002 sec.)
- Configuration 13884
- 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
...NT 100000 prefer_range_joins Force the use of range joins with mixed predicates. BOOLEAN false prefetch_all_parquet_files (deprecated) Parquet files are now always prefetched, this setting has no effect BOOLEAN false preserve_identifier_case How to fold no...ing Whether globs on S3-like storage are optimized with recursive strategy (alternative is listing) BOOLEAN true s3_enable_deprecated_url_parameters Enable deprecated S3 URL parameters. NULL disables them by default; false permanently disables them for thi..._id_pinning Pin S3 reads to a specific object version for consistency BOOLEAN false scalar_subquery_error_on_multiple_rows Deprecated setting. Throw an error when a scalar subquery returns more than one row. This will become the default behavior. When disa... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Pragmas 12358
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...DuckDB settings using the SET statement . You can retrieve a setting's value using SELECT current_setting('option_name') . Deprecated Assigning configuration settings with PRAGMA name = value is deprecated and emits a warning. Use SET name = value instead....the old behavior that performs implicit casting, set the old_implicit_casting variable to true . Note that this setting is deprecated and will be removed in a future release: SET old_implicit_casting = true; Python: Scan All Dataframes Prior to version 1.1...ension must match the profiling output format set in enable_profiling (e.g., .json for json ), or be .txt . Profiling Mode Deprecated The profiling_mode setting is deprecated in DuckDB 2.0 and its value has no effect: detailed profiling information is alwa... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Query 9795
- The duckdb_query method allows SQL queries to be run in DuckDB from C. This method takes two parameters, a (null-terminated) SQL query string and a duckdb_result result pointer. The result pointer may be NULL if the application is not inter
...oy_result(&res); duckdb_disconnect(&con); duckdb_close(&db); This prints the following result: 3,4 5,6 7,NULL duckdb_value Deprecated The duckdb_value functions are deprecated and are scheduled for removal in a future release. Below is an example that prin...ckdb_result * result ); Parameters result : The result object. Return Value The number of rows changed. duckdb_column_data Deprecated This method has been deprecated. Prefer using duckdb_result_get_chunk instead. Returns the data of a specific column of a...h the column data from. col : The column index. Return Value The column data of the specified column. duckdb_nullmask_data Deprecated This method has been deprecated. Prefer using duckdb_result_get_chunk instead. Returns the nullmask of a specific column o... - https://man.mtool.work/duckdb/2.0/clients/c/query.html
- Profiling 9795
- Profiling is essential to help understand why certain queries exhibit specific performance characteristics. DuckDB contains several built-in features to enable query profiling, which this page covers. For a high-level example of using EXPLA
...he operators to profile SELECT SELECT , ALL profiling_output Set a profiling output file Console A filepath profiling_mode Deprecated, has no effect standard standard , detailed , all tracked_metrics Select which metrics to collect ['*'] (all metrics) A li...ator.timing'] ); Parameter Type Description metrics LIST , STRUCT , or JSON Specifies which metrics to enable mode VARCHAR Deprecated, has no effect (detailed profiling information is always collected) save_location VARCHAR File path for profiling output c...le_metrics() table function: sql SELECT metric_name, metric_type, unit FROM duckdb_available_metrics(); Detailed Profiling Deprecated In DuckDB 2.0, the profiling_mode setting is deprecated and has no effect: detailed profiling information, such as the pla... - https://man.mtool.work/duckdb/2.0/dev/profiling.html
- Migrating to DuckDB 2.0 9481
- 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
..._arrow'; This flag is a temporary bridge: DuckDB 2.1 will remove it and the single arrow syntax entirely. For details, see Deprecated Syntax . SQL Parser DuckDB 2.0.0 replaced the PostgreSQL-derived parser with a new PEG-based parser . It is designed to be...perform partial regular expression matching , following PostgreSQL: 'abc' ~ 'b' now returns true (previously false ). The deprecated regex_match_operator_semantics setting restores full matching: SET regex_match_operator_semantics = 'full'; The factorial...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). Removed and Deprecated Settings The custom_profiling... - https://man.mtool.work/duckdb/2.0/operations_manual/migration.html
- Legacy Authentication Scheme for S3 API 9339
- 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
...s3_session_token = '⟨aws_session_token⟩'; The aws extension allows for loading AWS credentials. Per-Request Configuration Deprecated Per-request configuration through S3 URL query parameters is deprecated and disabled by default in DuckDB 2.0: the ? and t...he 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 setting has been explicitly set to false... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api_legacy_authentica...
- Describe 8726
- Describing a Table To view the schema of a table, use the DESCRIBE statement (or its alias DESC ) followed by the table name. CREATE TABLE tbl (i INTEGER PRIMARY KEY, j VARCHAR); DESCRIBE tbl; column_name column_type null key default extra
...i INTEGER NO PRI NULL NULL j VARCHAR YES NULL NULL NULL Deprecated Describing a table with SHOW tbl is deprecated and emits a warning. Use DESCRIBE tbl instead. The show_behavior setting co... - https://man.mtool.work/duckdb/2.0/guides/meta/describe.html
- Lambda Functions 8726
- DuckDB lambda functions (a.k.a. 'lambdas' or 'lambda expressions') are expressions that define an inline anonymous function. Lambdas are passed as argument to certain list functions , which evaluate the passed lambda expression against its
...e list function. You cannot return a lambda function from a macro (but you can invoke a macro in the lambda's expression). Deprecated Syntax Deprecated DuckDB 1.3 deprecated the old lambda single arrow syntax ( x -> x + 1 ) in favor of the Python-style syn...t. Under default , only the Python-style syntax is enabled; use SET lambda_syntax = 'enable_single_arrow' to revert to the deprecated behavior. DuckDB 2.1 will remove the lambda_syntax flag and the single arrow syntax entirely, so the old behavior will no... - https://man.mtool.work/duckdb/2.0/sql/functions/lambda.html
- DESCRIBE Statement 8270
- The DESCRIBE statement shows the schema of a table, view or query. Usage DESCRIBE tbl; To describe a query, prepend DESCRIBE to a query. DESCRIBE SELECT * FROM tbl; Alias The SHOW statement can also describe tables and queries, but this usa
...ge is deprecated as of DuckDB 2.0 and prints a warning. See Also For more examples, see the guide on DESCRIBE .... - https://man.mtool.work/duckdb/2.0/sql/statements/describe.html
- AWS Extension 8129
- 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
...ET secret ( TYPE s3, PROVIDER credential_chain, CHAIN config, PROFILE '⟨my_profile⟩' ); This approach is equivalent to the deprecated S3 API 's method load_aws_credentials('⟨my_profile⟩') . Assuming a Role (STS) To assume an IAM role, pass its ARN via ASSU...g, 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 the credential_chain p... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
DuckDB 2.0 Documentation / man.mtool.work