Gentle ping...
-----Original Message-----
From: Jiaojiao Li [mailto:[email protected]]
Sent: Tuesday, June 14, 2016 4:51 PM
To: [email protected]
Cc: [email protected]
Subject: Timeout visiting cube
Hi Kylin experts,
Error happens when perform query, query is like this *select count(distinct
userid) from XXX LIMIT 50000*.
Caused by: java.lang.RuntimeException: Timeout visiting cube!
More detailed stack trace shows:
at
org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$ExpectedSizeIterator.next(CubeHBaseEndpointRPC.java:127)
at
org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$ExpectedSizeIterator.next(CubeHBaseEndpointRPC.java:81)
at
com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48)
at
com.google.common.collect.Iterators$6.hasNext(Iterators.java:583)
at
org.apache.kylin.storage.hbase.cube.v2.SequentialCubeTupleIterator.hasNext(SequentialCubeTupleIterator.java:96)
at
org.apache.kylin.query.enumerator.OLAPEnumerator.moveNext(OLAPEnumerator.java:74)
I have increased the *kylin.query.cube.visit.timeout.times* to 10. However it
still suffers from hbase rpc timeout.
Do you have idea on how to solve this problem?
Kylin: 1.5.2
HBase: 1.1.2.2.3.4.7-4
Hadoop: 2.7.1.2.3.4.7-4
Thanks a lot!