v.22.2Improvement

Added UUID Support for hex and bin Functions

Official CH changelog text
Added UUID data type support for functions hex and bin. #32170 (Frank Chen).
Added support for the UUID data type in the hex and bin functions in ClickHouse.

Why it matters

This feature allows users to convert UUID values to their hexadecimal and binary representations using the hex and bin functions, enabling easier manipulation and representation of UUID data.

How to use it

Use the existing hex and bin functions directly on columns or values of type UUID to obtain their hexadecimal or binary string representations respectively, for example:

sql<br>SELECT hex(uuid_column), bin(uuid_column) FROM table<br>

Related resources

PreviousNext