Re: cube query

2017-10-20 Thread Li Yang
Never encountered this exception before. Can you reproduce this on standard Kylin 2.1? If yes, please detail the steps and people can help. On Mon, Oct 16, 2017 at 2:05 PM, kylin_liu wrote: > 你好,在使用kylin2.1 碰到一个问题,kylin2.1 是用源码编译的, 我是用spark 跑的程序,正常跑完 > 但是在查询的时候,无法查询,日志如下: > > Message: com/google

Re: Cube query failing on changing rowkeys column order

2017-04-04 Thread Shailesh Prajapati
Yes, the cube description was edited and it built successfully. Can you elaborate on what you mean by metadata being inconsistent? On Tue, Apr 4, 2017 at 3:23 PM, Li Yang wrote: > From the error log, the cube metadata seems inconsistent. Was the cube JSON > manually edited? > > On Tue, Apr 4, 20

Re: Cube query failing on changing rowkeys column order

2017-04-04 Thread Li Yang
>From the error log, the cube metadata seems inconsistent. Was the cube JSON manually edited? On Tue, Apr 4, 2017 at 5:32 PM, Shailesh Prajapati wrote: > Thanks for the reply. Its just not about query performance, my queries are > not working. I am actually trying with only 50 fact rows. As per

Re: Cube query failing on changing rowkeys column order

2017-04-04 Thread Alberto Ramón
The recommend number of Dim can be 12 or less (depends on a lot of things) Keep in mind that derived dim, are not real Dim because no are included in the cube --> que queries will be slow than normal dim http://kylin.apache.org/docs/howto/howto_optimize_cubes.html http://kylin.apache.org/docs16/

Re: Cube query failing on changing rowkeys column order

2017-04-04 Thread Shailesh Prajapati
Thanks for the reply. Its just not about query performance, my queries are not working. I am actually trying with only 50 fact rows. As per my understanding, query should not fail with any order of rowkeys. On Tue, Apr 4, 2017 at 2:46 PM, Alberto Ramón wrote: > hello, from http://kylin.apache.or

Re: Cube query failing on changing rowkeys column order

2017-04-04 Thread Alberto Ramón
hello, from http://kylin.apache.org/docs16/tutorial/create_cube.html "You can drag & drop a dimension column to adjust its position in rowkey; Put the mandantory dimension at the begining, then followed the dimensions that heavily involved in filters (where condition). Put high cardinality dimensi

Re: Cube query problem

2016-08-27 Thread Alberto Ramón
Did You install flink 1.5.2 for hbase 1.x or for 0.9x? See that there is two versions of kylin I don't have more ideas, good luck El 27/8/2016 15:02, "Li Yang" escribió: > Haven't tested CDH 5.2, but we know CDH 5.7 works well with Kylin. > > On Fri, Aug 19, 2016 at 1:34 PM, lxw wrote: > > > Hi

Re: Cube query problem

2016-08-27 Thread Li Yang
Haven't tested CDH 5.2, but we know CDH 5.7 works well with Kylin. On Fri, Aug 19, 2016 at 1:34 PM, lxw wrote: > Hi,experts: > >After create and build successfully, I use SQL to query the cube and > got error: > > Error while executing SQL "select advid_, sum(pv_) as pv from > lxw1234.t_tab

Re: cube query problem with kylin-1.5.3

2016-08-10 Thread Yiming Liu
If the HBase 1.0 is the only version you have, you could try my build https://github.com/yiming187/kylin/releases/tag/kylin-1.5.3-HBase1.0 This is not Kylin official support, but may help. 2016-08-11 7:59 GMT+08:00 Li Yang : > > hbase-1.0.1 > > We had a couple of reports that Kylin does not work

Re: cube query problem with kylin-1.5.3

2016-08-10 Thread Li Yang
> hbase-1.0.1 We had a couple of reports that Kylin does not work well with hbase-1.0.x Suggest upgrade hbase to 1.1.3+ or downgrade to 0.98 Yang On Thu, Aug 4, 2016 at 1:26 PM, 王峰 wrote: > I exec "$KYLIN_HOME/bin/kylin.sh > org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI > $KYLIN_

Re: cube query problem with kylin-1.5.3

2016-08-03 Thread 王峰
I exec "$KYLIN_HOME/bin/kylin.sh org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI $KYLIN_HOME/lib/kylin-coprocessor-*.jar all" and echo as follows : Is looks like sucess...but I still can not qurey cube ==echo===

Re: cube query problem with kylin-1.5.3

2016-08-03 Thread Cheng Wang
“Caused by: java.lang.NoSuchMethodError: org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment.getRegion()Lorg/apache/hadoop/hbase/regionserver/Region;” It’s sure your current hbase is not compatible to kylin. Tty to do this: http://kylin.apache.org/docs15/howto/howto_update_coprocess

Re: cube query problem with kylin-1.5.3

2016-08-03 Thread 王峰
ok I exec SQL on table "KYLIN_CATEGORY_GROUPINGS" and got Success..like this: ==[QUERY]=== SQL: select * from KYLIN_CATEGORY_GROUPINGS User: ADMIN Success: true Duration: 0.026 Project: learn_kylin Realization Names: [kylin_sales_cube_desc_clone

Re: cube query problem with kylin-1.5.3

2016-08-03 Thread Cheng Wang
OK, then please provide more exception information. On 8/4/16, 11:49 AM, "王峰" wrote: sorry I am not describe rightly , my kylin version is apache-kylin-1.5.3-HBase1.x-bin. I did not use apache-kylin-1.5.3-bin.tar.gz ... 2016-08-04 11:37 GMT+08:00 Cheng Wang : > I meant that you need to check y

Re: cube query problem with kylin-1.5.3

2016-08-03 Thread 王峰
sorry I am not describe rightly , my kylin version is apache-kylin-1.5.3-HBase1.x-bin. I did not use apache-kylin-1.5.3-bin.tar.gz ... 2016-08-04 11:37 GMT+08:00 Cheng Wang : > I meant that you need to check your Kylin version. According to your > environment, try this version: > http://www.apach

Re: cube query problem with kylin-1.5.3

2016-08-03 Thread Cheng Wang
I meant that you need to check your Kylin version. According to your environment, try this version: http://www.apache.org/dyn/closer.cgi/kylin/apache-kylin-1.5.3/apache-kylin-1.5.3-HBase1.x-bin.tar.gz On 8/4/16, 11:03 AM, "wangfeng" wrote: as you say, I check the details logs of kylin-1.5.3,an

Re: cube query problem with kylin-1.5.3

2016-08-03 Thread wangfeng
as you say, I check the details logs of kylin-1.5.3,and found those info: ==[QUERY]=== SQL: select * from KYLIN_SALES User: ADMIN Success: false Duration: 0.0 Project: learn_kylin Realization Names: [kylin_sales_cube_desc_clone_clone] Cubo

Re: cube query problem with kylin-1.5.3

2016-08-03 Thread wangfeng
as you say, I check the details logs of kylin-1.5.3,and found those info: ==[QUERY]=== SQL: select * from KYLIN_SALES User: ADMIN Success: false Duration: 0.0 Project: learn_kylin Realization Names: [kylin_sales_cube_desc_clone_clone] Cuboid Ids:

Re: cube query problem with kylin-1.5.3

2016-08-03 Thread Cheng Wang
Sometimes it is caused by the hbase version. Please check your kylin-1.5.3 details, it might require the hbase version 0.98. On 8/4/16, 12:05 AM, "wangfeng" wrote: Hi, when I installed the kylin-1.5.3 and run sample.sh, everything looks good. However , when I queried the result cube in "Insig