Results of 1 - 10 of about 38 for defaults (0.003 sec.)
- Full-Text Search Extension 14340
- 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
...'romanian' , 'russian' , 'serbian' , 'spanish' , 'swedish' , 'tamil' , 'turkish' , or 'none' if no stemming is to be used. Defaults to 'porter' stopwords VARCHAR Qualified name of table containing a single VARCHAR column containing the desired stopwords,...or 'none' if no stopwords are to be used. Defaults to 'english' for a pre-defined list of 571 English stopwords ignore VARCHAR Regular expression of patterns to be ignored....l 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 exist... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
- Text Functions 11761
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
..., max[, width]) Draws a band whose width is proportional to ( x - min ) and equal to width characters when x = max . width defaults to 80. base64(blob) Alias for to_base64 . bin(string) Converts the string to binary representation. bit_length(string) Num...ltrim(string[, characters]) Removes any occurrences of any of the characters from the left side of the string . characters defaults to space . md5(string) Returns the MD5 hash of the string as a VARCHAR . md5_number(string) Returns the MD5 hash of the st...the path similarly to Python's os.path.basename function. If trim_extension is true , the file extension will be removed (defaults to false ). separator options: system , both_slash (default), forward_slash , backslash . parse_path(path[, separator]) Re... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Struct Functions 11635
- The functions on this page work on STRUCT values . Functions that access entries by position, such as struct[idx] , struct_extract_at , struct_contains , struct_position and struct_values , also accept TUPLE values , i.e., structs with unna
...at serves as an alias for struct_extract from TUPLE s, using an index (1-based). remap_struct(input, target_type, mapping, defaults) Remap a STRUCT , LIST , or MAP value into the shape given by the type of target_type , renaming and reordering fields, de...scending into nested types, and filling missing fields from defaults . row(any, ...) Create a TUPLE containing the argument values. struct_concat(structs...) Merge the multiple structs into a...LE s, using an index (1-based). | | Example | (row(42, 84))[1] | | Result | 42 | remap_struct(input, target_type, mapping, defaults) | Description | Remap an input value of type STRUCT , LIST , or MAP into the shape declared by the type of target_type ,... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- CREATE SEQUENCE Statement 9544
- The CREATE SEQUENCE statement creates a new sequence number generator. Examples Generate an ascending sequence starting from 1: CREATE SEQUENCE serial; Generate sequence from a given start number: CREATE SEQUENCE serial START 101; Generate
...ced in DuckDB 2.0. Use setval to set a sequence to a given value (PostgreSQL-style). The optional third argument is_called defaults to true : the next nextval returns value + increment . If is_called is false , the next nextval returns value . CREATE SEQ...value for the sequence. If this clause is not supplied or NO MAXVALUE is specified, then default values will be used. The defaults are 2^63 - 1 and -1 for ascending and descending sequences, respectively. minvalue The optional clause MINVALUE minvalue d...etermines the minimum value a sequence can generate. If this clause is not supplied or NO MINVALUE is specified, then defaults will be used. The defaults are 1 and -(2^63 - 1) for ascending and descending sequences, respectively. name The name (opti... - https://man.mtool.work/duckdb/2.0/sql/statements/create_sequence.html
- SET and RESET Statements 9182
- The SET statement modifies the provided DuckDB configuration option at the specified scope. Examples Update the memory_limit configuration value: SET memory_limit = '10GB'; Configure the system to use 1 thread: SET threads = 1; Or use the T
...eads'); Set the default collation for the session: SET SESSION default_collation = 'nocase'; Set a Global Variable Set the default sort order globally: SET GLOBAL default_order = 'DESC'; Set the default threads globally: SET GLOBAL threads = 4; Syntax SE...or reset) only for the current session attached to a DuckDB instance. LOCAL : Not yet implemented. When not specified, the default scope for the configuration option is used. For most options this is GLOBAL . GLOBAL settings apply to the current DuckDB i...kDB instances. If all connections to an instance are closed and a new instance is started, configuration options use their defaults unless they are set again. For example, in DuckDB 2.0 the TimeZone option defaults to the SESSION scope, so the following... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
- Configuration 8695
- 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
...ther with the related http_client_pool_capacity setting. Configuration Reference Configuration options come with different default scopes : GLOBAL and LOCAL . Below is a list of all available configuration options by scope. Global Configuration Options N...The order type used when none is specified ( ASC or DESC ). VARCHAR ASCENDING default_secret_storage Allows switching the default storage for secrets. VARCHAR local_file default_transaction_invalidation_policy When to invalidate transactions when errors..._minimum_shredding_size Minimum size of a row group to enable GEOMETRY shredding. Set to -1 to disable shredding entirely. Defaults to 1/4th of a row group. BIGINT 30000 home_directory Sets the home directory of the database instance. VARCHAR http_client... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Window Functions 8569
- DuckDB supports window functions , which can use multiple rows to calculate a value for each row. Window functions are blocking operators , i.e., they require their entire input to be buffered, making them one of the most memory-intensive o
...t be of the same type as expr ). Both offset and default are evaluated with respect to the current row. If omitted, offset defaults to 1 and default to NULL . last_value(expr[ ORDER BY ordering][ IGNORE NULLS]) Returns expr evaluated at the row that is t...t be of the same type as expr ). Both offset and default are evaluated with respect to the current row. If omitted, offset defaults to 1 and default to NULL . nth_value(expr, nth[ ORDER BY ordering][ IGNORE NULLS]) Returns expr evaluated at the nth row (...t be of the same type as expr ). Both offset and default are evaluated with respect to the current row. If omitted, offset defaults to 1 and default to NULL . If an ORDER BY clause is specified, the lagged row number is computed within the frame using th... - https://man.mtool.work/duckdb/2.0/sql/functions/window_functions.html
- Regular Expressions 8192
- DuckDB offers pattern matching operators ( LIKE , SIMILAR TO , GLOB ), as well as support for regular expressions via functions. Regular Expression Syntax DuckDB uses the RE2 library as its regular expression engine. For the regular express
...tional parameter group ; otherwise, returns the empty string. The group must be a constant value. If no group is given, it defaults to 0. A set of optional options can be set. regexp_extract(string, pattern, name_list[, options]) If string contains the r...tional parameter group ; otherwise, returns the empty string. The group must be a constant value. If no group is given, it defaults to 0. A set of optional options can be set. | | Example | regexp_extract('abc', '([a-z])(b)', 1) | | Result | a | regexp_e...n. A specific capturing group within the pattern can be extracted using the group parameter. If group is not specified, it defaults to 0, extracting the first match with the whole pattern. SELECT regexp_extract('abc', '.b.'); -- abc SELECT regexp_extract... - https://man.mtool.work/duckdb/2.0/sql/functions/regular_expressions.html
- Timestamp with Time Zone Functions 8192
- This section describes functions and operators for examining and manipulating TIMESTAMP WITH TIME ZONE (or TIMESTAMPTZ ) values . See also the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In th
...mptz[, origin]) Truncate timestamptz to a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00+00:00 when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00+00:00 . No...tz[, timezone]) Truncate timestamptz to a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00 in the provided timezone when bucket_width is a number of months or coarser units, else 2000-01-03...| Description | Truncate timestamptz to a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00+00:00 when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00+00:00 . No... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- I/O 7956
- 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
...rm the actual query processing (e.g., decoding, joins and aggregations). Its size is controlled by the threads setting and defaults to the number of CPU cores. Regular threads prioritize query processing but can also perform I/O tasks when idle. The asyn...ry frees up, the queue fills up again. To limit the total memory used by DuckDB, use the memory_limit setting . Tuning The default settings work well in most cases. On machines with high network bandwidth, you can further increase throughput by fixing th... - https://man.mtool.work/duckdb/2.0/data/io.html
DuckDB 2.0 Documentation / man.mtool.work