Re: There was no measure column in the fact table after build cube

2018-11-08 Thread Scott Fan
Got it. Thanks JiaTao. > 在 2018年11月9日,10:12,JiaTao Tao 写道: > > 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

Re: There was no measure column in the fact table after build cube

2018-11-08 Thread Scott Fan
Got it. Thanks JiaTao. > 在 2018年11月9日,10:12,JiaTao Tao 写道: > > 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

Re: There was no measure column in the fact table after build cube

2018-11-08 Thread JiaTao Tao
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

There was no measure column in the fact table after build cube

2018-11-08 Thread Scott Fan
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.