UUID
ClickHouse reference - UUID functions
Creation
UUID.generateUUIDv4, UUID.UUIDv4
Returns a new v4 UUID.
v.s(UUID.UUIDv4()) 'c735a549-ba27-4cb3-94c4-f795ebb3f524'
Methods
UUIDStringToNum
v.select(UUID('fe74651b-3fc2-44cc-92b3-5a975dc22f13').UUIDStringToNum().cast(String).base64Encode()).s row base64Encode(cast(UUIDStringToNum(\'fe74651b-3fc2-44cc-92b3-5a975dc22f13\'), \'String\')) ----- ------------------------------------------------------------------------------------------- 1 /nRlGz/CRMySs1qXXcIvEw== (1 row)
UUIDNumToString
v.select(UUID(UUID('fe74651b-3fc2-44cc-92b3-5a975dc22f13').UUIDStringToNum()).UUIDNumToString()).s row UUIDNumToString(UUIDStringToNum(\'fe74651b-3fc2-44cc-92b3-5a975dc22f13\')) ----- ---------------------------------------------------------------------------- 1 fe74651b-3fc2-44cc-92b3-5a975dc22f13 (1 row)