Results of 1 - 10 of about 27 for enable (0.005 sec.)
- Pragmas – DuckDB 13874
- 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
...blocks , free_blocks , and free_list ): PRAGMA metadata_info ; Progress Bar Show progress bar when running queries: PRAGMA enable_progress_bar ; Or: PRAGMA enable_print_progress_bar ; Don't show a progress bar for running queries: PRAGMA disable_progre...imized query plan: SET explain_output = 'optimized_only' ; To show all query plans: SET explain_output = 'all' ; Profiling Enable Profiling The following query enables profiling with the default format, query_tree . Independent of the format, enable_pr...ofiling is mandatory to enable profiling. PRAGMA enable_profiling ; PRAGMA enable_profile ; Profiling Format The format of enable_profiling can be specif... - https://man.mtool.work/duckdb/1.3/configuration/pragmas.html
- Configuration – DuckDB 13429
- 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
...memory limit of the system to 10 GB. SET memory_limit = '10GB' ; Configure the system to use 1 thread. SET threads TO 1 ; Enable printing of a progress bar during long-running queries. SET enable_progress_bar = true ; Set the default null order to NUL...ess mode of the database ( AUTOMATIC , READ_ONLY or READ_WRITE ) VARCHAR automatic allocator_background_threads Whether to enable the allocator background thread. BOOLEAN false allocator_bulk_deallocation_flush_threshold If a bulk deallocation larger t...ignatures BOOLEAN false allowed_directories List of directories/prefixes that are ALWAYS allowed to be queried - even when enable_external_access is false VARCHAR[] [] allowed_paths List of files that are ALWAYS allowed to be queried - even when enable... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- Profiling – DuckDB 9611
- 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
...understand why certain queries exhibit specific performance characteristics. DuckDB contains several built-in features to enable query profiling, which this page covers. For a high-level example of using EXPLAIN , see the “Inspect Query Plans” page ....he performance numbers of individual operators and the cardinalities that pass through them. The EXPLAIN ANALYZE statement enables obtaining these, as it pretty-prints the query plan and also executes the query. Thus, it provides the actual run-time pe...e setting name. For more information, see the “Profiling” section of the pragmas page. Setting Description Default Options enable_profiling , enable_profile Turn on profiling query_tree query_tree , json , query_tree_optimizer , no_output profiling_out... - https://man.mtool.work/duckdb/1.3/dev/profiling.html
- Logging – DuckDB 9233
- 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
...o users, such as query execution details, performance metrics, and system events. Basics DuckDB's logging mechanism can be enabled or disabled using pragmas. By default, logs are stored in a special table called duckdb_logs that can be queried like any...other table. Example: PRAGMA enable_logging ; -- Run some queries.. SELECT * FROM duckdb_logs ; Log Level DuckDB supports different logging levels that contro...Logs detailed debugging information TRACE : Logs very detailed tracing information The log level can be set using: PRAGMA enable_logging ; SET logging_level = 'TRACE' ; Log Types In DuckDB, log messages can have an associated log type. Log types have... - https://man.mtool.work/duckdb/1.3/operations_manual/logging/overview.html
- Securing DuckDB – DuckDB 8788
- 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
...ple: SET disabled_filesystems = 'LocalFileSystem' ; Second, you can also completely disable external access by setting the enable_external_access option option to false . SET enable_external_access = false ; This setting implies that: ATTACH cannot att...the file system. For example, you can set DuckDB to only use the /tmp directory. SET allowed_directories = [ '/tmp' ]; SET enable_external_access = false ; FROM read_csv ( 'test.csv' ); With the setting applied, DuckDB will refuse to read files in the...ns. For example, while we can disable community extensions using the SET allow_community_extensions = false , we cannot re-enable them again after the fact without restarting the database. Trying to do so will result in an error: Invalid Input Error: C... - https://man.mtool.work/duckdb/1.3/operations_manual/securing_duckdb/overview.htm...
- sqllogictest Introduction – DuckDB 8525
- 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
...ple of a test file is shown below: # name : test / sql / projection / test_simple_projection.test # group [ projection ] # enable query verification statement ok PRAGMA enable_verification # create table statement ok CREATE TABLE a ( i INTEGER , j INTE...e tests start by enabling query verification. This can be done through the following PRAGMA statement: statement ok PRAGMA enable_verification Query verification performs extra validation to ensure that the underlying code runs correctly. The most impo...ents group require vector expected example because unittest sqllogictests also temporary size sqllogictest testing located enable using Query 関連するページ Writing Tests Debugging Result Verification Persistent Testing Catch C/C++ Tests Overview See t... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/intro.html
- Vector Similarity Search Extension – DuckDB 8212
- 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
...tom extension indexes, the HNSW index can only be created on tables in in-memory databases by default, unless the SET hnsw_enable_experimental_persistence = bool configuration option is set to true . The reasoning for locking this feature behind an exp...there are uncommitted changes to a HNSW -indexed table, you can end up with data loss or corruption of the index . If you enable this option and experience an unexpected shutdown, you can try to recover the index by first starting DuckDB separately, l...proceed without issues. But we still recommend that you do not use this feature in production environments. With the hnsw_enable_experimental_persistence option enabled, the index will be persisted into the DuckDB database file (if you run DuckDB with... - https://man.mtool.work/duckdb/1.3/core_extensions/vss.html
- Relational API – DuckDB 8015
- 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
...iter or quote characters. encoding : Optional[str] Encoding to use for UTF when reading/writing. parallel : Optional[bool] Enable parallel reading. date_format : Optional[str] Format to parse dates. timestamp_format : Optional[str] Format to parse time...ll columns as VARCHAR. normalize_names : Optional[bool] Normalize column names to lowercase. null_padding : Optional[bool] Enable null padding for rows with missing columns. names : Optional[List[str]] List of column names to use. lineterminator : Opti...lues. filename : Optional[bool], Optional[str] Add filename column or specify filename. hive_partitioning : Optional[bool] Enable Hive-style partitioning. union_by_name : Optional[bool] Union files by column name instead of position. hive_types : Optio... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Iceberg Extension – DuckDB 7768
- 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
...filename that is lexicographically largest when sorting the filenames. Collations are not considered. This behavior is not enabled by default as it may potentially violate ACID constraints. It can be enabled by setting unsafe_enable_version_guessing to...true . When this is set, iceberg functions will attempt to guess the latest version by default before failing. SET unsafe_enable_version_guessing = true ; SELECT count ( * ) FROM iceberg_scan ( 'data/iceberg/lineitem_iceberg_no_hint' , allow_moved_pat... - https://man.mtool.work/duckdb/1.3/core_extensions/iceberg/overview.html
- Lambda Functions – DuckDB 7702
- 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
...B 1.3.0 also introduces a new setting to configure the lambda syntax. SET lambda_syntax = 'DEFAULT' ; SET lambda_syntax = 'ENABLE_SINGLE_ARROW' ; SET lambda_syntax = 'DISABLE_SINGLE_ARROW' ; Currently, DEFAULT enables both syntax styles, i.e., the old...syntax flag and fully deprecates the single arrow syntax, so the old behavior will no longer be possible. Lambda functions enable the use of more complex and flexible expressions in queries. DuckDB supports several scalar functions that operate on LIST... - https://man.mtool.work/duckdb/1.3/sql/functions/lambda.html
DuckDB 1.3 Documentation / man.mtool.work