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

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

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.

How to assign namespace of hbase in kylin

2018-10-26 Thread Scott Fan
Hi, How can I assign the namespace of hbase. I don’t want to use the default namespace of hbase. Thanks

[jira] [Created] (KYLIN-3620) "--" should not be a comment marker use between single quotes in SQL

2018-10-11 Thread Scott Fan (JIRA)
Scott Fan created KYLIN-3620: Summary: "--" should not be a comment marker use between single quotes in SQL Key: KYLIN-3620 URL: https://issues.apache.org/jira/browse/KYLIN-3620 Proj

"--" should not be an annotation use between single quotes in SQL

2018-10-11 Thread Scott Fan
Hi, When I exec a SQL below, KYLIN occur an error. SELECT * FROM TABLEA WHERE NAME='Jason--Arthur' Seems like KYLIN use '--' as an annotation. Thanks