Results of 1 - 10 of about 19 for help (0.003 sec.)
- Dot Commands – DuckDB 13899
- 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
...itespace may occur before the period. No semicolon is required at the end of the line. To see available commands, use the .help command. List of Dot Commands Command Description .bail on/off Stop after hitting an error. Default: off .binary on/off Tu...xit this program with return-code CODE .headers on/off Turn display of headers on or off . Does not apply to duckbox mode .help -all PATTERN Show help text for PATTERN .highlight on/off Toggle syntax highlighting in the shell on / off . See the query...separated via newline are measured together .width NUM1 NUM2 ... Set minimum column widths for columnar output Using the .help Command The .help text may be filtered by passing in a text string as the first argument. .help m .maxrows COUNT Sets the... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
- ODBC API on Linux – DuckDB 11884
- 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
...that will be visible for all users, because of that it requires root privileges. sudo ./unixodbc_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> [optio...level based configuration Driver sudo option user directory system unixODBC install odbcinst libduckdb script duckdb home help database 関連するページ ODBC Configuration ODBC API on Windows ODBC API on macOS ODBC API Overview Securing DuckDB Working... - https://man.mtool.work/duckdb/1.3/clients/odbc/linux.html
- Command Line Arguments – DuckDB 10672
- 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
...ments The table below summarizes DuckDB's command line options. To list all command line options, use the command: duckdb -help For a list of dot commands available in the CLI shell, see the Dot Commands page . Argument Description -append Append the...t (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 to json -line Set...ワード output mode DuckDB line list table command options database column stdin exit json separator Default Arguments duckdb help commands ascii after batch Force before reading 関連するページ CLI Client Output Formats Dot Commands CSV Export JSON Expo... - https://man.mtool.work/duckdb/1.3/clients/cli/arguments.html
- CLI Client – DuckDB 9459
- 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
...er, the information on the connection and a prompt starting with a D . duckdb DuckDB v1.5.6 (Variegata) 069cc9f9b5 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. D...ull Below, we summarize a few important dot commands. To see all available commands, see the dot commands page or use the .help command. Opening Database Files In addition to connecting to a database when opening the CLI, a new database connection ca...use this command: duckdb -init prompt.sql This outputs: -- Loading resources from prompt.sql v⟨version⟩ ⟨git_hash⟩ Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. ⚫◗... - https://man.mtool.work/duckdb/1.3/clients/cli/overview.html
- ODBC API on macOS – DuckDB 8042
- 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
....ini as a parameter of isql . isql DuckDB +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | echo [string] | | quit | | | +---------------------------------------+ SQL > SELECT 42 ; +------------+ |... - https://man.mtool.work/duckdb/1.3/clients/odbc/macos.html
- CSV Import Tips – DuckDB 8042
- 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 Sitemap Live Demo Documentation / Data Import / CSV Files Copy Markdown CSV Import Tips 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... - https://man.mtool.work/duckdb/1.3/data/csv/tips.html
- Parquet Tips – DuckDB 8042
- 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
...Sitemap Live Demo Documentation / Data Import / Parquet Files Copy Markdown Parquet Tips Below is a collection of tips to help when dealing with Parquet files. Tips for Reading Parquet Files Use union_by_name When Loading Files with Different Schema... - https://man.mtool.work/duckdb/1.3/data/parquet/tips.html
- CLI Charting with YouPlot – DuckDB 8042
- 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
...or YouPlot can be found on the main YouPlot repository . If you're on a Mac, you can use: brew install youplot Run uplot --help to ensure you've installed it successfully! Piping DuckDB Queries to stdout By combining the COPY...TO function with a CSV... - https://man.mtool.work/duckdb/1.3/guides/data_viewers/youplot.html
- File Formats – DuckDB 7837
- 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 a suboptimal join order on Parquet files, try loading the Parquet files to DuckDB tables. The improved statistics likely help obtain a better join order. Repeated queries: If you plan to run multiple queries on the same data set, it is worth loadin...ilter condition. DuckDB will only need to read the folders and files that meet the filter criteria. This can be especially helpful when querying remote files. More Tips on Reading and Writing Parquet Files For tips on reading and writing Parquet file... - https://man.mtool.work/duckdb/1.3/guides/performance/file_formats.html
- Tuning Workloads – DuckDB 7837
- 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
...y to be the IO. This means that minimizing the unnecessarily read data can be highly beneficial. Some basic SQL tricks can help with this: Avoid SELECT * . Instead, only select columns that are actually used. DuckDB will try to only download the data...ssible to parallelize in all cases. Making multiple connections can process more operations concurrently. This can be more helpful if DuckDB is not CPU limited, but instead bottlenecked by another resource like network transfer speed. Persistent vs.... - https://man.mtool.work/duckdb/1.3/guides/performance/how_to_tune_workloads.html
DuckDB 1.3 Documentation / man.mtool.work