Results of 1 - 10 of about 66 for sets (0.004 sec.)
- GROUPING SETS 15083
- GROUPING SETS , ROLLUP and CUBE can be used in the GROUP BY clause to perform a grouping over multiple dimensions within the same query. Note that this syntax is not compatible with GROUP BY ALL . Examples Compute the average income along t
...empty set (i.e., computing an ungrouped aggregate) SELECT city, street_name, avg(income) FROM addresses GROUP BY GROUPING SETS ((city, street_name), (city), (street_name), ()); Compute the average income along the same dimensions: SELECT city, stree...y) and () : SELECT city, street_name, avg(income) FROM addresses GROUP BY ROLLUP (city, street_name); Description GROUPING SETS performs the same aggregate across different GROUP BY clauses in a single query. CREATE TABLE students (course VARCHAR, ty...th', 'Masters'), ('CS', NULL), ('CS', NULL), ('Math', NULL); SELECT course, type, count(*) FROM students GROUP BY GROUPING SETS ((course, type), course, type, ()); course type count_star() Math NULL 1 NULL NULL 7 CS PhD 1 CS Bachelor 2 Math Masters 1... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/grouping_sets.html
- USE Statement 11901
- The USE statement selects a database and optional schema, or just a schema to use as the default. Examples --- Sets the 'memory' database as the default. Will use 'main' schema implicitly or error --- if it does not exist. USE memory; --- Sets
...ets the 'duck.main' database and schema as the default USE duck.main; -- Sets the `main` schema of the currently selected database as the default, in this case 'duck.main' USE main; Syntax The USE sta...tement sets a default database, schema or database/schema combination to use for future operations. For instance, tables created witho... - https://man.mtool.work/duckdb/2.0/sql/statements/use.html
- Table Functions 10074
- The table function API can be used to define a table function that can then be called from within DuckDB in the FROM clause of a query. API Reference Overview duckdb_table_function duckdb_create_table_function (); void duckdb_destroy_table_
...able_function * table_function ); Parameters table_function : The table function to destroy duckdb_table_function_set_name Sets the name of the given table function. Syntax void duckdb_table_function_set_name ( duckdb_table_function table_function ,...mation destroy : The callback that will be called to destroy the extra information (if any) duckdb_table_function_set_bind Sets the bind function of the table function. Syntax void duckdb_table_function_set_bind ( duckdb_table_function table_function...tion_bind_t bind ); Parameters table_function : The table function bind : The bind function duckdb_table_function_set_init Sets the init function of the table function. Syntax void duckdb_table_function_set_init ( duckdb_table_function table_function... - https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
- Dot Commands 9403
- 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
...Show the manual page (signatures, descriptions and examples) for a SQL function. See the manual section .maxbytes ⟨COUNT⟩ Sets the maximum number of bytes of rows for display ( 0 = all). Only for agent mode .maxcellwidth ⟨COUNT⟩ Sets the maximum num...ber of characters per cell ( 0 = all). Only for agent mode .maxrows ⟨COUNT⟩ Sets the maximum number of rows for display (default: 40 , -1 = all). For duckbox mode and agent mode .maxwidth ⟨COUNT⟩ Sets th...hell ⟨CMD⟩ ⟨ARGS...⟩ Run CMD with ARGS... in a system shell .show Show the current values for various settings .singleline Set single-line mode .startup_text ⟨none/version/all⟩ Controls the start-up text displayed when launching the CLI. Set this as... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Configuration 9304
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...ng the RESET statement . The values of configuration options can be queried via the current_setting() scalar function or using the duckd...d function names. Despite the difference in their descriptions, both options operate on this same search path: search_path sets the entire search path as a comma-separated list of entries. schema is a convenience option that sets the search path to a...esystems Disable specific file systems, thereby preventing their access, e.g., LocalFileSystem. VARCHAR disabled_log_types Sets the list of disabled log types. VARCHAR disabled_optimizers Disable a specific, comma-separated set of optimizers. VARCHAR... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- COPY Statement 9304
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...es of FIELD_IDS are as follows. Assign field_ids automatically: COPY (SELECT 128 AS i) TO 'my.parquet' (FIELD_IDS 'auto'); Sets the field_id of column i to 42: COPY (SELECT 128 AS i) TO 'my.parquet' (FIELD_IDS {i: 42}); Sets the field_id of column i...to 42, and column j to 43: COPY (SELECT 128 AS i, 256 AS j) TO 'my.parquet' (FIELD_IDS {i: 42, j: 43}); Sets the field_id of column my_struct to 42, and column i (nested inside my_struct ) to 43: COPY (SELECT {i: 128} AS my_struct)...TO 'my.parquet' (FIELD_IDS {my_struct: {__duckdb_field_id: 42, i: 43}}); Sets the field_id of column my_list to 42, and column element (default name of list child) to 43: COPY (SELECT [128, 256] AS my... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Unit Tester Configuration 8447
- There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line
...across a run's tests; auto = generate --select-tag <string> Select tests which match named tag (as singleton set; multiple sets are OR'd) --select-tag-set <comma-separated strings> Select tests which match all named tags (multiple sets are OR'd) --se...age that contains any of these substrings --skip-tag <string> Skip tests which match named tag (as singleton set; multiple sets are OR'd) --skip-tag-set <comma-separated strings> Skip tests which match all named tags (multiple sets are OR'd) --sort-s... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- Complete API 8248
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...uckdb_scalar_function_set * scalar_function_set ); duckdb_state duckdb_add_scalar_function_to_set ( duckdb_scalar_function_set set , duckdb_scalar_function function ); duckdb_state duckdb_register_scalar_function_set ( duckdb_connection con , duckdb_...scalar_function_set set ); idx_t duckdb_scalar_function_bind_get_argument_count ( duckdb_bind_info info ); duckdb_expression duckdb_scalar_func...ate_function_set * aggregate_function_set ); duckdb_state duckdb_add_aggregate_function_to_set ( duckdb_aggregate_function_set set , duckdb_aggregate_function function ); duckdb_state duckdb_register_aggregate_function_set ( duckdb_connection con , d... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Iceberg Functions 8062
- The iceberg extension provides the following functions: Function Description iceberg_scan(source) Reads an Iceberg table from a path. iceberg_metadata(source) Returns the manifest entries of an Iceberg table. iceberg_snapshots(source) Retur
...erg_table_properties(table) Returns all properties of the specified table. set_iceberg_table_properties(table, properties) Sets properties on the specified table. remove_iceberg_table_properties(table, property_names) Removes properties from the spec...chema_properties(schema) Returns all properties of the specified schema. set_iceberg_schema_properties(schema, properties) Sets properties on the specified schema. remove_iceberg_schema_properties(schema, property_list) Removes properties from the sp...erg_table_properties(table) Returns all properties of the specified table. set_iceberg_table_properties(table, properties) Sets properties on the specified table. remove_iceberg_table_properties(table, property_names) Removes properties from the spec... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- HTTP User-Agent 8062
- HTTP User-Agent Core DuckDB sets the default user-agent as follows: duckdb/v2.0.0(osx_arm64) cli which indicates the DuckDB version, the platform and the client API (the value of the duckdb_api setting, e.g., cli , capi or cpp ). If the cus
...ns set their own user agents; notable examples here include the following. Extensions Azure Azure uses the Azure SDK which sets its own user agents. For identity and storage calls you may see respectively strings like these: via Azure Identity: azsdk... - https://man.mtool.work/duckdb/2.0/operations_manual/user_agents.html
DuckDB 2.0 Documentation / man.mtool.work