Results of 1 - 10 of about 12 for particularly (0.002 sec.)
- Star Expression 13124
- Syntax The * expression can be used in a SELECT statement to select all columns that are projected in the FROM clause. SELECT * FROM tbl; TABLE.* and STRUCT.* The * expression can be prepended by a table name to select only columns from tha
...l USING (id); Similarly, the * expression can also be used to retrieve all keys from a struct as separate columns. This is particularly useful when a prior operation creates a struct of unknown shape, or if a query must handle any potential struct keys. See...AS c); result 4 STRUCT.* The * expression can also be used to retrieve all keys from a struct as separate columns. This is particularly useful when a prior operation creates a struct of unknown shape, or if a query must handle any potential struct keys. See... - https://man.mtool.work/duckdb/2.0/sql/expressions/star.html
- Non-Deterministic Behavior 11037
- Several operators in DuckDB exhibit non-deterministic behavior. Most notably, SQL uses set semantics, which allows results to be returned in a different order. DuckDB exploits this to improve performance, particularly when performing multi-
... - https://man.mtool.work/duckdb/2.0/operations_manual/non-deterministic_behavior.h...
- Output Formats 9639
- The .mode dot command may be used to change the appearance of the tables returned in the terminal output. In addition to customizing the appearance, these modes have additional benefits. This can be useful for presenting DuckDB output elsew
...sert mode will build a series of SQL statements that can be used to insert the data at a later point. The markdown mode is particularly useful for building documentation and the latex mode is useful for writing academic papers. Warning Unicode handling in Wi... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- Indexes 9639
- Index Types DuckDB has two built-in index types. Indexes can also be defined via extensions . Min-Max Index (Zonemap) A min-max index (also known as zonemap or block range index) is automatically created for columns of all general-purpose d
...med into a DELETE of the original row followed by an INSERT of the updated row. This rewrite has performance implications, particularly for wide tables, as entire rows are rewritten instead of only the affected columns. Additionally, it causes the following... - https://man.mtool.work/duckdb/2.0/sql/indexes.html
- Enum Data Type 8950
- Name Description ENUM Dictionary representing all possible string values of a column The enum type represents a dictionary data structure with all possible unique values of a column. For example, a column storing the days of the week can be
...an enum holding all possible days. Enums are particularly interesting for string columns with low cardinality (i.e., fewer distinct values). This is because the column only stores... - https://man.mtool.work/duckdb/2.0/sql/data_types/enum.html
- MySQL Extension 8260
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...o create a copy of the MySQL databases in DuckDB to prevent the system from re-reading the tables from MySQL continuously, particularly for large tables. Data can be copied over from MySQL to DuckDB using standard SQL, for example: CREATE TABLE duckdb_table... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Logging 8260
- DuckDB implements a logging mechanism that provides users with detailed information about events such as query execution, performance metrics and system events. Warning Logs may contain sensitive information, including secrets and credentia
...ential delay between message logging and storage writing. This delay can obscure the actual message writing time, which is particularly problematic when debugging crashes, as messages generated immediately before a crash might not be written. To address this... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
- Unnesting 8260
- Unnesting is an operation that decomposes values of a composite types into its components. Values of the LIST and STRUCT type may be unnested using the unnest() function . Unnesting turns a LIST -typed value into a table column: each list-e
...owing result: a b.bb.bbb 0 1 In this case, the field names are preserved, showing the path to the innermost value. This is particularly useful when working with complex nested data structures, as it maintains the structure and naming convention of the origin... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- Dot Commands 7552
- 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
...ng .once to output to pbcopy via a pipe: .once |pbcopy Combining this with the .headers off and .mode lines options can be particularly effective. Querying the Database Schema All DuckDB clients support querying the database schema with SQL , but the CLI has... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- PostgreSQL Extension 7552
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...copy of the PostgreSQL databases in DuckDB to prevent the system from re-reading the tables from PostgreSQL continuously, particularly for large tables. Data can be copied over from PostgreSQL to DuckDB using standard SQL, for example: CREATE TABLE duckdb_t... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
DuckDB 2.0 Documentation / man.mtool.work