You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kudu.apache.org by "Grant Henke (Jira)" <ji...@apache.org> on 2021/02/18 16:47:00 UTC

[jira] [Created] (KUDU-3247) UUID column type

Grant Henke created KUDU-3247:
---------------------------------

             Summary: UUID column type
                 Key: KUDU-3247
                 URL: https://issues.apache.org/jira/browse/KUDU-3247
             Project: Kudu
          Issue Type: Improvement
            Reporter: Grant Henke


It could be useful to have a UUID column type in Kudu given often when users can't find a natural key, they look to a UUID as an alternate option. The problem with this is that the UUID value is often stored in a STRING or BINARY column resulting a random ordered write workload which puts a lot of strain on Kudu compaction for high volumes. 

If Kudu has a native UUID type it can leverage the underlying structure of the UUID to benefit from the mostly ordered properties (version 1 and the proposed version 6 UUIDs have a date-time component).

The implementation could be a logical type built on top of BYTES or INT128.

The client should have methods to write the UUID type using encoded UUID strings or UUID objects. 

Here are some references/examples of a UUID type: 
* https://docs.yugabyte.com/latest/api/ycql/type_uuid/
* https://cloud.google.com/spanner/docs/schema-design#uuid_primary_key
* https://www.percona.com/blog/2014/12/19/store-uuid-optimized-way/
* http://gh.peabody.io/uuidv6/
* https://github.com/f4b6a3/uuid-creator#version-6-time-ordered-proposed







--
This message was sent by Atlassian Jira
(v8.3.4#803005)