My envs are here:
hadoop: hadoop-2.6.0-cdh5.7.1
hbase: hbase-1.2.0-cdh5.7.1
hive: hive-1.1.0-cdh5.7.1
kylin: 2.0.0
I just run the sql on sample project, and try to make a query like below,
"Timeout visiting cubes" happended. Could you please help me checking it?
Thank you!
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 50000": Timeout visiting cube! Check why coprocessor exception is not
sent back? In coprocessor Self-termination is checked every 100 scanned
rows, the configured timeout(324000000) cannot support this many scans
*There aren't error logs of Hbase region server(not even before or after)*，
logs are like:
2017-07-25 10:38:04,042 INFO [Query
58afb8da-5466-45ee-b30a-fa4451b54562-74] common.KylinConfig: Resetting
SYS_ENV_INSTANCE by a input stream: 320199326
2017-07-25 10:38:04,065 INFO [Query
58afb8da-5466-45ee-b30a-fa4451b54562-74] measure.MeasureTypeFactory:
Checking custom measure types from kylin config
2017-07-25 10:38:04,065 INFO [Query
58afb8da-5466-45ee-b30a-fa4451b54562-74] measure.MeasureTypeFactory:
registering COUNT_DISTINCT(hllc), class
org.apache.kylin.measure.hllc.HLLCMeasureType$Factory
2017-07-25 10:38:04,068 INFO [Query
58afb8da-5466-45ee-b30a-fa4451b54562-74] measure.MeasureTypeFactory:
registering COUNT_DISTINCT(bitmap), class
org.apache.kylin.measure.bitmap.BitmapMeasureType$Factory
2017-07-25 10:38:04,073 INFO [Query
58afb8da-5466-45ee-b30a-fa4451b54562-74] measure.MeasureTypeFactory:
registering TOP_N(topn), class
org.apache.kylin.measure.topn.TopNMeasureType$Factory
2017-07-25 10:38:04,074 INFO [Query
58afb8da-5466-45ee-b30a-fa4451b54562-74] measure.MeasureTypeFactory:
registering RAW(raw), class
org.apache.kylin.measure.raw.RawMeasureType$Factory
2017-07-25 10:38:04,075 INFO [Query
58afb8da-5466-45ee-b30a-fa4451b54562-74] measure.MeasureTypeFactory:
registering EXTENDED_COLUMN(extendedcolumn), class
org.apache.kylin.measure.extendedcolumn.ExtendedColumnMeasureType$Factory
2017-07-25 10:38:04,076 INFO [Query
58afb8da-5466-45ee-b30a-fa4451b54562-74] measure.MeasureTypeFactory:
registering PERCENTILE(percentile), class
org.apache.kylin.measure.percentile.PercentileMeasureType$Factory
2017-07-25 10:38:04,100 INFO [Query
58afb8da-5466-45ee-b30a-fa4451b54562-74] gridtable.GTScanRequest: pre
aggregation is not beneficial, skip it
2017-07-25 10:38:04,109 INFO [Query
58afb8da-5466-45ee-b30a-fa4451b54562-74] endpoint.CubeVisitService: Total
scanned 1 rows and 200 bytes
2017-07-25 10:38:04,110 INFO [Query
58afb8da-5466-45ee-b30a-fa4451b54562-74] endpoint.CubeVisitService: Size of
final result = 55 (46 before compressing)
*and kylin.log is like this*:
2017-07-25 10:38:02,636 DEBUG [Query
58afb8da-5466-45ee-b30a-fa4451b54562-101] enumerator.OLAPEnumerator:122 :
return TupleIterator...
2017-07-25 10:38:02,636 ERROR [Query
58afb8da-5466-45ee-b30a-fa4451b54562-101] service.QueryService:382 :
Exception when execute sql
java.sql.SQLException: 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 50000": Timeout visiting cube! Check why coprocessor exception is not
sent back? In coprocessor Self-termination is checked every 100 scanned
rows, the configured timeout(324000000) cannot support this many scans?
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(AvaticaStatement.java:156)
at
org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:218)
at
org.apache.kylin.rest.service.QueryService.execute(QueryService.java:562)
at
org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:466)
at
org.apache.kylin.rest.service.QueryService.query(QueryService.java:153)
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:357)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672)
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:853)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
....
--
View this message in context:
http://apache-kylin.74782.x6.nabble.com/Timeout-visiting-cube-tp8540.html
Sent from the Apache Kylin mailing list archive at Nabble.com.
