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

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

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

Akash R Nilugal (Jira)
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)