Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-13667

Add schema columns mapping from user order to system order

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 3.0.0-alpha4
    • None

    Description

      When a schema is defined, the key chunk columns and value chunk columns are sorted so that fixlen columns go first and varlen columns go second, so the sorted column order differs from the order of the user-defined columns.

      We may need a way to keep original columns order, e.g. for SQL, where user expects "select * from" return columns in user-defined order in "create table" statement. It may be a simple relocation table which is a permutation of indices [0..n), so that an internal column order for user index n is relocationTbl[n]. Or maybe we could just store column user-defined order within the column object to use it in Calcite.

      NB: the row assembler will still need to access the internal sorted order for proper row assembly.

      Attachments

        Issue Links

          Activity

            People

              amashenkov Andrey Mashenkov
              agoncharuk Alexey Goncharuk
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1.5h
                  1.5h