You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@carbondata.apache.org by "Sujith (JIRA)" <ji...@apache.org> on 2016/11/04 17:30:58 UTC

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

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)