[jira] [Created] (CARBONDATA-3303) MV datamap return wrong results when using coalesce and less groupby columns

[Akash R Nilugal (Jira)]

Chenjian Qiu created CARBONDATA-3303:
----------------------------------------

             Summary: MV datamap return wrong results when using coalesce and less groupby columns
                 Key: CARBONDATA-3303
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3303
             Project: CarbonData
          Issue Type: Bug
            Reporter: Chenjian Qiu


*SQL:*

create table coalesce_test_main(id int,name string,height int,weight int using carbondata

insert into coalesce_test_main select 1,'tom',170,130

insert into coalesce_test_main select 2,'tom',170,120

insert into coalesce_test_main select 3,'lily',160,100

create datamap coalesce_test_main_mv using 'mv' as select coalesce(sum(id),0) as sum_id,name as myname,weight from coalesce_test_main group by name,weight

select coalesce(sum(id),0) as sumid,name from coalesce_test_main group by name

*Result:*

1 tom

2 tom

3 lily



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)