Re: Can KYLIN support select if ... from SQL?

2017-09-01 Thread Billy Liu
The drawback is the performance. Kylin is pre-calculation engine, which need define the dimensions and measure before queries. In your case, the count distinct statement will be evaluated at the query running time, not from the pre-calculated cuboid directly . 2017-09-01 23:41 GMT+08:00 Yuxiang

Re: Can KYLIN support select if ... from SQL?

2017-09-01 Thread Yuxiang Mai
Thanks.. We will try it. BTW, any drawbacks if we directly use in a where condition? On Fri, Sep 1, 2017 at 11:37 PM, Billy Liu wrote: > The suggested way is to define new column for the if statement, for > example, in a Hive view. > > 2017-09-01 23:08 GMT+08:00 Yuxiang

How to filter the long tail data?

2017-09-01 Thread 杨浩
If a index is less than 2, we don't want to store it in hbase . How to filter the long tail data ?

how to filter long tail data

2017-09-01 Thread 杨浩
If a index is less than 2, we don't want to store it in hbase . How to filter the long tail data ?