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 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!