Results of 1 - 5 of about 5 for insertions (0.002 sec.)
- DuckLake 11803
- DuckLake 1.1 was released together with DuckDB 2.0. Read the announcement blog post . The ducklake extension adds support for attaching to databases stored in the DuckLake format . The complete documentation of this extension is available a
...e_uuid UUID file_count BIGINT file_size_bytes BIGINT delete_file_count BIGINT delete_file_size_bytes BIGINT ducklake_table_insertions The ducklake_table_insertions function returns the rows inserted in a given table between snapshots of given versions or t... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- INSERT Statements 10405
- INSERT statements are the standard way of loading data into a relational database. When using INSERT statements, the values are supplied row-by-row. While simple, there is significant overhead involved in parsing and processing individual I
...NSERT statements. This makes lots of individual row-by-row insertions very inefficient for bulk insertion. Bestpractice As a rule-of-thumb, avoid using lots of individual row-by-row INSERT sta... - https://man.mtool.work/duckdb/2.0/data/insert.html
- Text Functions 9468
- 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
...transposition of adjacent characters as an allowed edit operation. In other words, the minimum number of edit operations (insertions, deletions, substitutions or transpositions) required to change one string to another. Characters of different cases (e.g....off , 0 is returned instead. score_cutoff defaults to 0. levenshtein(s1, s2) The minimum number of single-character edits (insertions, deletions or substitutions) required to change one string to the other. Characters of different cases (e.g., a and A ) ar...transposition of adjacent characters as an allowed edit operation. In other words, the minimum number of edit operations (insertions, deletions, substitutions or transpositions) required to change one string to another. Characters of different cases (e.g.... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- R-Tree Indexes 7133
- The spatial extension provides support for spatial indexing through the R-tree extension index type. Why Should I Use an R-Tree Index? When working with geospatial datasets, it is very common that you want to filter rows based on their spat
...ment with the max_node_capacity and min_node_capacity options to change the structure of the R-tree and how it responds to insertions and deletions, see the full list of options here . In general, a tree with a higher total number of nodes (i.e., a lower m... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- CREATE TABLE Statement 7133
- The CREATE TABLE statement creates a table in the catalog. Examples Create a table with two integer columns ( i and j ): CREATE TABLE t1 (i INTEGER, j INTEGER); Create a table with a primary key: CREATE TABLE t1 (id INTEGER PRIMARY KEY, j V
...ype. This allows you to leave out the type when declaring a generated column. It is possible to explicitly set a type, but insertions into the referenced columns might fail if the type cannot be cast to the type of the generated column. Generated columns c... - https://man.mtool.work/duckdb/2.0/sql/statements/create_table.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work