Re: Error while building cube from stream

2016-09-26 Thread ShaoFeng Shi
Hi Tony, You're correct; The global dictionary wasn't supported in stream builder (this is the first reporting); Could you please open a JIRA? https://issues.apache.org/jira/secure/Dashboard.jspa BTW, we're developing the new version of streaming engine, which will reuse most of the logic of

Re: AVG measure is missing?

2016-09-26 Thread Ashika Umanga Umagiliya
thanks for the reply. I was asking how to use AVG in measures when we create the cube, not during querying the cubes. Basically , *Step 3. Measures* http://kylin.apache.org/docs15/tutorial/create_cube.html On Mon, Sep 26, 2016 at 5:01 PM, ShaoFeng Shi wrote: > You're

Re: AVG measure is missing?

2016-09-26 Thread ShaoFeng Shi
No need to additionally define AVG; SUM is enough.

Re: AVG measure is missing?

2016-09-26 Thread ShaoFeng Shi
You're right, there is no "avg" measure in GUI. "AVG" will be translated to "SUM"/"COUNT" in kylin in the query time, so if you have pre-defined the two measure, it will work. Just take a try with the sample cube, e.g: select avg(price) from kylin_sales 2016-09-26 14:05 GMT+08:00 Ashika Umanga

Re: [Award] Kylin won InfoWord Bossie Awards 2016, again!

2016-09-26 Thread Roberto Tardío Olmos
Congratulations Kylin team. Keep up the good work! El 22/09/2016 a las 18:35, Luke Han escribió: Hi community, You may already know, in the latest announced news from InfoWorld, Apache Kylin has been selected for this year's Bossie Awards again: *The Best Open Source Big Data Tools*. This

Re: Cube generation 3rd step MR job fails.

2016-09-26 Thread Ashika Umanga Umagiliya
It seems that this is only a WARNING.However , I noticed that even for success cases (managed to build the cube), I can see following WARNINGs and ERRORs.. 2016-09-27 00:15:55,072 WARN [main] org.apache.hadoop.ipc.Client: Exception encountered while connecting to the server :

AVG measure is missing?

2016-09-26 Thread Ashika Umanga Umagiliya
I cannot find average (ABG) measure in the UI as well as in the documentation: In the documentation I cannot find average as well : "There are 5 different types of measure according to its expression: SUM, MAX, MIN, COUNT and COUNT_DISTINCT. Please be carefully to choose the return type, which

Re: Error while building cube from stream

2016-09-26 Thread Tony Lee
Thanks But this does not work on streaming cube. I read some code and found that in class *StreamingCubeBuilder,* the dictionary map was built by *DictionaryGenerator.buildDictionary()* instead of *DictionaryManager.buildDictionary()*. Does this mean that streaming cube does not support global

Cube generation 3rd step MR job fails.

2016-09-26 Thread Ashika Umanga Umagiliya
Greetings, I sucessfyully managed to install Kylin and build the sample cube. We created my own cube using relatively large hive table and during Cube generation, in the step "#3 Step Name: Extract Fact Table Distinct Columns" the MR job fails.(I tried 3 times and it failed everytime giving the

MR Job fails during 3rd step of Cube generation.

2016-09-26 Thread Ashika Umanga Umagiliya
Greetings, I sucessfyully managed to install Kylin and build the sample cube. We created my own cube using relatively large hive table and during Cube generation, in the step "#3 Step Name: Extract Fact Table Distinct Columns" the MR job fails.(I tried 3 times and it failed everytime giving the