You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Chenjian Qiu (JIRA)" <ji...@apache.org> on 2019/02/26 06:49:00 UTC
[jira] [Created] (CARBONDATA-3303) MV datamap return wrong results
when using coalesce and less groupby columns
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)