Results of 1 - 10 of about 37 for Flag (0.001 sec.)
- Configuration 13923
- 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
...b_state duckdb_create_config ( duckdb_config * out_config ); size_t duckdb_config_count (); duckdb_state duckdb_get_config_flag ( size_t index , const char ** out_name , const char ** out_description ); duckdb_state duckdb_set_config ( duckdb_config...ure. duckdb_config_count This returns the total amount of configuration options available for usage with duckdb_get_config_flag . This should not be called in a loop as it internally loops over all the options. Return Value The amount of config optio...ns available. Syntax size_t duckdb_config_count ( ); duckdb_get_config_flag Obtains a human-readable name and description of a specific configuration option. This can be used to e.g. display configu... - https://man.mtool.work/duckdb/2.0/clients/c/config.html
- Building Extensions 12707
- Extensions can be built from source and installed from the resulting local binary. Building Extensions To build using extension flags, set the BUILD_EXTENSIONS flag to the list of extensions that you want to be built. For example: BUILD_EXT
...utable, set LINK_CORE_EXTENSIONS=1 or list them in STATICALLY_LINK_EXTENSIONS (see Linking Extensions ). Special Extension Flags BUILD_JEMALLOC This flag controls whether the jemalloc memory allocator is linked into DuckDB. Unlike TPC-H and TPC-DS, j...only supported on 64-bit Linux, where it is enabled by default. To disable it, set BUILD_JEMALLOC=0 . BUILD_TPCE When this flag is set, the TPCE library is built. Unlike TPC-H and TPC-DS this is not a proper extension and it's not distributed as such.... Enabling this allows TPC-E enabled queries through our test suite. Debug Flags CRASH_ON_ASSERT D_ASSERT(condition) is used all throughout the code, these will throw an InternalException in debug build... - https://man.mtool.work/duckdb/2.0/dev/building/building_extensions.html
- Building Configuration 10387
- Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and code, optimized for performance. de
...are served by the core extension repository. Additional extensions can be built as part of DuckDB via the BUILD_EXTENSIONS flag, then listing the names of the extensions that are to be built. BUILD_EXTENSIONS='tpch;httpfs;fts;json;parquet' make More...on this topic at building DuckDB extensions . Package Flags The Makefile has flags to control which components are built. These can be enabled by either setting them in the current...ain DuckDB repository. See the Python , Java and ODBC repositories for their build instructions. BUILD_BENCHMARK When this flag is set, DuckDB's in-house benchmark suite is built. More information about this can be found in the README . DISABLE_SHELL... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
- Hive Partitioning 10071
- Examples Read data from a Hive partitioned dataset: SELECT * FROM read_parquet('orders/*/*/*.parquet', hive_partitioning = true); Write a table to a Hive partitioned dataset: COPY orders TO 'orders' (FORMAT parquet, PARTITION_BY (year, mont
...│ └── file5.parquet └── month=12 └── file6.parquet Files stored in this hierarchy can be read using the hive_partitioning flag. SELECT * FROM read_parquet('orders/*/*/*.parquet', hive_partitioning = true); When we specify the hive_partitioning flag,...ault the system tries to infer if the provided files are in a hive partitioned hierarchy. And if so, the hive_partitioning flag is enabled automatically. The auto-detection will look at the names of the folders and search for a 'key' = 'value' patter...e_types will be auto-detected for the following types: DATE , TIMESTAMP and BIGINT . To switch off the auto-detection, the flag hive_types_autocast = 0 can be set. Writing Partitioned Files See the Partitioned Writes section.... - https://man.mtool.work/duckdb/2.0/data/partitioning/hive_partitioning.html
- Benchmark Suite 9361
- DuckDB has an extensive benchmark suite. When making changes that have potential performance implications, it is important to run these benchmarks to detect potential performance regressions. Getting Started To build the benchmark suite, ru
...0.122534 benchmark/micro/nulls/no_nulls_addition.benchmark 5 0.124102 You can also specify an output file using the --out flag. This will write only the timings (delimited by newlines) to that file. build/release/benchmark/benchmark_runner benchmark...rks Not specifying any argument will run all benchmarks. build/release/benchmark/benchmark_runner Other Options The --info flag gives you some other information about the benchmark. build/release/benchmark/benchmark_runner benchmark/micro/nulls/no_nu...lls_addition.benchmark --info display_name:NULL Addition (no nulls) group:micro subgroup:nulls The --query flag will print the query that is run by the benchmark. SELECT min(i + 1) FROM integers; The --profile flag will output a query... - https://man.mtool.work/duckdb/2.0/dev/benchmark.html
- jemalloc 8855
- On supported platforms, DuckDB replaces the system's memory allocator with jemalloc . jemalloc is statically linked into DuckDB and cannot be installed or loaded during runtime. For technical reasons, we used to distribute jemalloc as an ex
...ception of builds for musl-based distributions). To disable jemalloc , build DuckDB from source and set the BUILD_JEMALLOC flag to 0 as follows: GEN=ninja BUILD_JEMALLOC=0 make This flag is passed to CMake as -DENABLE_JEMALLOC=0 . macOS and Windows O... - https://man.mtool.work/duckdb/2.0/internals/jemalloc.html
- PostgreSQL Extension Functions 8650
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...oing to be re-read on the next access. Parameters None. Returns A table with the following columns: Success ( BOOLEAN ): a flag whether the cache clearing was successful Currently the table result is always returned with zero rows, so the flag value...a PostgreSQL transaction if it was not started before. Returns A table with the following columns: Success ( BOOLEAN ): a flag whether the cache clearing was successful Currently the table result is always returned with zero rows, so the flag value... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- CSV Import Tips 8555
- 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
...* FROM read_csv('flights.csv', names = ['DateOfFlight', 'CarrierName']); Override the Types of Specific Columns The types flag can be used to override types of only certain columns by providing a struct of name → type mappings. SELECT * FROM read_cs... - https://man.mtool.work/duckdb/2.0/data/csv/tips.html
- Troubleshoot 7940
- Overview This page collects common issues encountered when using the DuckDB JDBC driver, together with their workarounds. If you run into a problem that is not covered here, search the driver's issue tracker on GitHub. Driver Class Not Foun
...uration in your IDE. Parquet String Column Returns a Blob Parquet files written by some legacy writers do not set the UTF8 flag on string columns, so DuckDB reads them as BLOB . ResultSet.getObject() then returns a DuckDBBlobResult and ResultSet.getS...of the driver if you place it on the module path. Future JDK releases will turn this warning into an error, so adding the flag is recommended. Further Reading Deploy as Native Image — building standalone executables with GraalVM, including both ways... - https://man.mtool.work/duckdb/2.0/clients/java/troubleshoot.html
- Command Line 7940
- Unexpected Markdown Output When Piping If the output of the command line client is piped to another process and an AI agent environment variable (such as AI_AGENT ) is set, the CLI switches to agent mode and prints compact Markdown tables i
...CT 42 AS x;" | duckdb -no-agent | cat ┌───────┐ │ x │ │ int32 │ ├───────┤ │ 42 │ └───────┘ Passing an explicit output mode flag, such as -csv or -json , also disables agent mode.... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/command_line.html
DuckDB 2.0 Documentation / man.mtool.work