v.1.1.54276New Feature

Added UUID Data Type for 16-Byte Identifiers

Added the UUID data type for working with 16-byte identifiers.
Added the UUID data type for working with 16-byte identifiers in ClickHouse.

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 the UUID 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';