Results of 1 - 10 of about 21 for uuid (0.004 sec.)
- Utility Functions 13953
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...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 . get_block_size(database) Returns the block...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/2.0/sql/functions/utility.html
- Numeric Types 10976
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...SELECT 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...67890ab⟩ (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 its aliases the uuidv4() and gen_random_uuid() functions. UUIDv7... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Partitioned Writes 10672
- Examples Write a table to a Hive partitioned dataset of Parquet files: COPY orders TO 'orders' (FORMAT parquet, PARTITION_BY (year, month)); Write a table to a Hive partitioned dataset of CSV files, allowing overwrites: COPY orders TO 'orde
...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...UUID. Write a table to a Hive partitioned dataset of .parquet files, with an index in the filename: COPY orders TO 'orders' (FO...lenames: COPY orders TO 'orders' (FORMAT parquet, PARTITION_BY (year, month), OVERWRITE_OR_IGNORE, FILENAME_PATTERN 'file_{uuid}'); Custom Partition Paths New As of DuckDB 2.0, the PARTITION_PATH option gives full control over the subdirectory that e... - https://man.mtool.work/duckdb/2.0/data/partitioning/partitioned_writes.html
- Values 10012
- The value class represents a single value of any type. API Reference Overview void duckdb_destroy_value ( duckdb_value * value ); duckdb_value duckdb_create_varchar ( const char * text ); duckdb_value duckdb_create_varchar_length ( const ch
...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/2.0/clients/c/value.html
- Rust Client 9048
- Installation To use the DuckDB Rust client, visit the Rust installation page . The latest stable version of the DuckDB Rust client is 2.0.0. The DuckDB Rust client, duckdb-rs , is an ergonomic wrapper over the DuckDB C API that exposes an i
...ecimal . serde_json ToSql and FromSql conversions for serde_json::Value . url ToSql and FromSql conversions for url::Url . uuid ToSql and FromSql conversions for uuid::Uuid . Umbrella Features Feature Enables vtab-full vtab-arrow and appender-arrow ,...the deprecated vtab-excel . extensions-full json , parquet and vtab-full . modern-full chrono , serde_json , url , r2d2 , uuid , polars and rust_decimal . Deprecated Features Feature Enables vtab-excel A no-op retained for feature compatibility. vta... - https://man.mtool.work/duckdb/2.0/clients/rust/overview.html
- Indexing 8659
- DuckDB has two types of indexes: zonemaps and ART indexes. Zonemaps DuckDB automatically creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan opera
...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/2.0/guides/performance/indexing.html
- Typecasting 8659
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...), U64 (UBIGINT), U128 (UHUGEINT), F32 (FLOAT), F64 (DOUBLE), DEC (DECIMAL(18, 3)), STR (VARCHAR), BLOB (BLOB), BIT (BIT), UUID (UUID), DATE (DATE), TIME (TIME), TS (TIMESTAMP), TSTZ (TIMESTAMP WITH TIME ZONE), TTZ (TIME WITH TIME ZONE), IVL (INTERVA...L). From \ To BOOL I8 I16 I32 I64 I128 U8 U16 U32 U64 U128 F32 F64 DEC STR BLOB BIT UUID DATE TIME TS TSTZ TTZ IVL BOOLEAN I E E E E E E E E E E E E E E E TINYINT E I I I I I E E E E E I I I E E SMALLINT E E I I...E E E E E I I I E VARCHAR E E E E E E E E E E E E E E I E E E E E E E E E BLOB E I E E BIT E E E E E E E E E E E E E E E I UUID E E I DATE E I I I TIME E I E TIMESTAMP E E E I I E TIMESTAMP WITH TIME ZONE E E E I E TIME WITH TIME ZONE E E I INTERVAL... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- PHP Client 8372
- The DuckDB PHP client is a tertiary client and is maintained by a third-party. Client API for PHP, focused on performance. The DuckDB PHP client uses the official C API internally through FFI , achieving good benchmark results. This library
...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/2.0/clients/tertiary_clients/php.html
- Create Synthetic Data 8372
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
...nge [0, 1) , which you can scale and cast into any numeric range: SELECT (random() * 100)::INTEGER AS score FROM range(3); UUIDs Several utility functions generate universally unique identifiers, which make good synthetic primary keys: uuid() and its...alias uuidv4() generate random (version 4) UUIDs, uuidv7() generates time-ordered (version 7) UUIDs, and gen_random_uuid() is an alia...s for uuid() : SELECT uuidv7() AS id FROM range(3); Current Date and Time Functions that return the current date or time are handy fo... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- Complete API 7983
- 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
...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/2.0/clients/c/api.html
DuckDB 2.0 Documentation / man.mtool.work