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

Performance regression: Aggregate query with filter on table with multiple column families

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 4.7.0
    • 4.7.0
    • None
    • None

    Description

      In the test, table contains total of 6 columns with one column per column family.

      Running a query

      select count(*) from T where last_column < ?

      is 4x slower after commit for PHOENIX-1312 (https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=commit;h=3fdaecdaaa2a2f07070df67f861252fd44e338c3)

      Attachments

        1. PHOENIX-2666.patch
          4 kB
          James R. Taylor
        2. PHOENIX-2666_addendum1.patch
          0.8 kB
          James R. Taylor
        3. PHOENIX-2666_v2.patch
          28 kB
          James R. Taylor
        4. PHOENIX-2666-addendum.txt
          1.0 kB
          Lars Hofhansl

        Activity

          People

            jamestaylor James R. Taylor
            mujtabachohan Mujtaba Chohan
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: