You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Manish Gupta (JIRA)" <ji...@apache.org> on 2018/03/13 12:19:00 UTC

[jira] [Created] (CARBONDATA-2252) Query performance slows down as the number of columns increases in like query with OR expression

Manish Gupta created CARBONDATA-2252:
----------------------------------------

             Summary: Query performance slows down as the number of columns increases in like query with OR expression
                 Key: CARBONDATA-2252
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2252
             Project: CarbonData
          Issue Type: Bug
            Reporter: Manish Gupta
            Assignee: Manish Gupta


Problem: In case of OR condition with like query contains and ends with, the filter is getting pushed down to carbon layer because of which the query is slow as compared to spark applying the same filter on the results returned from carbon

This is because in case of like query the execution is done by RowLevelFilterExecutorImpl which will compute the data row by row. As the number of columns will increase the computation time will increase thereby increasing the query time.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)