Re: cube building taking 8 hours just for 6 thousands records

2017-04-18 Thread Alberto Ramón
Can you check how many ram and cpu is asigned to yarn? El 18 abr. 2017 7:40 a. m., "suresh m" escribió: > Hi This is the time consuming step in entire build process. > > #24 Step Name: Build Cube > > Please help me to get it resolved. > > Regards, > Suresh > > On Mon, Apr 17, 2017 at 5:09 PM, 康凯

[jira] [Created] (KYLIN-2553) ODBC 1.6 version issue when connecting to Kylin 2.0 beta, Tableau 10.2

2017-04-18 Thread Luyuan Zhai (JIRA)
Luyuan Zhai created KYLIN-2553: -- Summary: ODBC 1.6 version issue when connecting to Kylin 2.0 beta, Tableau 10.2 Key: KYLIN-2553 URL: https://issues.apache.org/jira/browse/KYLIN-2553 Project: Kylin

Re:Re: 64bit ODBC 1.6 version issue when connecting to 2.0 beta, tableau 10.2, sql server linked server

2017-04-18 Thread 翟鹿渊
Hi there, I have reproduced the 1st issue listed below and open a JIRA for it. (JIRA:https://issues.apache.org/jira/browse/KYLIN-2553) Hope it helps. Thanks, Adora At 2017-04-17 12:02:02, "Li Yang" wrote: >Thanks for reporting. Let me try reproduce. > >On Thu, Apr 13, 2017 at 9:51 PM, Junhai G

[jira] [Created] (KYLIN-2554) Update Chinese docs to latest kylin

2017-04-18 Thread nichunen (JIRA)
nichunen created KYLIN-2554: --- Summary: Update Chinese docs to latest kylin Key: KYLIN-2554 URL: https://issues.apache.org/jira/browse/KYLIN-2554 Project: Kylin Issue Type: Improvement Com

Re: cube building taking 8 hours just for 6 thousands records

2017-04-18 Thread suresh m
Hi, I can see 150gb ram and 36 cpu in our cluster. On Tue, Apr 18, 2017 at 12:48 PM, Alberto Ramón wrote: > Can you check how many ram and cpu is asigned to yarn? > > El 18 abr. 2017 7:40 a. m., "suresh m" escribió: > > > Hi This is the time consuming step in entire build process. > > > > #24

Re: cube building taking 8 hours just for 6 thousands records

2017-04-18 Thread Alberto Ramón
Are these 150 GB and 36 CPUs configured in? - yarn.nodemanager.resource.memory-mb - yarn.nodemanager.resource.cpu-vcores During Build process, you can open YARN UI how many map-reduce are you using. 2017-04-18 13:21 GMT+01:00 suresh m : > Hi, > > I can see 150gb ram and 36 cpu i

Re: cube building taking 8 hours just for 6 thousands records

2017-04-18 Thread suresh m
sorry it is for all 3 nodes. each node 55gb ram and 12 cpu are there. On Tue, Apr 18, 2017 at 6:09 PM, Alberto Ramón wrote: > Are these 150 GB and 36 CPUs configured in? > >- > >yarn.nodemanager.resource.memory-mb >- > >yarn.nodemanager.resource.cpu-vcores > > During Build pro

Re: cube building taking 8 hours just for 6 thousands records

2017-04-18 Thread Alberto Ramón
Is this your configuration? (check this properties): - yarn.nodemanager.resource.memory-mb =150/3 - yarn.nodemanager.resource.cpu-vcores= 36/3 And Check the YARN UI, during build phase (you can see how many Mappers and reduce, RAM and CPU are you using) 2017-04-18 13:45 GMT+01:00 s

Re: cube building taking 8 hours just for 6 thousands records

2017-04-18 Thread Li Yang
> #24 Step Name: Build Cube It is in-mem cubing taking effect and seems it does not fit your cluster. Try set below in kylin.properties to use layer cubing instead. kylin.cube.algorithm=layer Cheers Yang On Tue, Apr 18, 2017 at 9:13 PM, Alberto Ramón wrote: > Is this your configuration? (che

2.0.0 beta3 package updated

2017-04-18 Thread Li Yang
Hi all, FYI that I just updated the 2.0.0. beta3 package on the download page . Since the beta, we have received many feedback and the release branch 2.0.x has been active -- which is not exactly what I hoped. Let's see if things get stable and the branch cools

Re: Creating Snowflake schema / Link 2 Cubes

2017-04-18 Thread Bart
I think I know what I did wrong. I tried "derived columns" on everything beyond the fact table. If I have a model like above and take a "join between dimensions" column as normal, it built a cube. I'm gonna check it once more, because I had no chance to do that - free time. I will let you know!

??????????: ??????????: Error: java.io.IOException: Unable to initialize any output collector

2017-04-18 Thread 35925138
hive-site.xmlhive.aux.jars.pathhadoop-lzojar??build cube?? yarn Error: java.io.IOException: Unable to initialize any output collector at org.apache.hadoop.mapred.MapTask.createSortingCollector(

[jira] [Created] (KYLIN-2555) Granting authority to not exist users should not be allow

2017-04-18 Thread XIE FAN (JIRA)
XIE FAN created KYLIN-2555: -- Summary: Granting authority to not exist users should not be allow Key: KYLIN-2555 URL: https://issues.apache.org/jira/browse/KYLIN-2555 Project: Kylin Issue Type: Bug