Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2724

Query with large number of guideposts is slower compared to no stats

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.7.0
    • Fix Version/s: 4.8.0
    • Labels:
      None
    • Environment:

      Phoenix 4.7.0-RC4, HBase-0.98.17 on a 8 node cluster

      Description

      With 1MB guidepost width for ~900GB/500M rows table. Queries with short scan range gets significantly slower.

      Without stats:

      select * from T limit 10; // query execution time <100 msec
      

      With stats:

      select * from T limit 10; // query execution time >20 seconds
      
      Explain plan: CLIENT 876085-CHUNK 476569382 ROWS 876060986727 BYTES SERIAL 1-WAY FULL SCAN OVER T SERVER 10 ROW LIMIT CLIENT 10 ROW LIMIT
      

        Attachments

        1. PHOENIX-2724.patch
          29 kB
          Samarth Jain
        2. PHOENIX-2724_v2.patch
          36 kB
          Samarth Jain
        3. PHOENIX-2724_addendum.patch
          6 kB
          Samarth Jain
        4. 2724.txt
          3 kB
          Lars Hofhansl

          Issue Links

            Activity

              People

              • Assignee:
                lhofhansl Lars Hofhansl
                Reporter:
                mujtabachohan Mujtaba Chohan
              • Votes:
                0 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: