kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scott Fan <fandayrockwo...@gmail.com>
Subject Re: There was no measure column in the fact table after build cube
Date Fri, 09 Nov 2018 05:40:44 GMT
Got it. Thanks JiaTao.

> 在 2018年11月9日,10:12,JiaTao Tao <taojiatao@gmail.com> 写道:
> 
> Hi Scott Fan,
> 
> 1. Kylin only stores aggregated values in cubes, you can try to query
> sum(PRICE) and see the results.
> 2. It's as expected, "COUNT aggregation" means count(*), it does not need a
> column.
> 
> This link may be helpful:
> http://kylin.apache.org/docs/tutorial/create_cube.html
> 
> Scott Fan <fandayrockworld@gmail.com> 于2018年11月9日周五 上午5:48写道:
> 
>> Hello team,
>> 
>> There are two issues troubled me.
>> 
>> 1. When I build a cube with a measure column as SUM aggregation, e.g. a
>> PRICE,
>> the PRICE column is null in the fact table after it done.
>> 
>> 2. When I build a cube with a COUNT aggregation, there was no related
>> column in the fact table after it done.
>> 
>> 
>> Is there any problems when I built the cube or are there any key points of
>> Kylin's concept that I missed?
>> 
>> Thank you very much.
>> 
>> 
> 
> -- 
> 
> 
> Regards!
> 
> Aron Tao


Mime
View raw message