Results of 1 - 10 of about 17 for uuid (0.008 sec.)
- Relational API – DuckDB 14001
- 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
...the current alias Example import duckdb duckdb_conn = duckdb . connect () rel = duckdb_conn . sql ( """ select gen_random_uuid() as id, concat('value is ', case when mod(range,2)=0 then 'even' else 'uneven' end) as description, range as value, now()...s of the relation. Example import duckdb duckdb_conn = duckdb . connect () rel = duckdb_conn . sql ( """ select gen_random_uuid() as id, concat('value is ', case when mod(range,2)=0 then 'even' else 'uneven' end) as description, range as value, now()...n of the relation. Example import duckdb duckdb_conn = duckdb . connect () rel = duckdb_conn . sql ( """ select gen_random_uuid() as id, concat('value is ', case when mod(range,2)=0 then 'even' else 'uneven' end) as description, range as value, now()... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Utility Functions – DuckDB 11742
- 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
...esults. force_checkpoint(database) Synchronize WAL with file for (optional) database interrupting transactions. gen_random_uuid() Return a random UUID similar to this: eeccb8c5-9943-b2bb-bb5e-222f4e14b687 . getenv(var) Returns the value of the enviro...ansaction does not have one already. typeof(expression) Returns the name of the data type of the result of the expression. uuid() Return a random UUID (UUIDv4) similar to this: eeccb8c5-9943-b2bb-bb5e-222f4e14b687 . uuidv4() Return a random UUID (UUI...Dv4) similar to this: eeccb8c5-9943-b2bb-bb5e-222f4e14b687 . uuidv7() Return a random UUIDv7 similar to this: 81964ebe-00b1-7e1d-b0f9-43c29b6fb8f5 . uuid_extract_timestamp(uuidv7) Extracts... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Numeric Types – DuckDB 9483
- 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
...sqrt ( 2 ) > '-inf' , 'nan' > sqrt ( 2 ); (sqrt(2) > '-inf') ('nan' > sqrt(2)) true true Universally Unique Identifiers ( UUID s) DuckDB supports universally unique identifiers (UUIDs) through the UUID type. These use 128 bits and are represented in...567890ab (using 36 characters in total including the dashes). For example, 4ac7a9e9-607c-4c8a-84f3-843f0191e3fd is a valid UUID. DuckDB supports generating UUIDv4 and UUIDv7 identifiers. To retrieve the version of a UUID value, use the uuid_extract_v...ersion function . UUIDv4 To generate a UUIDv4 value, use the uuid() function or it aliases the uuidv4() and gen_random_uuid() functions. UUIDv7 T... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- Partitioned Writes – DuckDB 9431
- 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
...ttern By default, files will be named data_0.parquet or data_0.csv . With the flag FILENAME_PATTERN a pattern with {i} or {uuid} can be defined to create specific filenames: {i} will be replaced by an index {uuid} will be replaced by a 128 bits long...s: COPY orders TO 'orders' ( FORMAT parquet , PARTITION_BY ( year , month ), OVERWRITE_OR_IGNORE , FILENAME_PATTERN 'file_{uuid}' ); Overwriting By default the partitioned write will not allow overwriting existing directories. On a local file system,...year , month ), APPEND ); Using the APPEND option result in a behavior similar the OVERWRITE_OR_IGNORE, FILENAME_PATTERN '{uuid}' options, but DuckDB performs an extra check for whether the file already exists and then regenerates the UUID in the rar... - https://man.mtool.work/duckdb/1.3/data/partitioning/partitioned_writes.html
- Values – DuckDB 9017
- 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
...b ( const uint8_t * data , idx_t length ); duckdb_value duckdb_create_bit ( duckdb_bit input ); duckdb_value duckdb_create_uuid ( duckdb_uhugeint input ); bool duckdb_get_bool ( duckdb_value val ); int8_t duckdb_get_int8 ( duckdb_value val ); uint8_t...ckdb_blob duckdb_get_blob ( duckdb_value val ); duckdb_bit duckdb_get_bit ( duckdb_value val ); duckdb_uhugeint duckdb_get_uuid ( duckdb_value val ); char * duckdb_get_varchar ( duckdb_value value ); duckdb_value duckdb_create_struct_value ( duckdb_l...ters input : The duckdb_bit value Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_create_uuid Creates a UUID value from a uhugeint Syntax duckdb_value duckdb_create_uuid ( duckdb_uhugeint input ); Parameters input :... - https://man.mtool.work/duckdb/1.3/clients/c/value.html
- Indexing – DuckDB 8069
- 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
...rdered Integers Another practical way to exploit ordering is to use the INTEGER type with automatic increments rather than UUID for columns queried using selective filters. In a scenario where a table contains out-of-order UUID s, DuckDB has to scan...many row groups to find a specific UUID value. An ordered INTEGER column allows skipping all row groups except those containing the value. ART Indexes DuckDB allo... - https://man.mtool.work/duckdb/1.3/guides/performance/indexing.html
- Complete API – DuckDB 8017
- 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
...b ( const uint8_t * data , idx_t length ); duckdb_value duckdb_create_bit ( duckdb_bit input ); duckdb_value duckdb_create_uuid ( duckdb_uhugeint input ); bool duckdb_get_bool ( duckdb_value val ); int8_t duckdb_get_int8 ( duckdb_value val ); uint8_t...ckdb_blob duckdb_get_blob ( duckdb_value val ); duckdb_bit duckdb_get_bit ( duckdb_value val ); duckdb_uhugeint duckdb_get_uuid ( duckdb_value val ); char * duckdb_get_varchar ( duckdb_value value ); duckdb_value duckdb_create_struct_value ( duckdb_l...ters input : The duckdb_bit value Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_create_uuid Creates a UUID value from a uhugeint Syntax duckdb_value duckdb_create_uuid ( duckdb_uhugeint input ); Parameters input :... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- PHP Client – DuckDB 8017
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...TIMESTAMP_MS Saturio\DuckDB\Type\Timestamp DUCKDB_TYPE_TIMESTAMP_NS TIMESTAMP_NS Saturio\DuckDB\Type\Timestamp DUCKDB_TYPE_UUID UUID Saturio\DuckDB\Type\UUID DUCKDB_TYPE_TIME_TZ TIMETZ Saturio\DuckDB\Type\Time DUCKDB_TYPE_TIMESTAMP_TZ TIMESTAMPTZ Sat... - https://man.mtool.work/duckdb/1.3/clients/php.html
- Conversion between DuckDB and Python – DuckDB 7966
- 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
...BOOLEAN datetime.timedelta → INTERVAL str → VARCHAR bytearray → BLOB memoryview → BLOB decimal.Decimal → DECIMAL / DOUBLE uuid.UUID → UUID The rest of the conversion rules are as follows. int Since integers can be of arbitrary size in Python, there... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- DuckLake – DuckDB 7810
- 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
...into a table with the following schema: Column name Column type table_name VARCHAR schema_id BIGINT table_id BIGINT table_uuid UUID file_count BIGINT file_size_bytes BIGINT delete_file_count BIGINT delete_file_size_bytes BIGINT ducklake_table_insert... - https://man.mtool.work/duckdb/1.3/core_extensions/ducklake.html
DuckDB 1.3 Documentation / man.mtool.work