Results of 1 - 10 of about 12 for pair (0.005 sec.)
- Map Functions 13920
- Name Description cardinality(map) Return the size of the map (or the number of entries in the map). element_at(map, key) Return the value for a given key as a list, or an empty list if the key is not contained in the map. The type of the ke
..., key) Checks if a map contains a given key. map_contains_entry(map, key, value) Check if a map contains a given key-value pair. map_contains_value(map, value) Checks if a map contains a given value. map_entries(map) Return a list of struct(k, v) for...each key-value pair in the map. map_extract(map, key) Return the value for a given key as a list, or an empty list if the key is not contained...'key2') | | Result | true | map_contains_entry(map, key, value) | Description | Check if a map contains a given key-value pair. | | Example | map_contains_entry(MAP {'key1': 10, 'key2': 20, 'key3': 30}, 'key2', 20) | | Result | true | map_contains_v... - https://man.mtool.work/duckdb/2.0/sql/functions/map.html
- Tigris Import 10082
- Prerequisites For Tigris , the S3-compatible API allows you to use DuckDB's S3 support to read and write from Tigris buckets. This requires the httpfs extension , which can be installed using the INSTALL SQL command. This only needs to be r
...un once. Credentials and Configuration You will need to generate an access key pair and create an S3 secret in DuckDB: CREATE SECRET my_secret ( TYPE s3, KEY_ID '⟨tid_xxxxxxxxxxxx⟩', SECRET '⟨tsec_xxxxxxxxx... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/tigris_import.htm...
- VACUUM Statement 9799
- The VACUUM statement only has basic support in DuckDB and is mostly provided for PostgreSQL-compatibility. Some variants of it, such as when calling for a given column, recompute the distinct statistics (the number of distinct entities) if
...ikely going to change in the future. Examples No-op: VACUUM; No-op: VACUUM ANALYZE; Calling VACUUM on a given table-column pair rebuilds statistics for the table and column: VACUUM my_table(my_column); VACUUM ANALYZE my_table(my_column); The followin... - https://man.mtool.work/duckdb/2.0/sql/statements/vacuum.html
- CREATE INDEX Statement 9498
- CREATE INDEX The CREATE INDEX statement constructs an index on the specified column(s) of the specified table. Examples Create a unique index films_id_idx on the column id of table films : CREATE UNIQUE INDEX films_id_idx ON films (id); Cre
...ndex type, see Indexes . Optional. option Index option in the form of a Boolean true value (e.g., is_cool ) or a key-value pair (e.g., my_option = 2 ). Optional. Syntax DROP INDEX DROP INDEX drops an existing index from the database system. Examples... - https://man.mtool.work/duckdb/2.0/sql/statements/create_index.html
- Import Data 8313
- Overview The JDBC driver offers two ways to load data into DuckDB in bulk: the high-performance Appender and a JDBC batch writer. This page describes both and when to use each. Appender The Appender is available in the DuckDB JDBC driver vi
...ent is NULL appender.endRow(); } For a MAP column, pass a Java Map as a single value; each entry is written as a key/value pair, and a null map is appended as SQL NULL . The following row targets a table declared as CREATE TABLE map_tbl (m MAP(VARCHA... - https://man.mtool.work/duckdb/2.0/clients/java/data_import.html
- Keywords and Identifiers 8313
- Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keyw
...in order. Both options write to the same catalog search path, and each entry may be a bare schema or a ⟨catalog⟩.⟨schema⟩ pair. For a detailed description of how database and schema names are resolved, including the default database and schema and h... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- Quack Remote Protocol 8030
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...oss the wire. Single round-trip per query. After the initial connection handshake, a query needs only one request–response pair. Large results stream back in chunks via follow-up FETCH requests, optionally parallelized on multiple threads. Default po... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Expression API 7729
- The Expression class represents an instance of an expression . Why Would I Use the Expression API? Use expressions to build filters and computed columns in Python. They are useful when column names or conditions depend on your code. import
...by=..., order_by=..., rows=..., range=...) turns an aggregate into a window function. rows and range bound the window as a pair (start, end) relative to the current row, where None means unbounded; rows counts rows and range measures the distance in... - https://man.mtool.work/duckdb/2.0/clients/python/expression.html
- Spatial Functions 7729
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...coordinates ST_MakeLine Create a LINESTRING from a list of POINT geometries ST_MakePoint Creates a GEOMETRY point from an pair of floating point numbers. ST_MakePolygon Create a POLYGON from a LINESTRING shell ST_MakeValid Returns a valid representa...BLE, z DOUBLE) POINT_4D ST_MakePoint (x DOUBLE, y DOUBLE, z DOUBLE, m DOUBLE) Description Creates a GEOMETRY point from an pair of floating point numbers. For geodetic coordinate systems, x is typically the longitude value and y is the latitude value...pushed down. Otherwise the filtering is done by GDAL which may be much slower. open_options VARCHAR[] A list of key-value pairs that are passed to the GDAL driver to control the opening of the file. E.g., the GeoJSON driver supports a FLATTEN_NESTED... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- FROM and JOIN Clauses 7729
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...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 Joi...least once) FULL (All rows from both relations appear at least once) A join that is not OUTER is INNER (only rows that get paired are returned). When an unpaired row is returned, the attributes from the other table are set to NULL . Cross Product Joi...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: SELECT a.... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
DuckDB 2.0 Documentation / man.mtool.work