1
76%
master: 76%

Ran 21 May 2019 02:23PM UTC

Files 1057

Run time 1min

Badge

Embed ▾

Committed 21 May 2019 02:23PM UTC coverage: 76.766% (-1.7%) from 78.436%

Job # 1701.1

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

Coverage Stats

62919 of 81962 relevant lines covered (76.77%)

1.02 hits per line

apache / carbondata / 1701 / 1
76%
master: 76%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 1701.1

apache / carbondata / 1701 / 1 76% master: 76%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 1701.1

apache / carbondata / 1701 / 1
76%
master: 76%

README BADGES
x