Re: Codec of decimal (10,6)

2016-11-26 Thread ShaoFeng Shi
>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,

Re: Codec of decimal (10,6)

2016-11-26 Thread 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, 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

Codec of decimal (10,6)

2016-11-25 Thread Alberto Ramón
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 !!!