[
https://issues.apache.org/jira/browse/ASTERIXDB-3134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wail Y. Alkowaileet resolved ASTERIXDB-3134.
--------------------------------------------
Resolution: Done
> Enable columnar filters
> -----------------------
>
> Key: ASTERIXDB-3134
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3134
> Project: Apache AsterixDB
> Issue Type: Improvement
> Components: COMP - Compiler, STO - Storage
> Affects Versions: 0.9.9
> Reporter: Wail Y. Alkowaileet
> Assignee: Wail Y. Alkowaileet
> Priority: Major
> Fix For: 0.9.9
>
>
> 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:
> {code:java}SELECT name, age, salary
> FROM Employee
> WHERE age BETWEEN 20 AND 30
> AND salary > 100000{code}
> 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
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
