Hi,

I am facing one issue where i need customised sum of values, but i can see
there is  a mismatch in actual sum and sum in kylin.

and as i observed if there is repeated value its taking only once for
summery.

But  in hive i can see exact result and only issue with kylin

For ex: i have my data like below

val date
5 1/12/2017
5 1/12/2017
2 1/12/2017
9 1/12/2017
1 1/13/2017

Actually sum of val group by date means it should give like below,

sum date
21 1/12/2017
1 1/13/2017

But kylin when i execute sum query getting below result,

sum date
16 1/12/2017
1 1/13/2017

We can see clearly its considering distinct values for summarizing result.


Please help to resolve this asap

Regards,
Suresh

Reply via email to