[
https://issues.apache.org/jira/browse/CARBONDATA-3373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
kumar vishal resolved CARBONDATA-3373.
--------------------------------------
Resolution: Fixed
> Optimize scenes with in numbers in SQL
> --------------------------------------
>
> Key: CARBONDATA-3373
> URL: https://issues.apache.org/jira/browse/CARBONDATA-3373
> Project: CarbonData
> Issue Type: Improvement
> Components: core
> Reporter: zhxiaoping
> Priority: Critical
> Time Spent: 14h 50m
> Remaining Estimate: 0h
>
> when sql with 'in numbers' and spark.sql.codegen.wholeStage is false，the
> query is slow,
> the reason is that canbonscan row level filter's time complexity is O(n^2),
> we can replace list with hashset to improve query performance
> sql example: select * from xx where filed in (1,2,3,4,5,6)
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
