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

Using KeyOnlyFilter for simple query of select count(1) from <table>

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.3.0
    • None
    • None

    Description

      I found that underlying scan for query "select count(1) or count from <table>" still project all columns.

      It should be fast if we use KeyOnlyFilter for this simple query.

      Attachments

        1. PHOENIX-1594.patch
          54 kB
          James R. Taylor

        Activity

          People

            jamestaylor James R. Taylor
            jeffreyz Jeffrey Zhong
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: