Results of 1 - 10 of about 40 for Whether (0.005 sec.)
- Configuration – DuckDB 12981
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ss_mode Access mode of the database ( AUTOMATIC , READ_ONLY or READ_WRITE ) VARCHAR automatic allocator_background_threads Whether to enable the allocator background thread. BOOLEAN false allocator_bulk_deallocation_flush_threshold If a bulk deallocatio...les that are ALWAYS allowed to be queried - even when enable_external_access is false VARCHAR[] [] arrow_large_buffer_size Whether Arrow buffers for strings, blobs, uuids and bits should be exported using large buffers BOOLEAN false arrow_lossless_conve...al extension match in Arrow, export the types with a duckdb.type_name extension name. BOOLEAN false arrow_output_list_view Whether export to Arrow format should use ListView as the physical layout for LIST columns BOOLEAN false autoinstall_extension_rep... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- Loading JSON – DuckDB 12981
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...son.gz will use gzip, t.json will use none). Options are none , gzip , zstd and auto_detect . VARCHAR auto_detect filename Whether or not an extra filename column should be included in the result. Since DuckDB v1.3.0, the filename column is added automa...asons. BOOL false format Can be one of auto , unstructured , newline_delimited and array . VARCHAR array hive_partitioning Whether or not to interpret the path as a Hive partitioned path . BOOL (auto-detected) ignore_errors Whether to ignore parse error...at , ignore_errors and compression , these functions have additional parameters: Name Description Type Default auto_detect Whether to auto-detect the names of the keys and data types of the values automatically BOOL true columns A struct that specifies... - https://man.mtool.work/duckdb/1.3/data/json/loading_json.html
- Excel Extension – DuckDB 10859
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...stead. The following named parameters are supported. Option Type Default Description header BOOLEAN automatically inferred Whether to treat the first row as containing the names of the resulting columns. sheet VARCHAR automatically inferred The name of...the sheet in the xlsx file to read. Default is the first sheet. all_varchar BOOLEAN false Whether to read all cells as containing VARCHAR s. ignore_errors BOOLEAN false Whether to ignore errors and silently replace cells...onsecutive non-empty cells and the first empty row spanning the same columns. stop_at_empty BOOLEAN automatically inferred Whether to stop reading the file when an empty row is encountered. If an explicit range option is provided, this is false by defau... - https://man.mtool.work/duckdb/1.3/core_extensions/excel.html
- COPY Statement – DuckDB 10188
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...uckDB provides CSV , PARQUET and JSON but additional copy functions can be added by extensions . VARCHAR auto USE_TMP_FILE Whether or not to write to a temporary file first if the original file exists ( target.csv.tmp ). This prevents overwriting an exi...sting file with a broken file in case the writing is cancelled. BOOL auto OVERWRITE_OR_IGNORE Whether or not to allow overwriting files if they already exist. Only has an effect when used with PARTITION_BY . BOOL false OVERW...ns to partition by using a Hive partitioning scheme, see the partitioned writes section . VARCHAR[] (empty) PRESERVE_ORDER Whether or not to preserve order during the copy operation. Defaults to the value of the preserve_insertion_order configuration op... - https://man.mtool.work/duckdb/1.3/sql/statements/copy.html
- Full-Text Search Extension – DuckDB 9517
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ignored. Defaults to '(\\.|[^a-z])+' , ignoring all escaped and non-alphabetic lowercase characters strip_accents BOOLEAN Whether to remove accents (e.g., convert á to a ). Defaults to 1 lower BOOLEAN Whether to convert all text to lowercase. Defaults...to 1 overwrite BOOLEAN Whether to overwrite an existing index on a table. Defaults to 0 This PRAGMA builds the index under a newly created schema. The sc...rieval model. Defaults to 1.2 b DOUBLE Parameter b in the Okapi BM25 retrieval model. Defaults to 0.75 conjunctive BOOLEAN Whether to make the query conjunctive i.e., all terms in the query string must be present in order for a document to be retrieved... - https://man.mtool.work/duckdb/1.3/core_extensions/full_text_search.html
- Reading and Writing Parquet Files – DuckDB 9252
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...e to load binary columns as strings. BOOL false encryption_config Configuration for Parquet encryption . STRUCT - filename Whether or not an extra filename column should be included in the result. Since DuckDB v1.3.0, the filename column is added automa...tically as a virtual column and this option is only kept for compatibility reasons. BOOL false file_row_number Whether or not to include the file_row_number column. BOOL false hive_partitioning Whether or not to interpret the path as a Hive...partitioned path . BOOL (auto-detected) union_by_name Whether the columns of multiple schemas should be unified by name , rather than by position. BOOL false schema Allows you to read... - https://man.mtool.work/duckdb/1.3/data/parquet/overview.html
- DuckDB_% Metadata Functions – DuckDB 8846
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...type of RDBMS implemented by the attached database. For DuckDB databases, that value is duckdb . VARCHAR readonly Denotes whether the database is read-only. BOOLEAN duckdb_dependencies The duckdb_dependencies() function provides metadata about the depe...type of the secret, e.g., S3 , GCS , R2 , AZURE . VARCHAR provider The provider of the secret. VARCHAR persistent Denotes whether the secret is persisent. BOOLEAN storage The backend for storing the secret. VARCHAR scope The scope of the secret. VARCHA...omment created by the COMMENT ON statement . VARCHAR tags A map of string key–value pairs. MAP(VARCHAR, VARCHAR) temporary Whether this sequence is temporary. Temporary sequences are transient and only visible within the current connection. BOOLEAN star... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Complete API – DuckDB 8581
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...nk instead. Returns the nullmask of a specific column of a result in columnar format. The nullmask indicates for every row whether or not the corresponding row is NULL . If a row is NULL , the values present in the array provided by duckdb_column_data a...tax bool duckdb_result_is_streaming ( duckdb_result result ); Parameters result : The result object to check. Return Value Whether or not the result object is of the type StreamQueryResult duckdb_result_chunk_count Warning Deprecation notice. This metho...by duckdb_create_data_chunk . Return Value The vector size. Syntax idx_t duckdb_vector_size ( ); duckdb_string_is_inlined Whether or not the duckdb_string_t value is inlined. This means that the data of the string does not have a separate allocation. S... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- PostgreSQL Extension – DuckDB 8581
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...pg_array_as_varchar Read PostgreSQL arrays as varchar - enables reading mixed dimensional arrays false pg_connection_cache Whether or not to use the connection cache true pg_connection_limit The maximum amount of concurrent PostgreSQL connections 64 pg_...debug_show_queries DEBUG SETTING: print all queries sent to PostgreSQL to stdout false pg_experimental_filter_pushdown Whether or not to use filter pushdown (currently experimental) true pg_pages_per_task The amount of pages per task 1000 pg_use_bin...ary_copy Whether or not to use BINARY copy to read data true pg_null_byte_replacement When writing NULL bytes to Postgres, replace them wit... - https://man.mtool.work/duckdb/1.3/core_extensions/postgres.html
- DuckLake – DuckDB 8315
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s inserted in a given table between snapshots of given versions or timestamps. The function has two variants, depending on whether start_snapshot and end_snapshot have types BIGINT or TIMESTAMP WITH TIME ZONE . Parameter name Parameter type Named parame...deleted from a given table between snapshots of given versions or timestamps. The function has two variants, depending on whether start_snapshot and end_snapshot have types BIGINT or TIMESTAMP WITH TIME ZONE . Parameter name Parameter type Named parame...ws changed in a given table between snapshots of given versions or timestamps. The function has two variants, depending on whether start_snapshot and end_snapshot have types BIGINT or TIMESTAMP WITH TIME ZONE . Parameter name Parameter type Named parame... - https://man.mtool.work/duckdb/1.3/core_extensions/ducklake.html
DuckDB 1.3 Documentation / man.mtool.work