Hi there,
We are using kylin 0.6.6, and we found out the max function might not work for negative values in double type. The fact table in Hive only has two columns: id and trans_at and contains six records as shown below: Id trans_at 1, -59.0 2, -229.0 3, -86.4 4, -151.7 5, -199.6 6, -353.5 Then based on the fact table, we created and built a cube with 1 dimension and 3 measures including the default _count_ one: Dimension: id Measures: max(trans_at), sum(trans_at), _count_ The sql used in query was: select id, MAX(trans_at), SUM(trans_at) from the_table group by id, which produced the following output: ID,EXPR$1,EXPR$2 1, 4.9E-324, -59.0 2, 4.9E-324, -229.0 3, 4.9E-324, -86.4 4, 4.9E-324, -151.7 5, 4.9E-324, -199.6 6, 4.9E-324, -353.5 As you can see, max(trans_at) produced 4.9E-324 for each row which is not what we expect to see. Best Regards. Hua
