I checked the code throwing the exception: https://github.com/apache/kylin/blob/kylin-1.5.1/storage-hbase/src/main/java/org/apache/kylin/storage/hbase/cube/v2/CubeHBaseEndpointRPC.java#L326
seems nothing will be null here... On Wed, May 4, 2016 at 1:29 PM, lidong <[email protected]> wrote: > > > Thanks, > Dong > > Original Message > *Sender:* Phillip Rhodes<[email protected]> > *Recipient:* user<[email protected]> > *Date:* Wednesday, May 4, 2016 12:10 > *Subject:* Re: NullPointerException in .CubeHBaseEndpointRPC$1.run > > 1.5.1, same instance for both the cube build step, and the query. > On May 3, 2016 02:30, "lidong" <[email protected]> wrote: > >> What’s the Kylin Version? >> >> Is the same version between the Kylin you build cube and the Kylin you >> run the query? >> >> Thanks, >> Dong >> >> Original Message >> *Sender:* Phillip Rhodes<[email protected]> >> *Recipient:* user<[email protected]> >> *Date:* Tuesday, May 3, 2016 04:02 >> *Subject:* Re: NullPointerException in .CubeHBaseEndpointRPC$1.run >> >> Another view of that error message, but more focused this time: >> >> 2016-05-03 05:01:21,430 DEBUG [http-bio-7070-exec-6] >> enumerator.OLAPEnumerator:107 : query storage... >> 2016-05-03 05:01:21,448 INFO [http-bio-7070-exec-6] >> v2.CubeStorageQuery:251 : exactAggregation is true >> 2016-05-03 05:01:21,453 INFO [http-bio-7070-exec-6] >> v2.CubeStorageQuery:357 : Memory budget is set to: 3109290 >> 2016-05-03 05:01:21,467 INFO [http-bio-7070-exec-6] >> dict.DictionaryManager:385 : DictionaryManager(293972208) loading >> DictionaryInfo( >> loadDictObj:true) at >> /dict/DEFAULT.KYLIN_CAL_DT/CAL_DT/1e616ceb-1028-4268-a743-38a79c2d09ae.dict >> 2016-05-03 05:01:21,506 DEBUG [http-bio-7070-exec-6] >> v2.CubeHBaseEndpointRPC:256 : New scanner for current segment >> kylin_sales_cube[20 >> 120101000000_20160501000000] will use SCAN_FILTER_AGGR_CHECKMEM as >> endpoint's behavior >> 2016-05-03 05:01:21,524 DEBUG [http-bio-7070-exec-6] >> v2.CubeHBaseEndpointRPC:291 : Serialized scanRequestBytes 321 bytes, >> rawScanBytes >> String 46 bytes >> 2016-05-03 05:01:21,524 INFO [http-bio-7070-exec-6] >> v2.CubeHBaseEndpointRPC:294 : The scan(s) info for current segment is >> as below, s >> hard part of start/end key is set to 0 >> 2016-05-03 05:01:21,526 INFO [http-bio-7070-exec-6] >> v2.CubeHBaseRPC:309 : Visiting hbase table KYLIN_JFVKIFVB8S: cuboid >> exact match, >> from 64 to 64 Start: >> \x00\x00\x00\x00\x00\x00\x00\x00\x00\x40\x00\x00\x00 >> (\x00\x00\x00\x00\x00\x00\x00\x00\x00@\x00\x00\x00) Stop: \ >> x00\x00\x00\x00\x00\x00\x00\x00\x00\x40\xFF\xFF\xFF\x00 >> (\x00\x00\x00\x00\x00\x00\x00\x00\x00@\xFF\xFF\xFF\x00), No Fuzzy Key >> 2016-05-03 05:01:21,527 DEBUG [http-bio-7070-exec-6] >> v2.CubeHBaseEndpointRPC:300 : Submitting rpc to 1 shards starting from >> shard 0, s >> can requests count 1 >> 2016-05-03 05:01:21,613 INFO [http-bio-7070-exec-6] >> v2.CubeHBaseEndpointRPC:125 : Timeout for ExpectedSizeIterator is >> 60000 >> 2016-05-03 05:01:21,625 DEBUG [http-bio-7070-exec-6] >> enumerator.OLAPEnumerator:127 : return TupleIterator... >> 2016-05-03 05:01:21,630 ERROR [pool-3-thread-1] >> v2.CubeHBaseEndpointRPC:98 : Execution exception when running task in >> pool-3-thread-1 >> 2016-05-03 05:01:21,632 ERROR [pool-3-thread-1] >> v2.CubeHBaseEndpointRPC:108 : Caught exception in thread >> pool-3-thread-1: >> java.lang.NullPointerException >> at >> org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$1.run(CubeHBaseEndpointRPC.java:326) >> at >> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) >> at java.util.concurrent.FutureTask.run(FutureTask.java:266) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) >> at java.lang.Thread.run(Thread.java:745) >> >> >> Thanks, >> >> >> >> Phil >> >> >> On Mon, May 2, 2016 at 3:51 PM, Phillip Rhodes <[email protected]> >> wrote: >> > Kylin crew: >> > >> > I'm still trying to get Kylin working on MapR Hadoop, and now I'm seeing >> > the following error when trying to run a query through the Kylin web >> > interface. >> > >> > Building the cube seems to work OK, but this happens at query time. Any >> > ideas? >> > >> > --------------------------------------------------- >> > 2016-05-03 04:34:25,036 DEBUG [http-bio-7070-exec-8] >> > service.CacheService:149 : The new temp olap json is :{ >> > "version": "1.0", >> > "defaultSchema": "DEFAULT", >> > "schemas": [ >> > { >> > "type": "custom", >> > "name": "DEFAULT", >> > "factory": "org.apache.kylin.query.schema.OLAPSchemaFactory", >> > "operand": { >> > "project": "LEARN_KYLIN" >> > }, >> > "functions": [ >> > { >> > name: 'MASSIN', >> > className: 'org.apache.kylin.query.udf.MassInUDF' >> > } >> > ] >> > } >> > ] >> > } >> > >> > 2016-05-03 04:34:25,055 DEBUG [http-bio-7070-exec-8] >> > service.QueryService:289 : getting table metas >> > 2016-05-03 04:34:25,056 DEBUG [http-bio-7070-exec-8] >> > service.QueryService:307 : getting column metas >> > 2016-05-03 04:34:25,068 DEBUG [http-bio-7070-exec-8] >> > service.QueryService:321 : done column metas >> > 2016-05-03 04:34:30,695 INFO [http-bio-7070-exec-3] >> > controller.QueryController:174 : Using project: learn_kylin >> > 2016-05-03 04:34:30,696 INFO [http-bio-7070-exec-3] >> > controller.QueryController:175 : The original query: 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 >> > 2016-05-03 04:34:30,697 INFO [http-bio-7070-exec-3] >> > service.QueryService:265 : The corrected query: select part_dt, >> > sum(price) as tot >> > al_selled, count(distinct seller_id) as sellers from kylin_sales group >> > by part_dt order by part_dt >> > LIMIT 50000 >> > 2016-05-03 04:34:31,218 INFO [http-bio-7070-exec-3] >> > routing.QueryRouter:48 : The project manager's reference is >> > org.apache.kylin.meta >> > data.project.ProjectManager@5c4a45fc >> > 2016-05-03 04:34:31,219 INFO [http-bio-7070-exec-3] >> > routing.QueryRouter:60 : Find candidates by table DEFAULT.KYLIN_SALES >> > and project >> > =LEARN_KYLIN : org.apache.kylin.query.routing.Candidate@408561ee >> > 2016-05-03 04:34:31,222 INFO [http-bio-7070-exec-3] >> > routing.QueryRouter:49 : Applying rule: class >> > org.apache.kylin.query.routing.rule >> > s.RemoveUncapableRealizationsRule, realizations before: >> > [kylin_sales_cube(CUBE)], realizations after: [kylin_sales_cube(CUBE)] >> > 2016-05-03 04:34:31,222 INFO [http-bio-7070-exec-3] >> > routing.QueryRouter:49 : Applying rule: class >> > org.apache.kylin.query.routing.rule >> > s.RealizationSortRule, realizations before: [kylin_sales_cube(CUBE)], >> > realizations after: [kylin_sales_cube(CUBE)] >> > 2016-05-03 04:34:31,222 INFO [http-bio-7070-exec-3] >> > routing.QueryRouter:72 : The realizations remaining: >> > [kylin_sales_cube(CUBE)] And >> > the final chosen one is the first one >> > 2016-05-03 04:34:31,513 DEBUG [http-bio-7070-exec-3] >> > enumerator.OLAPEnumerator:107 : query storage... >> > 2016-05-03 04:34:31,522 INFO [http-bio-7070-exec-3] >> > v2.CubeStorageQuery:251 : exactAggregation is true >> > 2016-05-03 04:34:31,522 INFO [http-bio-7070-exec-3] >> > v2.CubeStorageQuery:357 : Memory budget is set to: 3109290 >> > 2016-05-03 04:34:31,550 DEBUG [http-bio-7070-exec-3] >> > v2.CubeHBaseEndpointRPC:256 : New scanner for current segment >> > kylin_sales_cube[20 >> > 120101000000_20160501000000] will use SCAN_FILTER_AGGR_CHECKMEM as >> > endpoint's behavior >> > 2016-05-03 04:34:31,562 DEBUG [http-bio-7070-exec-3] >> > v2.CubeHBaseEndpointRPC:291 : Serialized scanRequestBytes 321 bytes, >> > rawScanBytes >> > String 46 bytes >> > 2016-05-03 04:34:31,562 INFO [http-bio-7070-exec-3] >> > v2.CubeHBaseEndpointRPC:294 : The scan(s) info for current segment is >> > as below, s >> > hard part of start/end key is set to 0 >> > 2016-05-03 04:34:31,562 INFO [http-bio-7070-exec-3] >> > v2.CubeHBaseRPC:309 : Visiting hbase table KYLIN_JFVKIFVB8S: cuboid >> > exact match, >> > from 64 to 64 Start: >> > \x00\x00\x00\x00\x00\x00\x00\x00\x00\x40\x00\x00\x00 >> > (\x00\x00\x00\x00\x00\x00\x00\x00\x00@\x00\x00\x00) Stop: \ >> > x00\x00\x00\x00\x00\x00\x00\x00\x00\x40\xFF\xFF\xFF\x00 >> > (\x00\x00\x00\x00\x00\x00\x00\x00\x00@\xFF\xFF\xFF\x00), No Fuzzy Key >> > 2016-05-03 04:34:31,563 DEBUG [http-bio-7070-exec-3] >> > v2.CubeHBaseEndpointRPC:300 : Submitting rpc to 1 shards starting from >> > shard 0, s >> > can requests count 1 >> > 2016-05-03 04:34:31,582 INFO [http-bio-7070-exec-3] >> > v2.CubeHBaseEndpointRPC:125 : Timeout for ExpectedSizeIterator is >> > 60000 >> > 2016-05-03 04:34:31,588 DEBUG [http-bio-7070-exec-3] >> > enumerator.OLAPEnumerator:127 : return TupleIterator... >> > 2016-05-03 04:34:31,592 ERROR [pool-9-thread-1] >> > v2.CubeHBaseEndpointRPC:98 : Execution exception when running task in >> > pool-9-thread-1 >> > 2016-05-03 04:34:31,592 ERROR [pool-9-thread-1] >> > v2.CubeHBaseEndpointRPC:108 : Caught exception in thread >> > pool-9-thread-1: >> > java.lang.NullPointerException >> > at >> > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$1.run(CubeHBaseEndpointRPC.java:326) >> > at >> > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) >> > at java.util.concurrent.FutureTask.run(FutureTask.java:266) >> > at >> > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) >> > at >> > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) >> > at java.lang.Thread.run(Thread.java:745) >> > 2016-05-03 04:35:05,120 INFO [pool-1-thread-1] >> > threadpool.DefaultScheduler:106 : Job Fetcher: 0 running, 0 actual >> > running, 0 ready, 2 >> > others >> > 2016-05-03 04:35:31,589 ERROR [http-bio-7070-exec-3] >> > controller.QueryController:209 : 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 fro >> > m kylin_sales group by part_dt order by part_dt >> > LIMIT 50000": Timeout visiting cube! >> > 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:143) >> > at >> > org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:186) >> > at >> > org.apache.kylin.rest.service.QueryService.execute(QueryService.java:356) >> > at >> > org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:272) >> > at >> > org.apache.kylin.rest.service.QueryService.query(QueryService.java:118) >> > at >> > org.apache.kylin.rest.service.QueryService$$FastClassByCGLIB$$4957273f.invoke(<generated>) >> > at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) >> > at >> > org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618) >> > at >> > org.apache.kylin.rest.service.QueryService$$EnhancerByCGLIB$$c9bef1fc.query(<generated>) >> > at >> > org.apache.kylin.rest.controller.QueryController.doQueryWithCache(QueryController.java:192) >> > at >> > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:94) >> > 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:497) >> > at >> > org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213) >> > at >> > org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126) >> > at >> > org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandler >> > Method.java:96) >> > at >> > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandle >> > rAdapter.java:617) >> > at >> > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdap >> > ter.java:578) >> > at >> > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) >> > at >> > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923) >> > at >> > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) >> > at >> > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) >> > at >> > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) >> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) >> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) >> > at >> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) >> > at >> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) >> > at >> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) >> > at >> > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) >> > at >> > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) >> > at >> > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> > at >> > org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) >> > at >> > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> > at >> > org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) >> > at >> > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> > at >> > org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:1 >> > 13) >> > at >> > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> > at >> > org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequ >> > estFilter.java:54) >> > at >> > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> > at >> > org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) >> > at >> > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> > at >> > org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) >> > at >> > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> > at >> > org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt >> > er.java:91) >> > at >> > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> > at >> > org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProce >> > ssingFilter.java:183) >> > at >> > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> > at >> > org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) >> > at >> > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> > at >> > org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87 >> > ) >> > at >> > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> > at >> > org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) >> > at >> > org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) >> > at >> > org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) >> > at >> > org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) >> > at >> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:195) >> > at >> > com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:266) >> > at >> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) >> > at >> > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) >> > at >> > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) >> > at >> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) >> > at >> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) >> > at >> > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) >> > at >> > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) >> > at >> > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) >> > at >> > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) >> > at >> > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) >> > at >> > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) >> > at >> > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) >> > at >> > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) >> > at >> > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) >> > at java.lang.Thread.run(Thread.java:745) >> > Caused by: java.lang.RuntimeException: Timeout visiting cube! >> > at >> > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$ExpectedSizeIterator.next(CubeHBaseEndpointRPC.java:142) >> > at >> > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$ExpectedSizeIterator.next(CubeHBaseEndpointRPC.java:113) >> > 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) >> > at Baz$1$1.moveNext(Unknown Source) >> > at >> > org.apache.calcite.linq4j.EnumerableDefaults.groupBy_(EnumerableDefaults.java:819) >> > at >> > org.apache.calcite.linq4j.EnumerableDefaults.groupBy(EnumerableDefaults.java:754) >> > at >> > org.apache.calcite.linq4j.DefaultEnumerable.groupBy(DefaultEnumerable.java:302) >> > at Baz.bind(Unknown Source) >> > at >> > org.apache.calcite.jdbc.CalcitePrepare$CalciteSignature.enumerable(CalcitePrepare.java:326) >> > at >> > org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(CalciteConnectionImpl.java:281) >> > at >> > org.apache.calcite.jdbc.CalciteMetaImpl._createIterable(CalciteMetaImpl.java:545) >> > at >> > org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(CalciteMetaImpl.java:536) >> > at >> > org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:187) >> > at >> > org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:65) >> > at >> > org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:44) >> > at >> > org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:566) >> > at >> > org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:578) >> > at >> > org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:571) >> > at >> > org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:135) >> > ... 80 more >> > 2016-05-03 04:35:31,591 INFO [http-bio-7070-exec-3] >> > service.QueryService:249 : >> > ==========================[QUERY]=============================== >> > 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 >> > User: ADMIN >> > Success: false >> > Duration: 0.0 >> > Project: learn_kylin >> > Realization Names: [kylin_sales_cube] >> > Cuboid Ids: [64] >> > Total scan count: 0 >> > Result row count: 0 >> > Accept Partial: true >> > Is Partial Result: false >> > Hit Exception Cache: false >> > Storage cache used: false >> > Message: 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! >> > ==========================[QUERY]=============================== >> > >> > 2016-05-03 04:35:31,592 ERROR [http-bio-7070-exec-3] >> > controller.BasicController:44 : >> > org.apache.kylin.rest.exception.InternalErrorException: Error while >> > executing SQL "select part_dt, sum(price) as total_selled, count(d >> > istinct seller_id) as sellers from kylin_sales group by part_dt order >> > by part_dt LIMIT 50000": Timeout visiting cube! >> > at >> > org.apache.kylin.rest.controller.QueryController.doQueryWithCache(QueryController.java:224) >> > at >> > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:94) >> > 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:497) >> > at >> > org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213) >> > at >> > org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126) >> > at >> > org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandler >> > Method.java:96) >> > >> > ------------------- >> > >> > >> > >> > Thanks, >> > >> > >> > Phil >> >> -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
