Chenjian Qiu created CARBONDATA-3286:
----------------------------------------
Summary: MV datamap doesn't take effect when query SQL has
coalesce with all projections and no filter condition
Key: CARBONDATA-3286
URL: https://issues.apache.org/jira/browse/CARBONDATA-3286
Project: CarbonData
Issue Type: Bug
Components: core
Affects Versions: 1.5.1
Reporter: Chenjian Qiu
MV datamap doesn't take effect when query SQL has coalesce 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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
