[jira] [Created] (CARBONDATA-3286) MV datamap doesn't take effect when query SQL has coalesce with all projections and no filter condition

[Akash R Nilugal (Jira)]

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)