>From the screenshot I see the measure "MAX_VALORACION"'s expression is
"SUM", not MAX;
2016-11-26 21:14 GMT+08:00 Alberto Ramón :
> @ShaoFeng, You're right
> Queries have same result in Hive and Kylin.
>
> *I only have has a problem with MAX* (don't work. But sum,
@ShaoFeng, You're right
Queries have same result in Hive and Kylin.
*I only have has a problem with MAX* (don't work. But sum, min, avg works
OK) (apache-kylin-1.6.0-SNAPSHOT-bin RC1)
SELECT
SUM (FACT_VALORACIONES.VALORACION) as SUM_Valoracion
,MIN (FACT_VALORACIONES.VALORACION) as
I have a super-Fact Table with 5 rows
[image: Imágenes integradas 2]
A- Data in CSV == Hive (OK)
B- Select * from Fact, in Kylin some values are different
The value 9942758, has been transformed in 10937033.8 !!!