Re: No build all dimensions

2017-02-21 Thread Luke_Selina
Hi, Copperfield I don't think kylin is suitable for flexible business requirement, it's a statistic tool. Another question you mean you always have to use more than 15 dimensions in a cube, I think this is a challenge to control the query time delay and the size of cube, while your data set

Re: create dictionary error

2017-02-12 Thread Luke_Selina
Have you solved the problem? Please let me know Or May be you can try another dimension Encoding method(fix_length、integer and so on). Good Luck! Luke_Selina -- View this message in context: http://apache-kylin.74782.x6.nabble.com/create-dictionary-error-tp7155p7171.html Sent from the Apache

Can not Clean Up

2016-12-08 Thread Luke_Selina
I use the command '/opt/kylin/bin/kylin.sh org.apache.kylin.storage.hbase.util.StorageCleanupJon --delete true' to clean up my cluster, but it claims Could not find or load main class org.apache.kylin.storage.hbase.util.StorageCleanuoJon, please give me some suggestions, thank you! my env:

Re: Can not Clean Up

2016-12-08 Thread Luke_Selina
Absolutely yes ! If not how I can run kylin? -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Can-not-Clean-Up-tp6554p6559.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Can not Clean Up

2016-12-08 Thread Luke_Selina
Just as the pic shows it still shows Error @Billy Liu -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Can-not-Clean-Up-tp6554p6556.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Can not Clean Up

2016-12-12 Thread Luke_Selina
Hi Liu @Billy Liu, it's very nice to tell you that the clean tool wroks now! So strange, I have done nothing, but it works thank you for your suggestion! -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Can-not-Clean-Up-tp6554p6601.html Sent from the Apache Kylin mailing

Re: [jira] [Created] (KYLIN-2077) Inconsistent cube desc signature for CubeDesc

2016-12-13 Thread Luke_Selina
So, now I meet the same problem as you ever had, I just do as you said but the problem still exists, do you know why this happens? Thank you! -- View this message in context:

Can kylin intermediate tables in hive be deleted ?

2016-12-13 Thread Luke_Selina
Hi all, just as the pic shows, can these intermediate hive tables can be deleted manually? -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Can-kylin-intermediate-tables-in-hive-be-deleted-tp6617.html

Re: [jira] [Created] (KYLIN-2281) Pending on the first step(save data from kafka) when building streaming cube

2016-12-14 Thread Luke_Selina
Maybe you should go to look into the MR Application, to make sure the Job have got the resource to run, good luck to you! -- View this message in context:

Use Spark Cube Engine

2016-12-06 Thread Luke_Selina
Hello Guys! How could I configure to make kylin build cube by Spark? There is nothing related to this among the office docs, please help me! And the last Could you please make the docs to pdf type, so that we can download, not need to access the internet all the time, thank you! -- View

Re: Use Spark Cube Engine

2016-12-06 Thread Luke_Selina
Though Spark is a experimental component, I still want to have a try, please tell me how, thank you! -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Use-Spark-Cube-Engine-tp6514p6517.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Kybot bug?

2017-01-01 Thread Luke_Selina
Sorry, I will obey the rules -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Kybot-bug-tp6800p6810.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Kybot bug?

2016-12-30 Thread Luke_Selina
Hei guys, just as the above picture, when I use kylin to diagnose my cube, why it shows two same tag but with different value? Is this a version conflict, my kylin version is 1.5.4, and the keybot is the latest. Another

Re: [jira] [Created] (KYLIN-2306) Tolerate Class missing when loading job list

2016-12-21 Thread Luke_Selina
-- View this message in context: http://apache-kylin.74782.x6.nabble.com/jira-Created-KYLIN-2306-Tolerate-Class-missing-when-loading-job-list-tp6715p6731.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Kylin Performance

2016-12-21 Thread Luke_Selina
Great and Agree! But I still have an question like Alberto, why in an AGG one dim can use only one regulation(mandatory, join, hierachy)? -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Kylin-Performance-tp6713p6728.html Sent from the Apache Kylin mailing list archive at

Re: Failed with "Build Cube" in 18 step

2016-12-21 Thread Luke_Selina
This is the log. @shaofengshi Log Type: stderr Log Upload Time: Tue Dec 20 14:56:16 +0800 2016 Log Length: 241 log4j:WARN No appenders could be found for logger (org.apache.hadoop.mapreduce.task.reduce.Fetcher). log4j:WARN Please initialize the log4j system properly. log4j:WARN See

Failed with "Build Cube" in 18 step

2016-12-20 Thread Luke_Selina
Hei guys! Just now I have build a Cube with SSB data, and only 10 dimensions used. But the cube build failed, I saw the MR logs, it shows the build failed in reduce period, how can I config to make the reduce can use more memory, or with less number of reduce? Thank you! -- View this

Re: [jira] [Created] (KYLIN-2313) Cannot find a cube in a subquery case with count distinct

2016-12-25 Thread Luke_Selina
It seems that I have met a more serious problem the same as you. So here two things I really want to know. 1. Have you found out how your query error happens? and second, is the cube you use the same as generated by sample.sh? 2. When I use SSB data, I build a Cube with d_year grouped, but when

Re: Failed with "Build Cube" in 18 step

2016-12-21 Thread Luke_Selina
What I want to mention is that, Hadoop is not familiar to everyone. People may always blocked by building a large cube. -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Failed-with-Build-Cube-in-18-step-tp6700p6742.html Sent from the Apache Kylin mailing list archive at

Re: Failed with "Build Cube" in 18 step

2016-12-20 Thread Luke_Selina
I change the default *kylin.job.mapreduce.default.reduce.input.mb = 500 --> 5* then the build have successed! But the mr log shows it have failed two time in convert the cuboid to hfile(19 step), so how many time will the mr job try before the task failed, is it configured? But I still

Re: Table 'AFFILIATE_VALID_CLICK' not found. Sometimes table not found,Why?

2016-12-20 Thread Luke_Selina
The error is so obviously, your sql can't realize your table 'AFFILIATE_VALID_CLICK', so you may try you fix it by the following steps 1. make sure table name is true 2. try figure out your cube built with this table If all these are right , paste your model, cube info here. -- View this message