Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1598 Encode column names to save space and improve performance
  3. PHOENIX-3590

Filter on value column for mutable encoded table is > 3X slower compared to non encoded table

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Not A Bug
    • None
    • None
    • None
    • None

    Description

      select /*+ SERIAL NO_CACHE*/ k2,c0,c1000,c2000,c3000 from $T where c4000='50' limit 1

      Query get progressively slower if the column which is filtered is the last column of the table.

      For data and schema see data generator script in https://issues.apache.org/jira/browse/PHOENIX-3560

      Attachments

        Activity

          People

            samarthjain Samarth Jain
            mujtabachohan Mujtaba Chohan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: