kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ShaoFeng Shi <>
Subject Re: Codec of decimal (10,6)
Date Sat, 26 Nov 2016 07:20:35 GMT
Hi Alberto,

User need aware that Cube only has aggregated data, no raw data; at the
very begining Kylin will throw error on query like "select * "; but to
provide a better user experience (also to support some BI tools which need
load a subset data to warm up), Kylin answers such query from the base
cuboid (group by all dimensions). The measure column value will be the
aggregated value; So user could not directly compare the "select *" result
from a cube with the source data. If you're comparing the aggregated
queries, I believe they are totally the same.

2016-11-26 4:39 GMT+08:00 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 !!!

Best regards,

Shaofeng Shi 史少锋

View raw message