Results of 1 - 10 of about 66 for whether (0.003 sec.)
- Configuration 13271
- 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
...s_mode Access mode of the database ( AUTOMATIC , READ_ONLY or READ_WRITE ). VARCHAR automatic allocator_background_threads Whether to enable the allocator background threads. BOOLEAN false allocator_bulk_deallocation_flush_threshold If a bulk deallocati...alse allow_community_extensions Allow loading extensions build by the community. BOOLEAN true allow_extension_repositories Whether custom trusted extension repositories are 'allowed', 'forbidden' (which also distrusts existing repositories) or 'undecide...tables in a join to determine the optimal join order approximately instead of exactly. UBIGINT 12 arrow_large_buffer_size Whether Arrow buffers for strings, blobs, UUIDs and bits should be exported using large buffers. BOOLEAN false arrow_lossless_conv... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- PostgreSQL Extension Functions 11087
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...to be re-read on the next access. Parameters None. Returns A table with the following columns: Success ( BOOLEAN ): a flag whether the cache clearing was successful Currently the table result is always returned with zero rows, so the flag value is not a...quiring a connection from a pool where all available connections are already taken. enable_thread_local_cache ( BOOLEAN ): whether to enable the connection caching in thread-local cache. Such connections are getting pinned to the threads and are not mad...( enable_reaper_thread option), then this number is checked in background periodically. enable_reaper_thread ( BOOLEAN ): whether to enable the connection pool reaper thread, that periodically scans the pool to check the max_lifetime_millis and idle_ti... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Excel Extension 10588
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...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/2.0/core_extensions/excel.html
- MySQL Extension 10203
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...he wire, and DISCONNECT returns the session to the local database. Settings Name Description Default mysql_bit1_as_boolean Whether or not to convert BIT(1) columns to BOOLEAN true mysql_debug_show_queries DEBUG SETTING: print all queries sent to MySQL t...o stdout false mysql_enable_filter_pushdown Whether or not to use filter pushdown (without predicate analyzer) true mysql_enable_transactions Whether to run START TRANSACTION.../ COMMIT / ROLLBACK on MySQL connections true mysql_incomplete_dates_as_nulls Whether to return DATE s with a zero month or day as NULL s false mysql_pool_acquire_mode How to acquire connections from the pool... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Full-Text Search Extension 9560
- Full-Text Search is an extension to DuckDB that allows for search through strings, similar to SQLite's FTS5 extension . Installing and Loading The fts extension will be transparently autoloaded on first use from the official extension repos
...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 incremental BOOLEAN Whether to maintain the FTS index with trigge...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/2.0/core_extensions/full_text_search.html
- COPY Statement 9432
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...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 options that write multiple fil...with PARTITION_BY , the rows are sorted within each partition. Added in DuckDB 2.0. expression list (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/2.0/sql/statements/copy.html
- Loading JSON 9304
- 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
...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 1.3.0, the filename column is added automat...easons. BOOL false format Can be one of auto , unstructured , newline_delimited and array . VARCHAR auto hive_partitioning Whether or not to interpret the path as a Hive partitioned path . BOOL (auto-detected) ignore_errors Whether to ignore parse error...e parameter name must be quoted, e.g., read_json('my_file.json', "array" = true) . Added in DuckDB 2.0. BOOL - 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/2.0/data/json/loading_json.html
- Reading and Writing Parquet Files 9047
- 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_by_name or allow_empty , and requires hive_partitioning to be set explicitly. Added in DuckDB 2.0. STRUCT - can_have_nan Whether FLOAT and DOUBLE columns may contain NaN values. When set to true, the reader accounts for NaN when using a column's min/m...nce NaN does not compare as ordered. 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 1.3.0, the filename column is added automat...ically 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... - https://man.mtool.work/duckdb/2.0/data/parquet/overview.html
- Variant Functions 8918
- This section describes functions that operate on the VARIANT type . New Most variant_* functions were introduced in DuckDB 2.0. The variant_extract , variant_normalize and variant_typeof functions were already available in DuckDB 1.5. Name
...lue as a VARCHAR . variant_array_length(v) Return the number of elements in a VARIANT array. variant_exists(v, key) Return whether the given key exists in a VARIANT object. variant_contains(haystack, needle) Return whether the needle VARIANT is containe...Example | variant_array_length('[1, 2, 3]'::JSON::VARIANT) | | Result | 3 | variant_exists(v, key) | Description | Return whether the given key exists in a VARIANT object. | | Example | variant_exists('{"a": 1}'::JSON::VARIANT, 'a') | | Result | true |...variant_contains(haystack, needle) | Description | Return whether the needle VARIANT is contained in the haystack VARIANT . | | Example | variant_contains('{"user": {"id": 42}}'::JSON::VAR... - https://man.mtool.work/duckdb/2.0/sql/functions/variant.html
- PostgreSQL Extension 8533
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...varchar Read PostgreSQL arrays as varchar - enables reading mixed dimensional arrays false pg_connection_cache Deprecated: whether or not to use connection pooling. To disable pooling, use SET pg_pool_max_connections = 0 instead (see Connection Pool ) t...cores pg_debug_show_queries DEBUG SETTING: print all queries sent to PostgreSQL to stdout false pg_enable_filter_pushdown Whether or not to use filter pushdown true pg_idle_in_transaction_timeout_millis PostgreSQL idle_in_transaction_session_timeout in...g_statement_timeout_millis PostgreSQL statement timeout in milliseconds to set on scan connections NULL pg_use_binary_copy Whether or not to use BINARY copy to read data true pg_use_ctid_scan Whether or not to parallelize scanning using table ctids true... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
DuckDB 2.0 Documentation / man.mtool.work