[GitHub] [carbondata] zhxiaoping opened a new pull request #3295: [CARBONDATA-3373] Fixed measure column filter perf

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

[GitHub] [carbondata] zhxiaoping opened a new pull request #3295: [CARBONDATA-3373] Fixed measure column filter perf

GitBox
zhxiaoping opened a new pull request #3295: [CARBONDATA-3373] Fixed measure column filter perf
URL: https://github.com/apache/carbondata/pull/3295
 
 
   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)
   Be sure to do all of the following checklist to help us incorporate
   
   Be sure to do all of the following checklist to help us incorporate
   your contribution quickly and easily:
   
    - [ ] Any interfaces changed?
   
    - [ ] Any backward compatibility impacted?
   
    - [ ] Document update required?
   
    - [ ] Testing done
           Please provide details on
           - Whether new unit test cases have been added or why no new tests are required?
           - How it is tested? Please attach test report.
           - Is it a performance related change? Please attach the performance test report.
           - Any additional information to help reviewers in testing this change.
         
    - [ ] For large changes, please consider breaking it into sub-tasks under an umbrella JIRA.
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[hidden email]


With regards,
Apache Git Services