Results of 1 - 10 of about 17 for pairs (0.004 sec.)
- Aggregate Functions – DuckDB 14121
- 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
...Sum). geomean(arg) Calculates the geometric mean of all non-null values in arg . histogram(arg) Returns a MAP of key-value pairs representing buckets and counts. histogram(arg, boundaries) Returns a MAP of key-value pairs representing the provided upp...er_bin . Boundaries may be provided, e.g., via equi_width_bins . histogram_exact(arg, elements) Returns a MAP of key-value pairs representing the requested elements and their counts. A catch-all element specific to the data-type is automatically added...-null values in arg . Example geomean(A) Alias(es) geometric_mean(A) histogram(arg) Description Returns a MAP of key-value pairs representing buckets and counts. Example histogram(A) Alias(es) - histogram(arg, boundaries) Description Returns a MAP of... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- FROM and JOIN Clauses – DuckDB 11104
- 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
...how they are written in the join clause. Each result row has the columns from both relations. A join uses a rule to match pairs of rows from each relation. Often this is a predicate, but there are other implied rules that may be specified. Outer Join...implest type of join is a CROSS JOIN . There are no conditions for this type of join, and it just returns all the possible pairs. Return all pairs of rows: SELECT a . * , b . * FROM a CROSS JOIN b ; This is equivalent to omitting the JOIN clause: SELE...JOIN l_regions r USING ( regionkey ); The expressions do not have to be equalities – any predicate can be used: Return the pairs of jobs where one ran longer but cost less: SELECT s1.t_id , s2.t_id FROM west s1 , west s2 WHERE s1.time > s2.time AND s1... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/from.html
- DuckDB_% Metadata Functions – DuckDB 10966
- 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
...with the database. VARCHAR comment A comment created by the COMMENT ON statement . VARCHAR tags A map of string key–value pairs. MAP(VARCHAR, VARCHAR) internal true indicates a system or built-in database. false indicates a user-defined database. BOO...tion (always NULL ) VARCHAR comment A comment created by the COMMENT ON statement . VARCHAR tags A map of string key–value pairs. MAP(VARCHAR, VARCHAR) return_type The logical data type name of the returned value. Applicable for scalar and aggregate f...of the table object. BIGINT comment A comment created by the COMMENT ON statement . VARCHAR tags A map of string key–value pairs. MAP(VARCHAR, VARCHAR) is_unique true if the index was created with the UNIQUE modifier, false if it was not. BOOLEAN is_p... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- JSON Processing Functions – DuckDB 8362
- 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
...N array with all values of any in the aggregation. json_group_object(key, value) Return a JSON object with all key , value pairs in the aggregation. json_group_structure(json) Return the combined json_structure of all json in the aggregation. Examples...ment can be modified to transform the JSON into the desired structure and types. It is possible to extract fewer key/value pairs than are present in the JSON, and it is also possible to extract more: missing keys become NULL . Examples: CREATE TABLE e... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
- Spatial Extension – DuckDB 8086
- 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 expect. On the surface, the GEOMETRY type is a binary representation of “geometry” data made up out of sets of vertices (pairs of X and Y double precision floats). But what makes it somewhat special is that its actually used to store one of several... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/overview.html
- Creating JSON – DuckDB 8086
- 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
...ate a JSON array from the values in the argument lists. json_object(key, value, ...) Create a JSON object from key , value pairs in the argument list. Requires an even number of arguments. json_merge_patch(json, json) Merge two JSON documents together... - https://man.mtool.work/duckdb/1.3/data/json/creating_json.html
- JSON Overview – DuckDB 8086
- 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 data interchange format that uses human-readable text to store and transmit data objects consisting of attribute–value pairs and arrays (or other serializable values). While it is not a very efficient format for tabular data, it is very commonly u... - https://man.mtool.work/duckdb/1.3/data/json/overview.html
- Querying Parquet Metadata – DuckDB 8086
- 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
...CHAR Parquet Key-Value Metadata The parquet_kv_metadata function can be used to query custom metadata defined as key-value pairs: SELECT * FROM parquet_kv_metadata ( 'test.parquet' ); Below is a table of the columns returned by parquet_kv_metadata . F... - https://man.mtool.work/duckdb/1.3/data/parquet/metadata.html
- Python DB API – DuckDB 7948
- 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
...ne through the duckdb.connect method. The 'config' keyword argument can be used to provide a dict that contains key->value pairs referencing settings understood by DuckDB. In-Memory Connection The special value :memory: can be used to create an in-mem... - https://man.mtool.work/duckdb/1.3/clients/python/dbapi.html
- Map Type – DuckDB 7948
- 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
...tion / SQL / Data Types Copy Markdown Map Type MAP s are similar to STRUCT s in that they are an ordered list of key-value pairs. However, MAP s do not need to have the same keys present for each row, and thus are suitable for use cases where the sche... - https://man.mtool.work/duckdb/1.3/sql/data_types/map.html
DuckDB 1.3 Documentation / man.mtool.work