There should be more exceptions which telling the root-cause before the TimeoutVisitingCube exception. Like Hongbin said, could you please provided more information?
Thanks, Dong Li 2016-06-15 9:11 GMT+08:00 Jiaojiao Li <jia...@microsoft.com>: > 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! > >
