Results of 1 - 10 of about 120 for option (0.002 sec.)
- Configuration 10791
- Configuration options can be provided to change different settings of the database system. Note that many of these settings can be changed later on using PRAGMA statements as well. The configuration object should be created, filled with val
...e the 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"); duckdb...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...hat can be used to provide start-up options for the DuckDB instance through duckdb_open_ext . The duckdb_config must be destroyed using 'duckdb_destroy_config' This... - https://man.mtool.work/duckdb/2.0/clients/c/config.html
- ADBC Client 10394
- Installation To use the DuckDB ADBC client, download the libduckdb archive for your platform and follow the instructions below . For Python, install the duckdb package instead, as described in the Python section . The latest stable version
...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...Destroy the database. (AdbcDatabase *database, AdbcError *error) AdbcDatabaseRelease(&adbc_database, &adbc_error) Database Options Option Description driver Path to the DuckDB shared library ( libduckdb.so , libduckdb.dylib , or duckdb.dll ). entrypoin... - https://man.mtool.work/duckdb/2.0/clients/adbc.html
- SET and RESET Statements 10394
- 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 system to use 1 thread: SET threads = 1; Or use the T
...O keyword: SET threads TO 1; Change configuration option to default value: RESET threads; Retrieve configuration value: SELECT current_setting('threads'); Set the default collatio...efault_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...s Configuration options can have different scopes: GLOBAL : Configuration value is used (or reset) across the entire DuckDB instance. SESSION : C... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
- CSV Import 10307
- 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', delim = '|', header =
..., 'UniqueCarrier': '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...V file. See the auto detection page for more information. Auto-detection ( auto_detect ) is enabled by default. Setting an option explicitly does not turn auto-detection off: the sniffer still detects every option you did not specify, and your explicit... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- PostgreSQL Extension Connection Pool 9748
- PostgreSQL server spawns a backend process for every incoming client connection. This model leads to the two following points with the postgres extension that can cause performance problems: opening a new connection is relatively expensive
...single table scan can be as high as the number of worker threads of the current DB instance ( threads global configuration option). When the threads parameter is set too high (that may be necessary for local processing of other queries on DuckDB side)...nection proxies it may be better to set the idle timeout to a lower value (using pg_pool_idle_timeout_millis configuration option or postgres_configure_pool function) or to disable the pooling completely (by setting pg_pool_max_connections = 0 ). Reape...parate thread is run for each connections pool, it can be enabled/disabled using pg_pool_enable_reaper_thread configuraton option. When the reaper thread is not running, idle_timeout_millis or max_lifetime_millis values of the connections still can be... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- Connect 9587
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...he instance cache anyway. Multiple connections to the same instance are allowed, but they must all be opened with the same options. Options are applied when the instance starts, as the first connection is opened, so a later connection that requests dif...ferent options — a different access_mode , for example — is rejected. See Database Instances and Instance Caching . JDBC URL Syntax A Du...ckDB JDBC URL consists of the jdbc:duckdb: prefix, an optional database name, and an optional list of options separated by semicolons: jdbc:duckdb:⟨database⟩;⟨key⟩=⟨value⟩;⟨key⟩=⟨valu... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Excel Extension 9102
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...ELECT 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...T * 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/2.0/core_extensions/excel.html
- CSV Auto Detection 9028
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...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...of candidate types that should be considered by the CSV reader can be specified explicitly using the auto_type_candidates option. VARCHAR as the fallback type will always be considered as a candidate type whether you specify it or not. Here are all ad...ditional candidate types that may be specified using the auto_type_candidates option, in order of priority: Types TINYINT SMALLINT INTEGER DECIMAL FLOAT Even though the set of data types that can be automati... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- CSV Import Tips 8308
- Below is a collection of tips to help when attempting to import complex CSV files. 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 hea
...der 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 Contai...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 Columns Th...ng 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/2.0/data/csv/tips.html
- Partitioned Writes 8308
- Examples Write a table to a Hive partitioned dataset of Parquet files: COPY orders TO 'orders' (FORMAT parquet, PARTITION_BY (year, month)); Write a table to a Hive partitioned dataset of CSV files, allowing overwrites: COPY orders TO 'orde
...keep open before flushing to disk when writing using PARTITION_BY , use the partitioned_write_max_open_files configuration option (default: 100): SET partitioned_write_max_open_files = 10; Bestpractice Writing data into many small partitions is expensi...th), OVERWRITE_OR_IGNORE, FILENAME_PATTERN 'file_{uuid}'); Custom Partition Paths New As of DuckDB 2.0, the PARTITION_PATH option gives full control over the subdirectory that each partition is written to, replacing the default col=value Hive layout. B...BY clause writes each partition to a col=value subdirectory following the Hive partitioning convention. The PARTITION_PATH option replaces this with an expression over the PARTITION_BY columns that computes the output subdirectory for each partition: C... - https://man.mtool.work/duckdb/2.0/data/partitioning/partitioned_writes.html
DuckDB 2.0 Documentation / man.mtool.work