Uploaded image for project: 'Apache AsterixDB'
  1. Apache AsterixDB
  2. ASTERIXDB-3134

Enable columnar filters

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      One of the features of the new columnar format is that it keeps the min/max values for each column per mega leaf node (a multi-pages leaf node, which stores 15K tuples by default). For queries with predicates, the filters could be utilized to skip reading the columns of the tuples in a mega leaf node that do not satisfy those predicates.

      For example, in the following query:

      SELECT name, age, salary
      FROM Employee
      WHERE age BETWEEN 20 AND 30
      AND salary > 100000

      the columns name, age, and salary will be read if only the mega leaf node contains employees whose ages are between 20 and 30, and whose salary is greater than 100K

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            wyk Wail Y. Alkowaileet
            wyk Wail Y. Alkowaileet
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment