[jira] [Created] (CARBONDATA-382) Like Filter Query Optimization for Dictionary Columns

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (CARBONDATA-382) Like Filter Query Optimization for Dictionary Columns

Akash R Nilugal (Jira)
Sujith created CARBONDATA-382:
---------------------------------

             Summary: Like Filter Query Optimization for Dictionary Columns
                 Key: CARBONDATA-382
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-382
             Project: CarbonData
          Issue Type: Improvement
            Reporter: Sujith
            Assignee: Sujith


Like Filter Query Optimization for Dictionary Columns

a) Added pushdown mechanism for the Like filters like startsWith,endsWith and contains so that the respective filters will be processed in Carbon layer itself.
b) This mechanism can provide significant gain in the performance of Like filter queries applied in the dictionary since block and blocklet level pruning  will be done in the carbon layer before applying the filter.
c) Since three new expressions has been added in carbon layer the carbon will be applying the expression only once for startsWith/endsWith/contains filter query, this will make the dictionary lookup also once for applying the expression.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)