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

2017-02-02 Thread ShaoFeng Shi
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

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

2017-01-31 Thread suresh m
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