Results of 1 - 10 of about 67 for section (0.002 sec.)
- ODBC Configuration 12988
- This page documents the files using the ODBC configuration, odbc.ini and odbcinst.ini . These are either placed in the home directory as dotfiles ( .odbc.ini and .odbcinst.ini , respectively) or in a system directory. For platform-specific
....odbcinst.ini The odbcinst.ini file contains general configurations for the ODBC installed drivers in the system. A driver section starts with the driver name between brackets, and then it follows specific configuration knobs belonging to that driver. E...er] Driver = /path/to/libduckdb_odbc.dylib The lines correspond to the following parameters: [ODBC] : The DM configuration section. Trace : Enables the ODBC trace file using the option yes . TraceFile : The absolute system file path for the ODBC trace f...ile. [DuckDB Driver] : The section of the DuckDB installed driver. Driver : The absolute system file path of the DuckDB driver. Change to match your configur... - https://man.mtool.work/duckdb/2.0/clients/odbc/configuration.html
- Dot Commands 12519
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...for the tables to dump .display_colors ⟨bold/underline⟩ Display all terminal colors and their names. See the 8-bit colors section .echo ⟨on/off⟩ Turn command echo on or off .edit Open an external text editor to edit a query. \e can be used as an alias....See the external editor mode section .excel Display the output of the next command in a spreadsheet. Equivalent to .once -x .exit ⟨CODE⟩ Exit this program with...eyboard shortcuts .highlight ⟨on/off⟩ Toggle syntax highlighting in the shell on / off . See the query syntax highlighting section for more details .highlight_colors ⟨COMPONENT⟩ ⟨COLOR⟩ Configure the color of each query and result component. See the Syn... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Benchmark Suite 10186
- 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
...titions. Benchmarks generally require some data preparation before running the query. Data preparation is done in the load section of the benchmark file. For the FILL benchmark, we create a table using the parameters and a random number generator. load...ilar to the way that foreach values are expanded in unit tests. Note that we can issue multiple SQL statements in the load section. Once the data is prepared, we are finally ready to specify the query we will benchmark! This is done in the run section,... - https://man.mtool.work/duckdb/2.0/dev/benchmark.html
- Quack Setup 9944
- This section contains setup guides for using the Quack Remote Protocol .
... - https://man.mtool.work/duckdb/2.0/quack/setup/overview.html
- Geometry Functions 9474
- This section describes the functions for examining and manipulating GEOMETRY values. The spatial extension provides additional functions for working with GEOMETRY values, which are documented in the Spatial Functions section. Geometry Opera
... - https://man.mtool.work/duckdb/2.0/sql/functions/geometry.html
- Expressions 9247
- An expression is a combination of values, operators and functions. Expressions are highly composable, and range from very simple to arbitrarily complex. They can be found in many different parts of SQL statements. This section describes the
... - https://man.mtool.work/duckdb/2.0/sql/expressions/overview.html
- Reading Faulty CSV Files 8535
- CSV files can come in all shapes and forms, with some presenting many errors that make the process of cleanly reading them inherently difficult. To help users read these files, DuckDB supports detailed error messages, the ability to skip fa
...leaning step. Structural Errors DuckDB supports the detection and skipping of several different structural errors. In this section, we will go over each error with an example. For the examples, consider the following table: CREATE TABLE people (name VAR...nored. In our example, we will demonstrate a CAST error, but note that any of the errors described in our Structural Error section would cause the faulty line to be skipped. For example, consider the following CSV file, faulty.csv : Pedro,31 Oogie Boogi...each CSV faulty line and in which CSV Scanner they happened. Note that any of the errors described in our Structural Error section will be stored in the rejects tables. Also, if a line has multiple errors, multiple entries will be stored for the same li... - https://man.mtool.work/duckdb/2.0/data/csv/reading_faulty_csv_files.html
- List Functions 8535
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...(list, function_name, ...) Executes the aggregate function function_name on the elements of list . See the List Aggregates section for more details. list_any_value(list) Applies aggregate function any_value to the list . list_append(list, element) Appen...Reverses the list . list_reverse_sort(list[, col1]) Sorts the elements of the list in reverse order. See the Sorting Lists section for more details about sorting order and NULL values. list_select(value_list, index_list) Returns a list based on the elem...list_slice with added step feature. list_sort(list[, col1][, col2]) Sorts the elements of the list. See the Sorting Lists section for more details about sorting order and NULL values. list_stddev_pop(list) Applies aggregate function stddev_pop to the l... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Overview 8308
- The pages in this section are intended for developers who contribute to DuckDB or build extensions for it. If you would like to contribute, please also read the contributing guidelines . Project Structure and Processes DuckDB Repositories l
... - https://man.mtool.work/duckdb/2.0/dev/overview.html
- Community Extensions 8308
- Community-contributed extensions can be installed from the Community Extensions repository since summer 2024 . Please visit the “Community Extensions” section of the documentation for more details. Warning Community extensions are contribut
... - https://man.mtool.work/duckdb/2.0/extensions/community_extensions.html
DuckDB 2.0 Documentation / man.mtool.work