Results of 1 - 10 of about 61 for contain (0.007 sec.)
- Constraints – DuckDB 14002
- 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
...ns that do not satisfy this expression violate the constraint. For example, we could enforce that the name column does not contain spaces using the following CHECK constraint. CREATE TABLE students ( name VARCHAR CHECK ( NOT contains ( name , ' ' ))); I...NSERT INTO students VALUES ( 'this name contains spaces' ); Constraint Error: CHECK constraint failed on table students with expression CHECK((NOT contains("name", ' ')))...Not Null Constraint A not-null constraint specifies that the column cannot contain any NULL values. By default, all columns in tables are nullable. Adding NOT NULL to a column definition enforces that a co... - https://man.mtool.work/duckdb/1.3/sql/constraints.html
- CSV Import Tips – DuckDB 12393
- 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
.... In the examples, we use the flights.csv file. Override the Header Flag if the Header Is Not Correctly Detected If a file contains only string columns the header auto-detection might fail. Provide the header option to override this behavior. SELECT * F...ROM read_csv ( 'flights.csv' , header = true ); Provide Names if the File Does Not Contain a Header If the file does not contain a header, names will be auto-generated by default. You can provide your own names wi...e Blog In this article Override the Header Flag if the Header Is Not Correctly Detected Provide Names if the File Does Not Contain a Header Override the Types of Specific Columns Use COPY When Loading Data into a Table Use union_by_name When Loading Fil... - https://man.mtool.work/duckdb/1.3/data/csv/tips.html
- Dot Commands – DuckDB 11581
- 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
...wish to execute. Additional arguments to the command are entered, space separated, after the command. If an argument must contain a space, either single or double quotes may be used to wrap that parameter. Dot commands must be entered on a single line,...ng flight' AS output_column ; .output SELECT 'back to the terminal' AS displayed_column ; The file my_results.md will then contain: | output_column | |---------------| | taking flight | The terminal will then display: | displayed_column | |-------------..._file.csv SELECT 1 AS col_1 , 2 AS col_2 UNION ALL SELECT 10 AS col1 , 20 AS col_2 ; The file my_output_file.csv will then contain: col_1,col_2 1,2 10,20 By passing special options (flags) to the .once command, query results can also be sent to a tempor... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
- Indexing – DuckDB 9161
- 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. If a filter criterion (like WHERE column1 = 123 ) is in use, DuckDB can skip any row group whose min-max range does not contain that filter value (e.g., it can omit a block with a min-max range of 1000 to 2000 when comparing for = 123 or < 400 ). The...maps The more ordered the data within a column, the more valuable the zonemap indexes will be. For example, a column could contain a random number on every row in the worst case. Then, DuckDB will likely be unable to skip any row groups. If you query sp...R type with automatic increments rather than UUID for columns queried using selective filters. In a scenario where a table contains out-of-order UUID s, DuckDB has to scan many row groups to find a specific UUID value. An ordered INTEGER column allows s... - https://man.mtool.work/duckdb/1.3/guides/performance/indexing.html
- Literal Types – DuckDB 9161
- 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
...ifiers . Implicit String Literal Concatenation Consecutive single-quoted string literals separated only by whitespace that contains at least one newline are implicitly concatenated: SELECT 'Hello' ' ' 'World' AS greeting ; is equivalent to: SELECT 'Hell...ar symbols to allow for the use of regular double-dollar symbols within the string literal: SELECT $ tag $ this string can contain newlines , 'single quotes' , "double quotes" , and $$ dollar quotes $$ $ tag $ AS msg ; ┌─────────────────────────────────...har │ ├────────────────────────────────────────────────────────────────────────────────────────────────┤ │ this string can contain newlines,\n'single quotes',\n"double quotes",\nand $$dollar quotes$$ │ └──────────────────────────────────────────────────... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- SELECT Statement – DuckDB 9161
- 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
.... While it appears first in the clause, logically the expressions here are executed only at the end. The SELECT clause can contain arbitrary expressions that transform the output, as well as aggregates and window functions. The DISTINCT keyword ensures...remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple tables that are joined together, or another SELECT query inside a subquery node.... - https://man.mtool.work/duckdb/1.3/sql/statements/select.html
- File Formats – DuckDB 8755
- 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
...tors. Reasons for Querying Parquet Files Availability of basic statistics: Parquet files use a columnar storage format and contain basic statistics such as zonemaps . Thanks to these features, DuckDB can leverage optimizations such as projection and fil...arquet files do not have. These improve the accuracy of cardinality estimates, and are especially important if the queries contain a large number of join operators. Tip. If you find that DuckDB produces a suboptimal join order on Parquet files, try load... - https://man.mtool.work/duckdb/1.3/guides/performance/file_formats.html
- Vectors – DuckDB 8349
- 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
...ing the duckdb_vector_get_data method. The array can then be accessed using the correct native type. Below is a table that contains a mapping of the duckdb_type to the native type of the array. duckdb_type NativeType DUCKDB_TYPE_BOOLEAN bool DUCKDB_TYPE...UCKDB_TYPE_TIMESTAMP_TZ duckdb_timestamp NULL Values Any value in a vector can be NULL . When a value is NULL , the values contained within the primary array at that index is undefined (and can be uninitialized). The validity mask is a bitmask consistin...ionary is the same for the entire column – and so only needs to be constructed once. Structs Structs are nested types that contain any number of child types. Think of them like a struct in C. The way to access struct data using vectors is to access the... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
- Complete API – DuckDB 7537
- 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 and Format Execution Format Pivot Sitemap Live Demo Documentation / Client APIs / C Copy Markdown Complete API This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-te...e reason that the methods are already deprecated in v1.0 is to denote that they are not part of the v1.0 stable API, which contains methods that are available long-term. API Reference Overview Open Connect duckdb_instance_cache duckdb_create_instance_ca...fig : (Optional) configuration used to create the database. out_error : If set and the function returns DuckDBError , this contains the error message. Note that the error message must be freed using duckdb_free . Return Value DuckDBSuccess on success or... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Table Functions – DuckDB 7537
- 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_function , duckdb_logical_type type ); Parameters table_function : The table function. type : The parameter type. Cannot contain INVALID. duckdb_table_function_add_named_parameter Adds a named parameter to the table function. Syntax void duckdb_table_..._type type ); Parameters table_function : The table function. name : The parameter name. type : The parameter type. Cannot contain INVALID. duckdb_table_function_set_extra_info Assigns extra information to the table function that can be fetched during b... - https://man.mtool.work/duckdb/1.3/clients/c/table_functions.html
DuckDB 1.3 Documentation / man.mtool.work