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!