Re: Query across different MODEL/CUBES

2017-09-06 Thread Yuxiang Mai
Hi, Billy HINT? ECan you help to more specify? And seems it should be 1 fact table for 1 model? Although it's not mandatory. Because Kylin is a Start model for OLAP, we ask modeler not to overlap fact table across models. Is this true & recommended? Thanks for your reply. BR//MYX On

Re: how to filter long tail data

2017-09-06 Thread 杨浩
It's an elegant implementation. I have read the article approximate-topn-measure , and some problem meet in our situation 1. The result is approximate. Our team is to supply statistics data for our company, a big company,

Re: Query across different MODEL/CUBES

2017-09-06 Thread Billy Liu
It sounds like a HINT in SQL. 2017-09-06 17:51 GMT+08:00 Yuxiang Mai : > Hi,all > > We have some questions about query across different model/cubes. We know > that kylin will evaluate the cost and select the best cube to query. In > our usage, this worked very good. But

Re: Kylin on EMR Installation Error

2017-09-06 Thread ShaoFeng Shi
Thanks, I will try EMR 5.8 later; At this moment, you can try emr 5.5; one thing to pay attention is, you need copy a configuration from hbase-site.xml to KYLIN_HOME/conf/kylin_job_conf.xml (replace the zk quorum name with yours): hbase.zookeeper.quorum

Re: Kylin on EMR Installation Error

2017-09-06 Thread Mukund Agilisium
Hi I am using EMR 5.8.0 , the latest one. Thanks & Regards Mukund On Wed, Sep 6, 2017 at 8:44 AM, ShaoFeng Shi wrote: > Hi Mukund, > > What's the EMR version? > > Check if there is other version's jar in EMR node, e.g,: > > sudo find / -name joda-time*.jar > > >

Re: different mr config for different project or cube

2017-09-06 Thread yu feng
Great, Thanks. 2017-09-06 15:07 GMT+08:00 Shuangyin Ge : > Feng, > > Can you please take a look at this part of tutorial http://kylin.apache. > org/docs20/install/advance_settings.html? > > 2017-09-06 14:01 GMT+08:00 yu feng : > >> How to do it in GUI?

Query across different MODEL/CUBES

2017-09-06 Thread Yuxiang Mai
Hi,all We have some questions about query across different model/cubes. We know that kylin will evaluate the cost and select the best cube to query. In our usage, this worked very good. But if we add more models with filter, the problem comes. Here is our scenario, 2 model comes from the same

Re: different mr config for different project or cube

2017-09-06 Thread Shuangyin Ge
Feng, Can you please take a look at this part of tutorial http://kylin.apache.org/docs20/install/advance_settings.html? 2017-09-06 14:01 GMT+08:00 yu feng : > How to do it in GUI? by cube level configuration ? show me an example > please. > > 2017-09-06 10:18 GMT+08:00

Merging cube get error IllegalStateException

2017-09-06 Thread bubugao0809
When trying to merge cubes, I encountered following errors : Error: java.lang.IllegalStateException at com.google.common.base.Preconditions.checkState(Preconditions.java:129) at org.apache.kylin.cube.kv.RowKeyEncoder.encode(RowKeyEncoder.java:123) at