Results of 1 - 10 of about 210 for used (0.005 sec.)
- CSV Import – DuckDB 9382
- 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 VARCHAR type is always included as a fallback option. See example . TYPE[] default types buffer_size Size of the buffers used to read files, in bytes. Must be large enough to hold four lines and can significantly impact performance. BIGINT 16 * max....g., {'col1': 'INTEGER', 'col2': 'VARCHAR'} ). Using this option disables auto detection. STRUCT (empty) comment Character used to initiate comments. Lines starting with a comment character (optionally preceded by space characters) are completely ign...ored; other lines containing a comment character are parsed only up to that point. VARCHAR (empty) compression Method used to compress CSV files. By default this is detected automatically from the file extension (e.g., t.csv.gz will use gzip, t.... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
- Reading Faulty CSV Files – DuckDB 9128
- 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
...field as a VARCHAR or fully utilizing the dataset for type detection. Finally, the last block presents some of the options used in the scanner that can cause errors, indicating whether they were auto-detected or manually set by the user. Using the ig...actly which lines are corrupted and what errors the parser discovered on them. For scenarios like these, it is possible to use DuckDB's CSV Rejects Table feature. By default, this feature creates two temporary tables. reject_scans : Stores informatio...t Scans The CSV Reject Scans Table returns the following information: Column name Description Type scan_id The internal ID used in DuckDB to represent that scanner UBIGINT file_id A scanner might happen over multiple files, so the file_id represents... - https://man.mtool.work/duckdb/1.3/data/csv/reading_faulty_csv_files.html
- Dot Commands – DuckDB 8789
- 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
...re 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, and no whitespace may occur before the period. No s...of rows changed by SQL .columns Column-wise rendering of query results .constant COLOR Sets the syntax highlighting color used for constant values .constantcode CODE Sets the syntax highlighting terminal code used for constant values .databases List...LE Import data from FILE into TABLE .indexes TABLE Show names of indexes .keyword COLOR Sets the syntax highlighting color used for keywords .keywordcode CODE Sets the syntax highlighting terminal code used for keywords .large_number_rendering all/fo... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
- ODBC 101: A Duck Themed Guide to ODBC – DuckDB 8620
- 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
...using a native driver, as it adds an extra layer of abstraction between the application and the database. Furthermore, because DuckDB is column-based and ODBC is row-based, there can be some inefficiencies when using ODBC with DuckDB. There are links...ecting Error Handling and Diagnostics Buffers and Binding Handles A handle is a pointer to a specific ODBC object which is used to interact with the database. There are several different types of handles, each with a different purpose, these are the...the end. Connection Handle name Connection Type name SQL_HANDLE_DBC Description Represents a connection to a data source. Used to establish, manage, and terminate connections. Defines both the driver and the data source to use within the driver. Use... - https://man.mtool.work/duckdb/1.3/guides/odbc/general.html
- Result Verification – DuckDB 8366
- 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
...ge of types in the sqllogictest. The DuckDB test runner does not use or need them internally – therefore, only I should be used to denote columns. NULL Values and Empty Strings Empty lines have special significance for the SQLLogic test runner: they...an end of the current statement or query. For that reason, empty strings and NULL values have special syntax that must be used in result verification. NULL values should use the string NULL , and empty strings should use the string (empty) , e.g.: q...---- NULL ( empty ) Error Verification In order to signify that an error is expected, the statement error indicator can be used. The statement error also takes an optional expected result – which is interpreted as the expected error message . Similar... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/result_verification.html
- CLI Client – DuckDB 8281
- 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
...I To exit the CLI, press Ctrl + D if your platform supports it. Otherwise, press Ctrl + C or use the .exit command. If you used a persistent database, DuckDB will automatically checkpoint (save the latest edits to disk) and close. This will remove th...re 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, and no whitespace may occur before the period. No s...emicolon is required at the end of the line. Frequently-used configurations can be stored in the file ~/.duckdbrc , which will be loaded when starting the CLI client. See the Configur... - https://man.mtool.work/duckdb/1.3/clients/cli/overview.html
- Secrets Manager – DuckDB 7773
- 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
...rets can be created using the CREATE SECRET SQL statement . Secrets can be temporary or persistent . Temporary secrets are used by default – and are stored in-memory for the life span of the DuckDB instance similar to how settings worked previously....are read from this directory and automatically loaded. Secret Providers To create a secret, a Secret Provider needs to be used. A Secret Provider is a mechanism through which a secret is generated. To illustrate this, for the S3 , GCS , R2 , and AZU...l_chain provider will automatically try to fetch credentials. When no Secret Provider is specified, the CONFIG provider is used. For more details on how to create secrets using different providers check out the respective pages on httpfs and azure .... - https://man.mtool.work/duckdb/1.3/configuration/secrets_manager.html
- Full-Text Search Extension – DuckDB 7773
- 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
...PRAGMA statements to DuckDB: one to create, and one to drop an index. Additionally, a scalar macro stem is added, which is used internally by the extension. PRAGMA create_fts_index create_fts_index ( input_table , input_id , * input_values , stemmer..._2' , …, 'text_field_N' , or '\*' for all columns in input_table of type VARCHAR stemmer VARCHAR The type of stemmer to be used. One of 'arabic' , 'basque' , 'catalan' , 'danish' , 'dutch' , 'english' , 'finnish' , 'french' , 'german' , 'greek' , 'hi...se' , '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... - https://man.mtool.work/duckdb/1.3/core_extensions/full_text_search.html
- Loops – DuckDB 7593
- 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
...and Format Execution Format Pivot Sitemap Live Demo Documentation / Development / Testing Copy Markdown Loops Loops can be used in sqllogictests when it is required to execute the same query many times but with slight modifications in constant values...= $ { i }; ---- 1 # end the loop ( note that multiple statements can be part of a loop ) endloop Similarly, foreach can be used to iterate over a set of values. foreach partcode millennium century decade year quarter month day hour minute second mill...OM intervals WHERE p <> st [ '${partcode}' ]; ---- endloop foreach also has a number of preset combinations that should be used when required. In this manner, when new combinations are added to the preset, old tests will automatically pick up these n... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/loops.html
- Collations – DuckDB 7423
- 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
...se which collation they want to use when performing sorting and comparison operations. By default, the BINARY collation is used. That means that strings are ordered and compared based only on their binary contents. This makes sense for standard ASCII...ify a default collator, either on the global database level or on a base table column. The PRAGMA default_collation can be used to specify the global default collator. This is the collator that will be used if no other one is specified. SET default_c...ELECT 'hello' = 'HeLlo' ; true Collations can also be specified per-column when creating a table. When that column is then used in a comparison, the per-column collation is used to perform that comparison. CREATE TABLE names ( name VARCHAR COLLATE NO... - https://man.mtool.work/duckdb/1.3/sql/expressions/collations.html
DuckDB 1.3 Documentation / man.mtool.work