Wail Y. Alkowaileet created ASTERIXDB-3134:
----------------------------------------------
Summary: 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
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)
