[
https://issues.apache.org/jira/browse/ASTERIXDB-3134?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700361#comment-17700361
]
ASF subversion and git services commented on ASTERIXDB-3134:
------------------------------------------------------------
Commit 1df3326dc8e8d325703ad4cd02e625e2804c54d9 in asterixdb's branch
refs/heads/master from Wail Alkowaileet
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=1df3326dc8 ]
[ASTERIXDB-3134][STO][COMP] Enable Columnar Filter - Part 1
- user mode changes: no
- storage format changes: no
- interface changes: yes
Details:
This is the first part to enable columnar filters.
In this patch, we extended FunctionCallInformation
to throw different types of warnings.
Change-Id: I8d8e468709956f9a63e5a46569830377282b0905
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17418
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Wail Alkowaileet <[email protected]>
Reviewed-by: Murtadha Hubail <[email protected]>
> 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)
