qiuchenjian opened a new pull request #3120: [CARBONDATA-3286] MV datamap doesn't take effect when query SQL has oalesce with all projections and no filter condition URL: https://github.com/apache/carbondata/pull/3120 [Problem] MV datamap doesn't take effect when query SQL has oalesce with all projections and no filter condition test case: `create table test_main(id int,name string,height int,weight int) using carbondata` `create datamap test_main_mv using 'mv' as select sum(id) as sum_id, sum(height) as sum_height,name as myname from test_main group by name` `select coalesce(sum(id),12) as sumid, sum(height) as sum_height from test_main group by name` [Solution] Fix this bug to support the scene. `[== Physical Plan == *HashAggregate(keys=[myname#269], functions=[sum(sum_id#267L), sum(sum_height#268L)]) +- Exchange hashpartitioning(myname#269, 200) +- *HashAggregate(keys=[myname#269], functions=[partial_sum(sum_id#267L), partial_sum(sum_height#268L)]) +- *FileScan carbondata default.test_main_mv_table[sum_id#267L,sum_height#268L,myname#269]]` 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 GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
