Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-8755

Implement Z-ordering for Impala

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Implemented
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Target Version:
    • Epic Color:
      ghx-label-1

      Description

      Implement Z-ordering for Impala: https://en.wikipedia.org/wiki/Z-order_curve

      A Z-order curve defines an ordering on multi-dimensional data. Data sorted that way can be efficiently filtered by min/max statistics regarding to the columns participating in the ordering.

      Impala currently only supports lexicographic ordering via the SORT BY clause. This strongly prefers the first column, i.e. given the "SORT BY A, B, C" clause => A will be totally ordered (hence filtering on A will be very efficient), but values belonging to B and C will be scattered throughout the data set (hence filtering on B or C will barely do any good).

      We could add a new clause, e.g. a "ZSORT BY" clause to Impala that writes the data in Z-order.

      "ZSORT BY A, B C" would cluster the rows in a way that filtering on A, B, or C would be equally efficient.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                norbertluksa Norbert Luksa
                Reporter:
                boroknagyz Zoltán Borók-Nagy
              • Votes:
                0 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: