Results of 1 - 10 of about 73 for given (0.009 sec.)
- Relational API – DuckDB 13009
- 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 object from the Parquet files from_query Run a SQL query. If it is a SELECT statement, create a relation object from the given SQL query, otherwise run the query as-is. query Run a SQL query. If it is a SELECT statement, create a relation object fro...m the given SQL query, otherwise run the query as-is. read_csv Create a relation object from the CSV file in 'name' read_json Create a...relation object from the Parquet files sql Run a SQL query. If it is a SELECT statement, create a relation object from the given SQL query, otherwise run the query as-is. table Create a relation object for the named table table_function Create a relat... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Python Client API – DuckDB 12185
- 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
...duckdb.DuckDBPyConnection , query : object , parameters : object = None ) → duckdb.duckdb.DuckDBPyConnection ¶ Execute the given SQL query, optionally using prepared statements with parameters set executemany ( self : duckdb.duckdb.DuckDBPyConnection..., query : object , parameters : object = None ) → duckdb.duckdb.DuckDBPyConnection ¶ Execute the given prepared statement multiple times using the list of parameter sets in parameters extract_statements ( self : duckdb.duckdb...None ) → duckdb.duckdb.DuckDBPyRelation ¶ Run a SQL query. If it is a SELECT statement, create a relation object from the given SQL query, otherwise run the query as-is. get_table_names ( self : duckdb.duckdb.DuckDBPyConnection , query : str ) → set... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
- Values – DuckDB 11486
- 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
...eturn Value The value. This must be destroyed with duckdb_destroy_value . duckdb_get_bool Returns the boolean value of the given value. Syntax bool duckdb_get_bool ( duckdb_value val ); Parameters val : A duckdb_value containing a boolean Return Value...A boolean, or false if the value cannot be converted duckdb_get_int8 Returns the int8_t value of the given value. Syntax int8_t duckdb_get_int8 ( duckdb_value val ); Parameters val : A duckdb_value containing a tinyint Return Val...ue A int8_t, or MinValue if the value cannot be converted duckdb_get_uint8 Returns the uint8_t value of the given value. Syntax uint8_t duckdb_get_uint8 ( duckdb_value val ); Parameters val : A duckdb_value containing a utinyint Return... - https://man.mtool.work/duckdb/1.3/clients/c/value.html
- Complete API – DuckDB 10899
- 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
...cache : The instance cache to destroy. duckdb_open Creates a new database or opens an existing database file stored at the given path. If no path is given a new in-memory database is created instead. The database must be closed with 'duckdb_close'. Sy.... duckdb_open_ext Extended version of duckdb_open. Creates a new database or opens an existing database file stored at the given path. The database must be closed with 'duckdb_close'. Syntax duckdb_state duckdb_open_ext ( const char * path , duckdb_da...object Return Value Number of data chunks present in the result. duckdb_result_return_type Returns the return_type of the given result, or DUCKDB_RETURN_TYPE_INVALID on error Syntax duckdb_result_type duckdb_result_return_type ( duckdb_result result... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Map Functions – DuckDB 10606
- 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
...inality(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 key provided in the second paramet...s . On key collision the value is taken from the last map with that key. map_contains(map, 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) Ch...ecks 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... - https://man.mtool.work/duckdb/1.3/sql/functions/map.html
- DuckLake – DuckDB 8202
- 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
...ete_file_size_bytes BIGINT ducklake_table_insertions The ducklake_table_insertions function returns the rows inserted in a given table between snapshots of given versions or timestamps. The function has two variants, depending on whether start_snapsho...t of the table table_name . ducklake_table_deletions The ducklake_table_deletions function returns the rows deleted from a given table between snapshots of given versions or timestamps. The function has two variants, depending on whether start_snapsho...to that of the table table_name . ducklake_table_changes The ducklake_table_changes function returns the rows changed in a given table between snapshots of given versions or timestamps. The function has two variants, depending on whether start_snapsho... - https://man.mtool.work/duckdb/1.3/core_extensions/ducklake.html
- Bitstring Functions – DuckDB 8202
- 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
...e available for BIT type. Name Description bit_and(arg) Returns the bitwise AND operation performed on all bitstrings in a given expression. bit_or(arg) Returns the bitwise OR operation performed on all bitstrings in a given expression. bit_xor(arg) R...eturns the bitwise XOR operation performed on all bitstrings in a given expression. bitstring_agg(arg) Returns a bitstring with bits set for each distinct position defined in arg . bitstring_agg...of Range Error will be thrown. bit_and(arg) Description Returns the bitwise AND operation performed on all bitstrings in a given expression. Example bit_and(A) bit_or(arg) Description Returns the bitwise OR operation performed on all bitstrings in a g... - https://man.mtool.work/duckdb/1.3/sql/functions/bitstring.html
- Timestamp with Time Zone Functions – DuckDB 7965
- 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
...f the month. make_timestamptz(bigint, bigint, bigint, bigint, bigint, double, string) The TIMESTAMP WITH TIME ZONE for the given parts and time zone. make_timestamptz(bigint, bigint, bigint, bigint, bigint, double) The TIMESTAMP WITH TIME ZONE for the...given parts in the current time zone. make_timestamptz(microseconds) The TIMESTAMP WITH TIME ZONE for the given µs since the epo...make_timestamptz(bigint, bigint, bigint, bigint, bigint, double, string) Description The TIMESTAMP WITH TIME ZONE for the given parts and time zone. Example make_timestamptz(1992, 9, 20, 15, 34, 27.123456, 'CET') Result 1992-09-20 06:34:27.123456-07... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Enum Functions – DuckDB 7853
- 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
...he type of the argument and not on its value. Name Description enum_code(enum_value) Returns the numeric value backing the given enum value. enum_first(enum) Returns the first value of the input enum type. enum_last(enum) Returns the last value of the...) Returns all values of the input enum type as an array. enum_range_boundary(enum, enum) Returns the range between the two given enum values as an array. enum_code(enum_value) Description Returns the numeric value backing the given enum value. Example...NULL::mood) Result [sad, ok, happy, anxious] enum_range_boundary(enum, enum) Description Returns the range between the two given enum values as an array. The values must be of the same enum type. When the first parameter is NULL , the result starts wi... - https://man.mtool.work/duckdb/1.3/sql/functions/enum.html
- JSON Processing Functions – DuckDB 7797
- 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
...ath exists in the json , and false otherwise. json_extract(json, path) json_extract_path -> Extracts JSON from json at the given path . If path is a LIST , the result will be a LIST of JSON . json_extract_string(json, path) json_extract_path_text ->>...Extracts VARCHAR from json at the given path . If path is a LIST , the result will be a LIST of VARCHAR . json_value(json, path) Extracts JSON from json at the gi...array json , or 0 if it is not a JSON array. If path is specified, return the number of elements in the JSON array at the given path . If path is a LIST , the result will be LIST of array lengths. json_contains(json_haystack, json_needle) Returns tru... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
DuckDB 1.3 Documentation / man.mtool.work