v.1.1.54276New Feature
Added UUID Data Type for 16-Byte Identifiers
Added the UUID data type for working with 16-byte identifiers.
Why it matters
This feature introduces native support for UUIDs (Universally Unique Identifiers), allowing efficient storage and manipulation of 16-byte unique identifiers. It resolves the inconvenience and inefficiency of representing UUIDs as strings or other data types, providing optimized performance and better integration for applications that use UUIDs as keys or identifiers.How to use it
Use theUUID data type to define table columns intended to store UUID values. You can insert UUID literals in the standard 36-character format with hyphens or as a UUID function output. Example:CREATE TABLE example (
id UUID,
name String
) ENGINE = MergeTree() ORDER BY id;
INSERT INTO example VALUES ('550e8400-e29b-41d4-a716-446655440000', 'example_name');
SELECT * FROM example WHERE id = '550e8400-e29b-41d4-a716-446655440000';