Uploaded image for project: 'Kudu'
  1. Kudu
  2. KUDU-3247

UUID column type

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      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:

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                achennaka@cloudera.com Abhishek
                Reporter:
                granthenke Grant Henke
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: