Results of 1 - 10 of about 16 for controls (0.002 sec.)
- Iceberg Options 12199
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
..._NESTED_NAMESPACES BOOLEAN false Set to true for catalogs that support nested namespaces. STAGE_CREATE_TABLES BOOLEAN true Controls whether DuckDB uses staged CREATE TABLE . Disable for catalogs that do not support staged table creation. DISABLE_MULTI_TA...do not assign a table location server-side. Note: this feature was introduced in DuckDB 2.0. TABLE_RESOLUTION VARCHAR lazy Controls when table schemas are resolved. Accepted values: lazy , eager . With lazy (the default), a table's schema is resolved onl...the latest version (see Selecting Metadata Versions ) version_name_format VARCHAR 'v%s%s.metadata.json,%s%s.metadata.json' Controls how versions are converted to metadata file names iceberg_snapshots does not take allow_moved_paths , snapshot_from_id or... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Blob Functions 12199
- This section describes functions and operators for examining and manipulating BLOB values . Function Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and l
...) . base64(blob) Alias for to_base64 . decode(blob[, on_error]) Converts blob to VARCHAR . The optional on_error parameter controls handling of invalid UTF-8: 'strict' (default, throws error), 'replace' (replaces invalid characters with ? ), or 'ignore'...| Result | \xAA\xBB | decode(blob[, on_error]) | Description | Converts blob to VARCHAR . The optional on_error parameter controls handling of invalid UTF-8: 'strict' (default, throws error), 'replace' (replaces invalid characters with ? ), or 'ignore'... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- Describe 10206
- 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
...ed Describing a table with SHOW tbl is deprecated and emits a warning. Use DESCRIBE tbl instead. The show_behavior setting controls whether SHOW resolves a bare identifier to a table or a setting. Describing a Query To view the schema of the result of a... - https://man.mtool.work/duckdb/2.0/guides/meta/describe.html
- Join Operations 10206
- How to Force a Join Order DuckDB has a cost-based query optimizer, which uses statistics in the base tables (stored in a DuckDB database or Parquet files) to estimate the cardinality of operations. Turn off the Join Order Optimizer To turn
...for large joins the optimizer switches to an approximate (greedy) algorithm. The approximate_join_order_threshold setting controls when this happens: joins with at least this many tables are ordered approximately, while joins with fewer tables are order... - https://man.mtool.work/duckdb/2.0/guides/performance/join_operations.html
- Instantiate 9721
- Overview DuckDB-Wasm can be instantiated in several ways, depending on how your application bundles and serves its assets. Each approach resolves the mainModule (the WebAssembly file) and the mainWorker (the worker script) for the browser's
...eads to use. This takes effect only with the threaded coi bundle on a cross-origin-isolated page (see Threading ). query : controls how query results are converted from Arrow into JavaScript values. opfs : controls how opfs:// files other than the databa... - https://man.mtool.work/duckdb/2.0/clients/wasm/instantiation.html
- Building Extensions 9218
- Extensions can be built from source and installed from the resulting local binary. Building Extensions To build using extension flags, set the BUILD_EXTENSIONS flag to the list of extensions that you want to be built. For example: BUILD_EXT
...S=1 or list them in STATICALLY_LINK_EXTENSIONS (see Linking Extensions ). Special Extension Flags BUILD_JEMALLOC This flag controls whether the jemalloc memory allocator is linked into DuckDB. Unlike TPC-H and TPC-DS, jemalloc is not an extension. It is... - https://man.mtool.work/duckdb/2.0/dev/building/building_extensions.html
- I/O 8213
- Warning DuckDB ships with safe defaults. The configuration options described on this page are advanced options, so proceed with caution when changing them. Asynchronous I/O New Asynchronous I/O was introduced in DuckDB 2.0. Starting with v2
...file system, it asks the operating system to flush the written data to stable storage. The fsync_mode configuration option controls how this is done. It can have three values: STANDARD (default): uses the regular sync call of the platform, i.e., fdatasyn... - https://man.mtool.work/duckdb/2.0/data/io.html
- Keywords and Identifiers 8213
- Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keyw
...dentifier_case is a VARCHAR option. Previously, it was a BOOLEAN option. The preserve_identifier_case configuration option controls how non-quoted identifiers are folded. It accepts the following values: 'preserve_case' (default): keep the case as writte... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- Loading JSON 7728
- The DuckDB JSON reader can automatically infer which configuration flags to use by analyzing the JSON file. This will work correctly in most situations, and should be the first option attempted. In rare situations where the JSON reader cann
...VARCHAR iso union_by_name Whether the schemas of multiple JSON files should be unified BOOL false map_inference_threshold Controls the threshold for number of columns whose schema will be auto-detected; if JSON schema auto-detection would infer a STRUCT... - https://man.mtool.work/duckdb/2.0/data/json/loading_json.html
- Logging 7728
- DuckDB implements a logging mechanism that provides users with detailed information about events such as query execution, performance metrics and system events. Warning Logs may contain sensitive information, including secrets and credentia
...LL enable_logging('HTTP') together with duckdb_logs_parsed('HTTP') ) instead. The redact_http_logs setting (default true ) controls whether HTTP header values are redacted in the logs. To enable multiple log types, simply pass: CALL enable_logging(['HTTP... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
DuckDB 2.0 Documentation / man.mtool.work