t; but it's not working.
> >
> > --
> > View this message in context: http://apache-kylin.74782.x6.
> > nabble.com/Timeout-visiting-cube-tp8540p8541.html
> > Sent from the Apache Kylin mailing list archive at Nabble.com.
> >
>
>
>
> --
> Best reg
not working.
>
> --
> View this message in context: http://apache-kylin.74782.x6.
> nabble.com/Timeout-visiting-cube-tp8540p8541.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>
--
Best regards,
Shaofeng Shi 史少锋
I've tried this: $KYLIN_HOME/bin/kylin.sh
org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI
$KYLIN_HOME/lib/kylin-coprocessor-*.jar all
but it's not working.
--
View this message in context:
http://apache-kylin.74782.x6.nabble.com/Timeout-visiting-cube-tp8540p8541.html
Sen
rror while executing SQL "select part_dt, sum(price) as total_selled,
count(distinct seller_id) as sellers from kylin_sales group by part_dt order
by part_dt
LIMIT 5": Timeout visiting cube! Check why coprocessor exception is not
sent back? In coprocessor Self-termination is checked every 1
Cool, thanks Leilei for the udpating;
2016-07-05 10:09 GMT+08:00 移动苏州研发中心-陈雷雷 <775620...@qq.com>:
> Problem solved, the reason of my problem is that the hbase version is
> 1.0.0. After I upgrade the hbase to 1.1.3, the timeout visiting cube is
> solved.
>
>
>
Problem solved, the reason of my problem is that the hbase version is 1.0.0.
After I upgrade the hbase to 1.1.3, the timeout visiting cube is solved.
-- --
??: "-??";<775620...@qq.com>;
: 2016??6??21??(?
日,查询时间是9秒
> >
> > 如果where 条件是年,group by 月 ;where 条件是上半年,group by 季度或者月
> > 都会内存溢出错误。
> >
> > Hbase的heap size大小也调到了32GB。kylin.query.cube.visit.timeout.times
> > 调到了10
> >
> >二、如果group by的是nomal维度则查询很快
> >
> >
on groups
时是否需要设置年、上半年、季度、月、周、日为Hierarchies dimensions?
谢谢!
-邮件原件-
发件人: ShaoFeng Shi [mailto:shaofeng...@apache.org]
发送时间: 2016年7月1日 13:23
收件人: u...@kylin.apache.org
抄送: dev@kylin.apache.org
主题: Re: 答复: kylin查询,报超时异常:Timeout visiting cube!
"derived" need post aggregation as we
OK,我修改下dimension试试。
谢谢!
-邮件原件-
发件人: ShaoFeng Shi [mailto:shaofeng...@apache.org]
发送时间: 2016年7月1日 13:23
收件人: u...@kylin.apache.org
抄送: dev@kylin.apache.org
主题: Re: 答复: kylin查询,报超时异常:Timeout visiting cube!
"derived" need post aggregation as we know; from Day to Month, it need
omal维度则查询很快
>
>三、如果增加hbase的regionderver是否可解决此问题 ?
>
>
> 谢谢~
>
>
>
> -邮件原件-
> 发件人: ShaoFeng Shi [mailto:shaofeng...@apache.org]
> 发送时间: 2016年7月1日 9:32
> 收件人: dev
> 抄送: u...@kylin.apache.org
> 主题: Re: kylin查询,报超时异
join dim.dim_kylin_mem_type_buss c on
> a.mem_type=c.mem_type left join dim.dim_kylin_mem_type_source d on
> a.mem_type_source=d.mem_type_source
> where b.dim_year_name='2016年'
> group by b.dim_month_name
> order by b.dim_month_name asc
n dim.dim_kylin_mem_type_buss c on a.mem_type=c.mem_type
> left join dim.dim_kylin_mem_type_source d on
> a.mem_type_source=d.mem_type_source
> where b.dim_year_name='2016年'
> group by b.dim_month_name
> order by b.dim_month_name asc
> LIMIT 5": Timeout visiting cube!
>
onth_name asc
LIMIT 50000": Timeout visiting cube!
at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(Avatica
onth_name asc
LIMIT 50000": Timeout visiting cube!
at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(Avatica
onth_name asc
LIMIT 50000": Timeout visiting cube!
at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(Avatica
--Original Message-
> From: ShaoFeng Shi [mailto:shaofeng...@apache.org]
> Sent: Thursday, June 23, 2016 10:07 AM
> To: dev@kylin.apache.org
> Cc: u...@kylin.apache.org; mahong...@apache.org
> Subject: Re: Timeout visiting cube
>
> Jiao,
>
> From your log it indicates
, June 23, 2016 10:07 AM
To: dev@kylin.apache.org
Cc: u...@kylin.apache.org; mahong...@apache.org
Subject: Re: Timeout visiting cube
Jiao,
From your log it indicates some region servers for that HTable were down so
Kylin couldn't connect, please have a HBase healthy check:
Caus
m: ShaoFeng Shi [mailto:shaofeng...@apache.org]
>> Sent: Tuesday, June 21, 2016 10:51 PM
>> To: dev@kylin.apache.org; u...@kylin.apache.org
>> Cc: mahong...@apache.org
>> Subject: Re: Timeout visiting cube
>>
>> Hi all,
>>
>> Recently we noticed a couple
shaofeng...@apache.org]
> Sent: Tuesday, June 21, 2016 10:51 PM
> To: dev@kylin.apache.org; u...@kylin.apache.org
> Cc: mahong...@apache.org
> Subject: Re: Timeout visiting cube
>
> Hi all,
>
> Recently we noticed a couple of users are facing this timeout error, even
> wi
more information please let me know.
-Original Message-
From: ShaoFeng Shi [mailto:shaofeng...@apache.org]
Sent: Tuesday, June 21, 2016 10:51 PM
To: dev@kylin.apache.org; u...@kylin.apache.org
Cc: mahong...@apache.org
Subject: Re: Timeout visiting cube
Hi all,
Recently we noticed a couple
nnovation Coast
> Zhuhai, 519085, Guangdong, China
>
>
> meizu.com
>
>
>
>
> -邮件原件-
> 发件人: Li Yang [mailto:liy...@apache.org]
> 发送时间: 2016年6月13日 16:41
> 收件人: dev@kylin.apache.org
> 抄送: 吴钰彬
> 主题: Re: Re: Timeout visiting cube!
>
> I suspect somet
-- --
??: "ShaoFeng Shi";;
: 2016??6??21??(??) 10:51
??: "dev"; "user";
: "mahong...@apache.org";
: Re: Timeout visiting cube
In my case, the kylin version is 1.5.1. The hbase v
Sent: Thursday, June 16, 2016 5:15 PM
> To: dev
> Cc: 'mahong...@apache.org'
> Subject: RE: Timeout visiting cube
>
> Thank you for taking time to investigation.
> Today I rerun the query and all the log are as follows.
> Kylin_query.log:
> root@MartiniTest00
rom cortanauu LIMIT 50000": Timeout visiting cube!
at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(Avatica
eads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: Timeout visiting cube!
at
org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$ExpectedSizeIterator.next(CubeHBaseEndpointRPC.java:
actually, can you please attach latest 2 minutes' log before
2016-06-15 02:18:22,741?
it's still incomplete for our analysis
--
Regards,
*Bin Mahone | 马洪宾*
Apache Kylin: http://kylin.io
Github: https://github.com/binmahone
Thanks for your reply. Here is more detailed information.
Query: select count(distinct userid) from TestTable
Web Results info: Error while executing SQL "select count(distinct userid) from
TestTable LIMIT 50000": Timeout visiting cube!
Kylin_query.log:
2016-06-15 02:18:22,737 ERROR
Jiaojiao Li [mailto:jia...@microsoft.com]
> Sent: Tuesday, June 14, 2016 4:51 PM
> To: dev@kylin.apache.org
> Cc: shaofeng...@apache.org
> Subject: Timeout visiting cube
>
>
> Hi Kylin experts,
>
> Error happens when perform query, query is like this *select
> c
Gentle ping...
-Original Message-
From: Jiaojiao Li [mailto:jia...@microsoft.com]
Sent: Tuesday, June 14, 2016 4:51 PM
To: dev@kylin.apache.org
Cc: shaofeng...@apache.org
Subject: Timeout visiting cube
Hi Kylin experts,
Error happens when perform query, query is like this *select
jiao Li [mailto:jia...@microsoft.com]
> 发送时间: 2016年6月13日 14:38
> 收件人: dev@kylin.apache.org
> 主题: Timeout visiting cube
>
> Hi Kylin experts,
>
> Error happens when perform query, query is like this *select
> count(distinct userid) from XXX LIMIT 5*.
>
>
>
&
hina
meizu.com
-邮件原件-
发件人: Jiaojiao Li [mailto:jia...@microsoft.com]
发送时间: 2016年6月13日 14:38
收件人: dev@kylin.apache.org
主题: Timeout visiting cube
Hi Kylin experts,
Error happens when perform query, query is like this *select count(distinct
userid) from XXX LIMIT 5*.
Cause
Hi Kylin experts,
Error happens when perform query, query is like this *select count(distinct
userid) from XXX LIMIT 5*.
Caused by: java.lang.RuntimeException: Timeout visiting cube!
More detailed stack trace shows:
at
org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC
., Ltd.
广东省珠海市科技创新海岸魅族科技楼
MEIZU Tech Bldg., Technology & Innovation Coast
Zhuhai, 519085, Guangdong, China
meizu.com
-邮件原件-
发件人: Li Yang [mailto:liy...@apache.org]
发送时间: 2016年6月13日 16:41
收件人: dev@kylin.apache.org
抄送: 吴钰彬
主题: Re: Re: Timeout visiting cube!
I suspect something went w
What may be the problem?
>
>
>
> gaolv123...@163.com
>
> 发件人: Li Yang
> 发送时间: 2016-06-08 17:24
> 收件人: dev
> 抄送: 吴钰彬
> 主题: Re: 答复: Timeout visiting cube!
> There must be something wrong during cube build. If you are using 1.5.2,
> there is a diagnosis tool that extract useful
Hi Kylin experts,
Error happens when perform query, query is like this *select count(distinct
userid) from XXX LIMIT 5*.
Caused by: java.lang.RuntimeException: Timeout visiting cube!
More detailed stack trace shows:
at
org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC
9:51
> To: dev
> Subject: Re: Timeout visiting cube
> Hi, what's your kylin/hbase/hadoop version?
>
> 2016-06-12 11:43 GMT+08:00 gaolv123...@163.com :
>
> > 你好:
> > 每次当我build完 cube之后,都必须去更新 Update HBase Coprocessor
> > 否则查询的时候便会报错,如下:Error while exe
version infos :
Kylin 1.5.1
HBase 1.1.4 for apache package
hadoop cdh5.7
gaolv123...@163.com
From: ShaoFeng Shi
Date: 2016-06-13 09:51
To: dev
Subject: Re: Timeout visiting cube
Hi, what's your kylin/hbase/hadoop version?
2016-06-12 11:43 GMT+08:00 gaolv123...@163.com :
> 你好:
&g
Hi, what's your kylin/hbase/hadoop version?
2016-06-12 11:43 GMT+08:00 gaolv123...@163.com :
> 你好:
> 每次当我build完 cube之后,都必须去更新 Update HBase Coprocessor
> 否则查询的时候便会报错,如下:Error while executing SQL "SELECT * FROM
> YOOSHU_BID_REQUEST_VIEWS LIMIT 10": Timeout visitin
你好:
每次当我build完 cube之后,都必须去更新 Update HBase Coprocessor
否则查询的时候便会报错,如下:Error while executing SQL "SELECT * FROM
YOOSHU_BID_REQUEST_VIEWS LIMIT 10": Timeout visiting cube!
当执行完$KYLIN_HOME/bin/kylin.sh
org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI
$KYLIN_HOME/lib/kylin-c
version infos :
Kylin 1.5.1
HBase 1.1.4 for apache package。
What may be the problem?
gaolv123...@163.com
发件人: Li Yang
发送时间: 2016-06-08 17:24
收件人: dev
抄送: 吴钰彬
主题: Re: 答复: Timeout visiting cube!
There must be something wrong during cube build. If you are using 1.5.2,
there is a diagnosis tool
at
> org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1235)
> > at
> >
> org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:222)
> > at
> >
> org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlocki
gMethod(AbstractRpcClient.java:222)
> at
> org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:323)
> at
> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.execService(ClientProtos.java:32855)
>
visiting cube!
我不是KYLIN的开发,一样是用户,我之前也碰到过这个问题
你可以尝试在kylin.profile的配置文件里面添加下面的参数,默认值是1,我这边是改成3倍
kylin.query.cube.visit.timeout.times=3
#default is 1
-邮件原件-
发件人: gaolv123...@163.com [mailto:gaolv123...@163.com]
发送时间: 2016年6月7日 20:39
收件人: dev
主题: Timeout visiting cube!
你好:
每次当我build完
你好:
每次当我build完 cube之后,都必须去更新 Update HBase Coprocessor
否则查询的时候便会报错,如下:Error while executing SQL "SELECT * FROM
YOOSHU_BID_REQUEST_VIEWS LIMIT 10": Timeout visiting cube!
当执行完$KYLIN_HOME/bin/kylin.sh
org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI
$KYLIN_HOME/lib/kylin-c
ql, the more times it takes to return
> the results. And when I add almost all the dimension in the sql , it
> returns Timeout visiting cube.
>
>
>
>
>
>
> 2016-05-20 10:12:41,492 ERROR [pool-12-thread-126]
> v2.CubeHBaseEndpointRPC:98 : Execution exception when running tas
hi all
When I query the cube, most of the sql can return results. However the
more dimension included in the sql, the more times it takes to return the
results. And when I add almost all the dimension in the sql , it returns
Timeout visiting cube.
2016-05-20 10:12:41,492 ERROR
tRpcClient.callBlockingMethod(AbstractRpcClient.java:226)
at
org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:331)
at
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$
gt;
> >
> org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(ProtobufUtil.java:327)
> > at
> >
> >
> org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil.java:1624)
> > at
> >
> >
> org.apache.hadoop.hbase.ipc.Reg
cessor.RegionCoprocessorEnvironment.getRegion()Lorg/apache/hadoop/hbase/regionserver/HRegion;
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2212)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:109)
> at
> org.apache.hadoop.hbase.ipc.RpcExecutor
on.callBlockingMethod(AbstractRpcClient.java:331)
at
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.execService(ClientProtos.java:34118)
at
org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil.java:1620)
... 13 more
2016-05-03 15:04:05,474 INFO [pool-5-th
html
>> > I'm get to the step where the cube build succeeds but when I run the
>> query
>> > on Insight, I get the error.
>> >
>> > Error while executing SQL "select part_dt, sum(price) as total_selled,
>> > count(distinct seller_id) as sell
t; > Error while executing SQL "select part_dt, sum(price) as total_selled,
> > count(distinct seller_id) as sellers from kylin_sales group by part_dt
> > order by part_dt LIMIT 5": Timeout visiting cube!
> >
> > Please note that I'm running this on a
the step where the cube build succeeds but when I run the query
> on Insight, I get the error.
>
> Error while executing SQL "select part_dt, sum(price) as total_selled,
> count(distinct seller_id) as sellers from kylin_sales group by part_dt
> order by part_dt LIMIT 5":
, sum(price) as total_selled,
count(distinct seller_id) as sellers from kylin_sales group by part_dt
order by part_dt LIMIT 5": Timeout visiting cube!
Please note that I'm running this on a 5 Node Hadoop Cluster with CDH5.7 on
AWS. I tried installing Kylin on datanode first and got this error. L
54 matches
Mail list logo