Re: 答复: Cube optimization for help

2016-11-28 Thread Li Yang
The cube is pretty optimal in terms of dimensions. > and 7 COUNT_DISTINCT expressions This is the heaviest workload I see. You may confirm the CPU usage of MR job, if the bottleneck is CPU, then room of improvement is limited by the hardware. On Mon, Nov 28, 2016 at 7:57 PM, 仇同心 wrote: > Thanks

Re: Apache Kylin 1.6.0 released

2016-11-28 Thread Li Yang
Finally, streaming cubing is out!! Cheers!! On Mon, Nov 28, 2016 at 6:36 PM, ShaoFeng Shi wrote: > Alberto, > > You're right, the new ODBC driver fixed some reported issues in PowerBI > and Tableau 10; Please upgrade and take a try. > > 2016-11-28 18:32 GMT+08:00 Alberto Ramón : > >> Heyyy, :

Re: ODBC 1.6

2016-11-28 Thread Dong Li
Hi Alberto, Thanks for your report. To avoid "dirty system", we suggest to uninstall old driver before install the new one: http://kylin.apache.org/docs15/tutorial/odbc.html I reproduced the issue in my powerbi+win7 env. The issue only happens when you extract KYLIN_CATEGORY_GROUPINGS.CATEG_L

Re: Testing 1.6

2016-11-28 Thread Li Yang
Actually I'm not sure of the auto-refreshing now.. It never worked in my browser too. However my impression was it was done... Sorry, double checked, it was planned but is not actually done in 1.6.0. My bad. Regards, Yang On Sat, Nov 26, 2016 at 8:08 PM, Alberto Ramón wrote: > JaJa Thanks > I

Re: ODBC 1.6

2016-11-28 Thread Alberto Ramón
Issue if you have a "dirty system" with previous version: ODBC 1.5 tested on: - Win7 ultimate (new system) and tableau 10 ==> OK - Win7 ultimate (new system) and PowerBI 2.4 ==> Error in preview TB Kylin Category (the other 2 works OK) [image: Imágenes integradas 1] The load data, fails in all

Re: ODBC 1.6

2016-11-28 Thread Dong Li
Hello Alberto, Thanks very much for your feedback. There're some packaging issues in previous build. We've uploaded a new build. Please go to download page and find the latest ODBC Drive 1.6. Thanks. Thanks, Dong Li Thanks, Dong Li 2016-11-28 22:28 GMT+08:00 Alberto Ramón : > Nice ¡¡ > Tell m

Re: ODBC 1.6

2016-11-28 Thread Alberto Ramón
Nice ¡¡ Tell me and I will re-check in my Windows (I tried to install C++ 2013, c++2015 and c++2015 update 4, With the same negative result) 2016-11-28 15:24 GMT+01:00 ShaoFeng Shi : > I see; We will check and upload a new build soon. will update here once > finished. > > 2016-11-28 22:17 GMT+0

Re: ODBC 1.6

2016-11-28 Thread ShaoFeng Shi
I see; We will check and upload a new build soon. will update here once finished. 2016-11-28 22:17 GMT+08:00 Alberto Ramón : > x64, all system are 64 bits (win 7 ultimate, and Win Server 2008 R2) > > 2016-11-28 14:58 GMT+01:00 ShaoFeng Shi : > >> Hi Alberto, Kylin ODBC zip has two exe files; whic

Re: ODBC 1.6

2016-11-28 Thread Alberto Ramón
x64, all system are 64 bits (win 7 ultimate, and Win Server 2008 R2) 2016-11-28 14:58 GMT+01:00 ShaoFeng Shi : > Hi Alberto, Kylin ODBC zip has two exe files; which one are you > installing, the x86 one or x64 one? > > 2016-11-28 21:51 GMT+08:00 Alberto Ramón : > >> More Info: >> >> - Same error

Re: ODBC 1.6

2016-11-28 Thread ShaoFeng Shi
Hi Alberto, Kylin ODBC zip has two exe files; which one are you installing, the x86 one or x64 one? 2016-11-28 21:51 GMT+08:00 Alberto Ramón : > More Info: > > - Same error in Win Srv 2008R2 > - I start ODBC config using: C:\Windows\System32\odbcad32.exe (to be > sure start ODBC 64 bits version)

Re: ODBC 1.6

2016-11-28 Thread Alberto Ramón
More Info: - Same error in Win Srv 2008R2 - I start ODBC config using: C:\Windows\System32\odbcad32.exe (to be sure start ODBC 64 bits version) 2016-11-28 14:34 GMT+01:00 Alberto Ramón : > Hello > > I'm try to test New Kylin ODBC Driver 1.6, > When I try to create New ODBC, I have this error >

ODBC 1.6

2016-11-28 Thread Alberto Ramón
Hello I'm try to test New Kylin ODBC Driver 1.6, When I try to create New ODBC, I have this error [image: Imágenes integradas 1] (I tested In two Win7 SP1, I didn't have problems with 1.5) The dependencies of Ms Visual C++ are the same than old version? (C++ 2012) Also saw the Version identifie

Re: Apache Kylin 1.6.0 released

2016-11-28 Thread ShaoFeng Shi
Alberto, You're right, the new ODBC driver fixed some reported issues in PowerBI and Tableau 10; Please upgrade and take a try. 2016-11-28 18:32 GMT+08:00 Alberto Ramón : > Heyyy, :) > > There is a new version of Kylin ODBC Driver ¡¡ > > [image: Imágenes integradas 1] > > I will testing with P

Re: Apache Kylin 1.6.0 released

2016-11-28 Thread Alberto Ramón
Heyyy, :) There is a new version of Kylin ODBC Driver ¡¡ [image: Imágenes integradas 1] I will testing with PowerBI (Last nigth I tried Kylin 1.6.0 & Driver 1.5 with PowerBI and failed) 2016-11-28 8:01 GMT+01:00 ShaoFeng Shi : > The Apache Kylin team is pleased to announce the immediate avai

Re: Cube optimization for help

2016-11-28 Thread Dong Li
Hi Tongxin, Are these dimensions’ cardinality very very small? "PWDTYPE”, “IS_NEW_CARD”, "REQ_ORDER_YEWU_TYPE”, "ORDER_YEWU_TYPE”, If yes, try to put them in one joint aggr group. This may help to reduce the expansion rate. Thanks, Dong Li Original Message Sender:仇同心qiutong...@jd.com Recip

Re: KYLIN throws null exception when execute specific query

2016-11-28 Thread 林豪(linhao)-技术产品中心
Create a JIRA: https://issues.apache.org/jira/browse/KYLIN-2234 林豪 技术产品中心 云平台 | 服务云Wiki 云路系统 • |分机 8393| +86 13611801618 | • lin...@qiyi.com From: ShaoFeng Shi Reply-To: "user@ky

Re: KYLIN throws null exception when execute specific query

2016-11-28 Thread ShaoFeng Shi
Hi Linhao, Wecome to open a JIRA to Kylin: https://issues.apache.org/jira/secure/Dashboard.jspa 2016-11-28 14:42 GMT+08:00 林豪(linhao)-技术产品中心 : > So, this is a bug of KYLIN? Is there any workaround solution? > > > > *林豪* > > 技术产品中心 云平台 | 服务云Wiki >

Re: Build Erro in Step : Build Dimension Dictionary

2016-11-28 Thread Li Yang
Especially how can this issue be produced, if data and steps can be provided, that will be great. On Wed, Nov 23, 2016 at 11:09 AM, Billy(Yiming) Liu wrote: > Kylin build snapshots for lookup tables. But it's OK for NULL value. Could > you log a JIRA and show the reproduce steps? > > 2016-11-23