1701
76%

Ran 21 May 2019 02:23PM UTC

Jobs 1

Files 1057

Run time 1min

Badge

Embed ▾

pending completion

Build # 1701

Build Type

push

jenkins

Committed by ravipesala

Commit Message

[CARBONDATA-3303] Fix that MV datamap return wrong results when using coalesce and less groupby columns

Problem
MV datamap return wrong results when using coalesce and query SQL's groupby columns is less than MV SQL's
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
The query results：
1 tom
2 tom
3 lily

Solution
When query SQL's groupby columns is less than MV SQL's and the MV SQL has coalesce expression, MV table cann't calculate the right result, so MV shouldn't take effect at this scene

This closes #3135

Run Details

62919 of 81962 relevant lines covered (76.77%)

1.02 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	1701.1	21 May 2019 02:23PM UTC	0	76.77

Source Files on build 1701

Detailed source file information is not available for this build.

apache / carbondata / 1701
76%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 1701

apache / carbondata / 1701 76%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 1701

apache / carbondata / 1701
76%

README BADGES
x