Results of 1 - 10 of about 81 for option (0.016 sec.)
- Configuration – DuckDB 11720
- 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
...Format Execution Format Pivot Sitemap Live Demo Documentation / Client APIs / C Copy Markdown Configuration Configuration options can be provided to change different settings of the database system. Note that many of these settings can be changed late...configuration object if ( duckdb_create_config ( & config ) == DuckDBError ) { // handle error } // set some configuration options duckdb_set_config ( config , "access_mode" , "READ_WRITE" ); // or READ_ONLY duckdb_set_config ( config , "threads" , "8"...const char ** out_description ); duckdb_state duckdb_set_config ( duckdb_config config , const char * name , const char * option ); void duckdb_destroy_config ( duckdb_config * config ); duckdb_create_config Initializes an empty configuration object t... - https://man.mtool.work/duckdb/1.3/clients/c/config.html
- CSV Import – DuckDB 11064
- 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 Copy Markdown CSV Import Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv' ; Use the read_csv function with custom options: SELECT * FROM read_csv ( 'flights.csv' , de...iqueCarrier' : 'VARCHAR' , 'OriginCityName' : 'VARCHAR' , 'DestCityName' : 'VARCHAR' }); Read a CSV from stdin, auto-infer options: cat flights.csv | duckdb -c "SELECT * FROM read_csv('/dev/stdin')" Read a CSV file into a table: CREATE TABLE ontime ( F...use by analyzing the CSV file using the CSV sniffer . This will work correctly in most situations, and should be the first option attempted. In rare situations where the CSV reader cannot figure out the correct configuration it is possible to manually... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
- Excel Extension – DuckDB 10395
- 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
...LECT ing from it immediately, e.g.: SELECT * FROM 'test.xlsx' ; a b 1.0 2.0 3.0 4.0 However, if you want to set additional options to control the import process, you can use the read_xlsx function instead. The following named parameters are supported....pty BOOLEAN automatically inferred Whether to stop reading the file when an empty row is encountered. If an explicit range option is provided, this is false by default, otherwise true . empty_as_varchar BOOLEAN false Whether to treat empty cells as VAR...FROM read_xlsx ( 'test.xlsx' , header = true ); a b 1.0 2.0 3.0 4.0 Alternatively, the COPY statement with the XLSX format option can be used to import an Excel file into an existing table, in which case the types of the columns in the target table wil... - https://man.mtool.work/duckdb/1.3/core_extensions/excel.html
- CSV Auto Detection – DuckDB 10286
- 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 of each of the columns Detect whether or not the file has a header row By default the system will try to auto-detect all options. However, options can be individually overridden by the user. This can be useful in case the system makes a mistake. For...ename) function, which returns the detected CSV properties as a table with a single row. The sniff_csv function accepts an optional sample_size parameter to configure the number of rows sampled. FROM sniff_csv ( 'my_file.csv' ); FROM sniff_csv ( 'my_fi...of candidate types that should be considered by the CSV reader can be explicitly specified using the auto_type_candidates option. In addition to the default set of candidate types, other types that may be specified using the auto_type_candidates optio... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
- SET and RESET Statements – DuckDB 9958
- 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
...ion / SQL / Statements Copy Markdown SET and RESET Statements 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 sy...stem to use 1 thread: SET threads = 1 ; Or use the TO keyword: SET threads TO 1 ; Change configuration option to default value: RESET threads ; Retrieve configuration value: SELECT current_setting ( 'threads' ); Set the default coll...sort_order = 'desc' ; Set the default threads globally: SET GLOBAL threads = 4 ; Syntax SET updates a DuckDB configuration option to the provided value. RESET The RESET statement changes the given DuckDB configuration option to the default value. Scope... - https://man.mtool.work/duckdb/1.3/sql/statements/set.html
- ADBC Client – DuckDB 9848
- 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
...ninitialized) database. (AdbcDatabase *database, AdbcError *error) AdbcDatabaseNew(&adbc_database, &adbc_error) DatabaseSetOption Set a char* option. (AdbcDatabase *database, const char *key, const char *value, AdbcError *error) AdbcDatabaseSetOption(&...adbc_database, "path", "test.db", &adbc_error) DatabaseInit Finish setting options and initialize the database. (AdbcDatabase *database, AdbcError *error) AdbcDatabaseInit(&adbc_database, &adbc_error) Dat...but uninitialized) connection. (AdbcConnection*, AdbcError*) AdbcConnectionNew(&adbc_connection, &adbc_error) ConnectionSetOption Options may be set before ConnectionInit. (AdbcConnection*, const char*, const char*, AdbcError*) AdbcConnectionSetOption(... - https://man.mtool.work/duckdb/1.3/clients/adbc.html
- Vector Similarity Search Extension – DuckDB 9521
- 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
...squared) metric, matching DuckDBs array_distance function, but other distance metrics can be used by specifying the metric option during index creation. For example: CREATE INDEX my_hnsw_cosine_index ON my_vector_table USING HNSW ( vec ) WITH ( metric...tionally, you can also create multiple HNSW indexes to the same column, each supporting a different distance metric. Index Options Besides the metric option, the HNSW index creation statement also supports the following options to control the hyperpara...meters of the index construction and search process: Option Default Description ef_construction 128 The number of candidate vertices to consider during the construction of the index.... - https://man.mtool.work/duckdb/1.3/core_extensions/vss.html
- CSV Import Tips – DuckDB 8851
- 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
...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 * FROM read_csv ( 'flights.csv' , header = true ); Provide Names if the File Does Not Co...the file does not contain a header, names will be auto-generated by default. You can provide your own names with the names option. SELECT * FROM read_csv ( 'flights.csv' , names = [ 'DateOfFlight' , 'CarrierName' ]); Override the Types of Specific Colu...g auto-detection. COPY tbl FROM 'test.csv' ; Use union_by_name When Loading Files with Different Schemas The union_by_name option can be used to unify the schema of files that have different or missing columns. For files that do not have certain column... - https://man.mtool.work/duckdb/1.3/data/csv/tips.html
- ODBC API on Linux – DuckDB 8742
- 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 provides some commands to handle the ODBC setup and test like odbcinst and isql . Run the following commands with either option -u or -s to configure DuckDB ODBC. The -u option based on the user home directory to setup the ODBC init files. ./unixodbc..._setup.sh -u The -s option changes the system level files that will be visible for all users, because of that it requires root privileges. sudo ./uni...xodbc_setup.sh -s The option --help shows the usage of unixodbc_setup.sh prints the help. ./unixodbc_setup.sh --help Usage: ./unixodbc_setup.sh <level>... - https://man.mtool.work/duckdb/1.3/clients/odbc/linux.html
- Pragmas – DuckDB 8742
- 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
...engine, and can influence the subsequent execution or behavior of the engine. PRAGMA statements that assign a value to an option can also be issued using the SET statement and the value of an option can be retrieved using SELECT current_setting(option..._name) . For DuckDB's built in configuration options, see the Configuration Reference . DuckDB extensions may register additional configuration options. These are documented...s can take a long time to generate. To limit the number of schemas DuckDB looks through, use the catalog_error_max_schemas option: SET catalog_error_max_schemas = 10 ; Table Information Get info for a specific table: PRAGMA table_info ( 'table_name' );... - https://man.mtool.work/duckdb/1.3/configuration/pragmas.html
DuckDB 1.3 Documentation / man.mtool.work