Results of 1 - 10 of about 15 for turn (0.083 sec.)
- Dot Commands – DuckDB 12922
- 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
...lp command. List of Dot Commands Command Description .bail on/off Stop after hitting an error. Default: off .binary on/off Turn binary output on or off . Default: off .cd DIRECTORY Change the working directory to DIRECTORY .changes on/off Show number...tax highlighting terminal code used for constant values .databases List names and files of attached databases .echo on/off Turn command echo on or off .exit CODE Exit this program with return-code CODE .headers on/off Turn display of headers on or of..._number_rendering all/footer/off Toggle readable rendering of large numbers (duckbox only, default: footer ) .log FILE/off Turn logging on or off . FILE can be stderr / stdout .maxrows COUNT Sets the maximum number of rows for display. Only for duckb... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
- Join Operations – DuckDB 12922
- 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
...es statistics in the base tables (stored in a DuckDB database or Parquet files) to estimate the cardinality of operations. Turn off the Join Order Optimizer To turn off the join order optimizer, set the following PRAGMA s : SET disabled_optimizers =.... -- this join is performed first JOIN ...; -- this join is performed second Once the query in question has been executed, turn back the optimizers with the following command: SET disabled_optimizers = '' ; Create Temporary Tables To force a particul...STS t1 ; DROP TABLE IF EXISTS t2 ; 関連キーワード join order query Join DuckDB optimizer tables following optimizers Order turn disabled side left performed first Documentation Guides Performance Copy Markdown Operations How to Force cost 関連するペー... - https://man.mtool.work/duckdb/1.3/guides/performance/join_operations.html
- Command Line Arguments – DuckDB 9213
- 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 executed first (if it exists) -init FILENAME Run the script in FILENAME upon startup (instead of ~/.duckdbrc ) -header Turn headers on -help Show this message -html Set output mode to HTML -interactive Force interactive I/O -json Set output mode...own -newline SEP Set output row separator. Default: \n -nofollow Refuse to open symbolic links to database files -noheader Turn headers off -no-stdin Exit after processing options instead of reading stdin -nullvalue TEXT Set text string for NULL valu...ilarly to the behavior of the SQLite CLI. For example: duckdb -csv -c 'SELECT 42 AS hello' -json -c 'SELECT 84 AS world' Returns the following: hello 42 [{"world":84}] 関連キーワード output mode DuckDB line list table command options database column... - https://man.mtool.work/duckdb/1.3/clients/cli/arguments.html
- Profiling – DuckDB 9213
- 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
...specify a format, use the FORMAT tag: EXPLAIN ( FORMAT html ) SELECT 42 AS x ; Pragmas DuckDB supports several pragmas for turning profiling on and off and controlling the level of detail in the profiling output. The following pragmas are available a...on, 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_output Set a profiling output file...atches the following: {"METRIC_NAME": "boolean", ...} . See the metrics section below. disable_profiling , disable_profile Turn off profiling Metrics The query tree has two types of nodes: the QUERY_ROOT and OPERATOR nodes. The QUERY_ROOT refers excl... - https://man.mtool.work/duckdb/1.3/dev/profiling.html
- Friendly SQL – DuckDB 8708
- 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
...g tables and computing statistics: DESCRIBE : provides a succinct summary of the schema of a table or query. SUMMARIZE : returns summary statistics for a table or query. Making SQL clauses more compact and readable: FROM -first syntax with an optiona...of 42 AS x for improved readability. Specifying a percentage of the table size for the LIMIT clause : write LIMIT 10% to return 10% of the query results. Transforming tables: PIVOT to turn long tables to wide tables. UNPIVOT to turn wide tables to lo..., min(arg, n) , arg_max(arg, val, n) , arg_min(arg, val, n) , max_by(arg, val, n) and min_by(arg, val, n) to efficiently return the "top" n rows in a group based on a specific column in either ascending or descending order. For example, let's use the... - https://man.mtool.work/duckdb/1.3/sql/dialect/friendly_sql.html
- Importing Duckbox Tables – DuckDB 8028
- 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
...d like to load this data back to DuckDB? This is not supported by default but it can be achieved by some scripting: we can turn the table into a │ -separated file and read it with DuckDB's CSV reader . Note that the separator is not the pipe characte... - https://man.mtool.work/duckdb/1.3/guides/snippets/importing_duckbox_tables.html
- sqllogictest Introduction – DuckDB 7872
- 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 executed. The first statements are expected to succeed (prefixed by statement ok ). The third statement is expected to return a single row with two columns (indicated by query II ). The values of the row are expected to be 42 and 84 (separated by a...ause of this, query verification can be very slow to do when working with larger data sets. It is therefore recommended to turn on query verification for all unit tests, except those involving larger data sets (more than ~10-100 rows). Editors & Synt... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/intro.html
- File Formats – DuckDB 7872
- 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
...iles. For many small files, this may cause an unnecessarily high overhead. A potential optimization to speed this up is to turn the sniffer off. Assuming that all files have the same CSV dialect and colum names/types, get the sniffer options as follo... - https://man.mtool.work/duckdb/1.3/guides/performance/file_formats.html
- Crashes – DuckDB 7872
- 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 crashes are caused by DuckDB's query optimizer component. To identify whether the optimizer is causing the crash, try to turn it off and re-run the query: PRAGMA disable_optimizer ; If the query finishes successfully, then the crash was caused by o... - https://man.mtool.work/duckdb/1.3/guides/troubleshooting/crashes.html
- Securing DuckDB – DuckDB 7872
- 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
...low_unredacted_secrets option can be set to show all information contained within a security key. It is recommended not to turn on this option if you are running untrusted SQL input. Queries can access the secrets defined in the Secrets Manager. For... - https://man.mtool.work/duckdb/1.3/operations_manual/securing_duckdb/overview.htm...
DuckDB 1.3 Documentation / man.mtool.work