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

["Ravindra Pesala (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CARBONDATA-3303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ravindra Pesala resolved CARBONDATA-3303.
-----------------------------------------
       Resolution: Fixed
    Fix Version/s: 1.6.0

> 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
>            Priority: Blocker
>             Fix For: 1.6.0
>
>          Time Spent: 5.5h
>  Remaining Estimate: 0h
>
> *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)