Urgent!!! exact sum of values are not coming in kylin when executed query in Insight

[suresh m <su...@gmail.com>]

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

Re: Urgent!!! exact sum of values are not coming in kylin when executed query in Insight

[ShaoFeng Shi <sh...@apache.org>]

In the first step of cube build, Kylin creates an intermediate flat table;
did you compare the result between this intermediate table and Kylin? If
they are matched, then you need investigate the source hive table and this
intermediate table. Inner joins, time condition and other factors will
cause certain record be filtered before building into Cube.

2017-01-31 18:40 GMT+08:00 suresh m <su...@gmail.com>:

> 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
>



-- 
Best regards,

Shaofeng Shi 史少锋