Results of 1 - 10 of about 20 for entry (0.003 sec.)
- Struct Functions – DuckDB 14206
- 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
...tion Format Pivot Sitemap Live Demo Documentation / SQL / Functions Copy Markdown Struct Functions Name Description struct.entry Dot notation that serves as an alias for struct_extract from named STRUCT s. struct[entry] Bracket notation that serves as...g the argument values. struct_concat(structs...) Merge the multiple structs into a single STRUCT . struct_extract(struct, 'entry') Extract the named entry from the STRUCT . struct_extract(struct, idx) Extract the entry from an unnamed STRUCT (tuple) u...sing an index (1-based). struct_extract_at(struct, idx) Extract the entry from a STRUCT (tuple) using an index (1-based). struct_insert(struct, name := any, ...) Add field(s)/value(s) to an existi... - https://man.mtool.work/duckdb/1.3/sql/functions/struct.html
- Editing – DuckDB 10875
- 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
...t Move back a character Right Move forward a character Up Move up a line. When on the first line, move to previous history entry Down Move down a line. When on last line, move to next history entry Home Move to beginning of buffer End Move to end of b...character Alt + Left Move back a word Alt + Right Move forward a word History Key Action Ctrl + P Move to previous history entry Ctrl + N Move to next history entry Ctrl + R Search the history Ctrl + S Search the history Alt + < Move to first history...entry Alt + > Move to last history entry Alt + N Search the history Alt + P Search the history Changing Text Key Action Backspace Delete previous character Delete... - https://man.mtool.work/duckdb/1.3/clients/cli/editing.html
- Full-Text Search – DuckDB 10247
- 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
...L NULL play_name VARCHAR YES NULL NULL NULL line_number VARCHAR YES NULL NULL NULL speaker VARCHAR YES NULL NULL NULL text_entry VARCHAR YES NULL NULL NULL The text of each line is in text_entry , and a unique key for each line is in line_id . Creatin...ex, specifying the table name, the unique id column, and the column(s) to index. We will just index the single column text_entry , which contains the text of the lines in the play. PRAGMA create_fts_index ( 'corpus' , 'line_id' , 'text_entry' ); The t...ay about butter? SELECT fts_main_corpus. match_bm25 ( line_id , 'butter' ) AS score , line_id , play_name , speaker , text_entry FROM corpus WHERE score IS NOT NULL ORDER BY score DESC ; score line_id play_name speaker text_entry 4.427313429798464 H4/... - https://man.mtool.work/duckdb/1.3/guides/sql_features/full_text_search.html
- Vectors – DuckDB 9601
- 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
..., the duckdb_enum_dictionary_value function must be used to obtain the enum value that corresponds to the given dictionary entry. Note that the enum dictionary is the same for the entire column – and so only needs to be constructed once. Structs Struc...et_child method. The duckdb_vector_get_data must be used to get the offsets and lengths of the lists stored as duckdb_list_entry , that can then be applied to the child vector. typedef struct { uint64_t offset ; uint64_t length ; } duckdb_list_entry ;...w. Think of them like a fixed-size array in C. Arrays work exactly the same as lists, except the length and offset of each entry is fixed. The fixed array size can be obtained by using duckdb_array_type_array_size . The data for entry n then resides a... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
- Unnesting – DuckDB 9312
- 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
...l ); Empty result: SELECT unnest ([]); Empty result: SELECT unnest ( NULL ); Using unnest on a list emits one row per list entry. Regular scalar expressions in the same SELECT clause are repeated for every emitted row. When multiple lists are unnested...nerating two columns (a, b): SELECT unnest ({ 'a' : 42 , 'b' : { 'x' : 84 }}); unnest on a struct will emit one column per entry in the struct. Recursive Unnest Unnesting a list of lists recursively, generating 5 rows (1, 2, 3, 4, 5): SELECT unnest ([..., [[ 5 , 6 ], [ 7 , 8 , 9 ], []], [[ 10 , 11 ]]], max_depth : = 3 ) AS x ; x 1 2 3 4 5 6 7 8 9 10 11 Keeping Track of List Entry Positions To keep track of each entry's position within the original list, unnest may be combined with generate_subscripts... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/unnest.html
- Map Functions – DuckDB 9176
- 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
...value is taken from the last map with that key. map_contains(map, key) Checks if a map contains a given key. map_contains_entry(map, key, value) Check if a map contains a given key-value pair. map_contains_value(map, value) Checks if a map contains a...urn a list of all keys in the map. map_values(map) Return a list of all values in the map. map() Returns an empty map. map[entry] Returns the value for a given key or NULL if the key is not contained in the map. The type of the key provided in the sec...map contains a given key. Example map_contains(MAP {'key1': 10, 'key2': 20, 'key3': 30}, 'key2') Result true map_contains_entry(map, key, value) Description Check if a map contains a given key-value pair. Example map_contains_entry(MAP {'key1': 10, '... - https://man.mtool.work/duckdb/1.3/sql/functions/map.html
- DROP Statement – DuckDB 8683
- 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
...Pivot Sitemap Live Demo Documentation / SQL / Statements Copy Markdown DROP Statement The DROP statement removes a catalog entry added previously with the CREATE command. Examples Delete the table with the name tbl : DROP TABLE tbl ; Drop the view wit...s DuckDB performs limited dependency tracking for some object types. By default or if the RESTRICT clause is provided, the entry will not be dropped if there are any other objects that depend on it. If the CASCADE clause is provided then all the objec...ell. CREATE SCHEMA myschema ; CREATE TABLE myschema.t1 ( i INTEGER ); DROP SCHEMA myschema ; Dependency Error: Cannot drop entry "myschema" because there are entries that depend on it. table "t1" depends on schema "myschema". Use DROP...CASCADE to dro... - https://man.mtool.work/duckdb/1.3/sql/statements/drop.html
- Execution Format – DuckDB 8038
- 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
...the values that are present in the list, and the list entries specify how each individual list is constructed. struct list_entry_t { idx_t offset ; idx_t length ; }; The offset refers to the start row in the child Vector, the length keeps track of the...vector. For example, consider this mock representation of a Vector of type BIGINT[][] : { "type" : "list" , "data" : "list_entry_t" , "child" : { "type" : "list" , "data" : "list_entry_t" , "child" : { "type" : "bigint" , "data" : "int64_t" } } } Stru... - https://man.mtool.work/duckdb/1.3/internals/vector.html
- DuckDB_% Metadata Functions – DuckDB 8038
- 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
...unction returns a table of DuckDB log entries. Column Description Type context_id The identifier of the context of the log entry. Foreign key to the duckdb_log_contexts table. UBIGINT timestamp The timestamp of the log entry. TIMESTAMP type The type o...f the log entry. TODO: ?? VARCHAR log_level The level of the log entry ( TRACE , DEBUG , INFO , WARN , ERROR or FATAL ). VARCHAR message T...he message of the log entry. VARCHAR duckdb_memory The duckdb_memory() function provides metadata about DuckDB's buffer manager. Column Description Ty... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Values – DuckDB 7766
- 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
...duckdb_value duckdb_create_map_value ( duckdb_logical_type map_type , duckdb_value * keys , duckdb_value * values , idx_t entry_count ); duckdb_value duckdb_create_union_value ( duckdb_logical_type union_type , idx_t tag_index , duckdb_value value );...eate_map_value Creates a map value from a map type and two arrays, one for the keys and one for the values, each of length entry_count . Must be destroyed with duckdb_destroy_value . Syntax duckdb_value duckdb_create_map_value ( duckdb_logical_type ma...p_type , duckdb_value * keys , duckdb_value * values , idx_t entry_count ); Parameters map_type : The map type keys : The keys of the map values : The values of the map entry_count : The nu... - https://man.mtool.work/duckdb/1.3/clients/c/value.html
DuckDB 1.3 Documentation / man.mtool.work