Size of my hive fact table = 3.27 GB ( row count 25,236,160)
Cube size = 2.21 GB
I created hierarchy dimension with 18 levels.
Col1 -> Col2 -> ......upto Col18
For this 18 levels, total cardinality = 2635
I attached 2 log files.
Log1 - query with limit 1000000
Partial result came.
Log2 - Clicked show all in Query result.
Getting ERROR : exception while executing query: Scan row count exceeded
threshold: 4000000, please add filter condition to narrow down backend scan
range, like where clause.
Thanks,
Parkavi.
-----Original Message-----
From: hongbin ma [mailto:[email protected]]
Sent: Wednesday, May 13, 2015 7:15 AM
To: dev
Subject: Re: Increase query performance
before you expand your cluster, you might need to analyse why it's delivering
poor performance.
how about the size of your hive fact table? the cardinality of the dimension
columns?
if possible you can run a query,and paste the query's log in
KYLIN_HOME/logs/kylin.log for that query. we can help you check for any
abnormalities. (make sure you're writing a slightly different query, to avoid
hitting cache)
On Tue, May 12, 2015 at 2:04 PM, Parkavi Nandagopal <[email protected]>
wrote:
> Hi ,
>
> I have installed kylin and created cube(3GB size) with only one region
> server and when I query the cube data, it is taking much time to show
> the query result in Kylin web UI.
> If I add 3 or more region server node with high configuration and I
> create a cube then query the cube means will it increase the query
> performance?
>
>
> Thanks,
> Parkavi.
>
>
> ::DISCLAIMER::
>
> ----------------------------------------------------------------------
> ----------------------------------------------------------------------
> --------
>
> The contents of this e-mail and any attachment(s) are confidential and
> intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as
> information could be intercepted, corrupted, lost, destroyed, arrive
> late or incomplete, or may contain viruses in transmission. The e mail
> and its contents (with or without referred errors) shall therefore not
> attach any liability on the originator or HCL or its affiliates.
> Views or opinions, if any, presented in this email are solely those of
> the author and may not necessarily reflect the views or opinions of
> HCL or its affiliates. Any form of reproduction, dissemination,
> copying, disclosure, modification, distribution and / or publication
> of this message without the prior written consent of authorized
> representative of HCL is strictly prohibited. If you have received
> this email in error please delete it and notify the sender
> immediately.
> Before opening any email and/or attachments, please check them for
> viruses and other defects.
>
>
> ----------------------------------------------------------------------
> ----------------------------------------------------------------------
> --------
>
--
Regards,
*Bin Mahone | 马洪宾*
Apache Kylin: http://kylin.io
Github: https://github.com/binmahone
[pool-6-thread-1]:[2015-05-13
10:25:14,747][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:117)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 11 others
[pool-6-thread-1]:[2015-05-13
10:26:14,748][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:117)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 11 others
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,544][INFO][org.apache.kylin.rest.controller.QueryController.doQuery(QueryController.java:189)]
- Using project: KTDemo
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,545][INFO][org.apache.kylin.rest.controller.QueryController.doQuery(QueryController.java:190)]
- The original query: select col1,col2,....col18,
max(val) as valuess
from facttable
group by col1,col2,....col18
order by col1,col2,....col18
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,622][INFO][org.apache.kylin.query.routing.QueryRouter.selectRealization(QueryRouter.java:45)]
- Find candidates by table DEFAULT.FACTTABLE and project=KTDEMO :
CUBE[name=Cube1]
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,623][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:53)]
- Initial realizations order:
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,623][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:54)]
- [Cube1]
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,623][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:55)]
- Applying rule class
org.apache.kylin.query.routing.RoutingRules.RealizationPriorityRule
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,624][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:59)]
- [Cube1]
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,624][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:60)]
- ===================================================
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,624][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:53)]
- Initial realizations order:
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,624][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:54)]
- [Cube1]
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,625][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:55)]
- Applying rule class
org.apache.kylin.query.routing.RoutingRules.RemoveUncapableRealizationsRule
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,625][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:59)]
- [Cube1]
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,625][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:60)]
- ===================================================
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,626][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:53)]
- Initial realizations order:
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,626][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:54)]
- [Cube1]
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,626][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:55)]
- Applying rule class
org.apache.kylin.query.routing.RoutingRules.SimpleQueryMoreColumnsCubeFirstRule
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,626][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:59)]
- [Cube1]
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,627][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:60)]
- ===================================================
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,627][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:53)]
- Initial realizations order:
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,627][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:54)]
- [Cube1]
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,627][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:55)]
- Applying rule class org.apache.kylin.query.routing.RoutingRules.CubesSortRule
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,628][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:59)]
- [Cube1]
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,628][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:60)]
- ===================================================
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,628][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:53)]
- Initial realizations order:
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,629][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:54)]
- [Cube1]
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,629][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:55)]
- Applying rule class
org.apache.kylin.query.routing.RoutingRules.AdjustForWeeklyMatchedRealization
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,629][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:59)]
- [Cube1]
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,629][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:60)]
- ===================================================
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,630][INFO][org.apache.kylin.query.routing.QueryRouter.selectRealization(QueryRouter.java:54)]
- The realizations remaining:
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,630][INFO][org.apache.kylin.query.routing.QueryRouter.selectRealization(QueryRouter.java:55)]
- [Cube1]
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,630][INFO][org.apache.kylin.query.routing.QueryRouter.selectRealization(QueryRouter.java:56)]
- The realization being chosen: Cube1
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,689][DEBUG][org.apache.kylin.query.enumerator.CubeEnumerator.queryStorage(CubeEnumerator.java:130)]
- query storage...
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,691][INFO][org.apache.kylin.storage.hbase.CubeStorageEngine.isExactAggregation(CubeStorageEngine.java:184)]
- exactAggregation is true
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,692][INFO][org.apache.kylin.storage.hbase.coprocessor.observer.ObserverEnabler.isCoprocessorBeneficial(ObserverEnabler.java:110)]
- Coprocessor is disabled because exactAggregation is true
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,693][INFO][org.apache.kylin.storage.hbase.CubeSegmentTupleIterator.logScan(CubeSegmentTupleIterator.java:236)]
-
Scan hbase table KYLIN_38F5WB8H5U: cuboid exact match, from 262143 to 262143
Start:
\x00\x00\x00\x00\x00\x03\xFF\xFF\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00
-
\x00\x00\x00\x00\x00\x03\xFF\xFF\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00
Stop:
\x00\x00\x00\x00\x00\x03\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\x00
-
\x00\x00\x00\x00\x00\x03\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\x00
[http-bio-7070-exec-6]:[2015-05-13
10:26:44,695][DEBUG][org.apache.kylin.query.enumerator.CubeEnumerator.queryStorage(CubeEnumerator.java:144)]
- return TupleIterator...
[pool-6-thread-1]:[2015-05-13
10:27:14,739][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:117)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 11 others
[pool-6-thread-1]:[2015-05-13
10:28:14,745][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:117)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 11 others
[pool-6-thread-1]:[2015-05-13
10:29:14,738][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:117)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 11 others
[pool-6-thread-1]:[2015-05-13
10:30:14,765][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:117)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 11 others
[pool-6-thread-1]:[2015-05-13
10:31:14,739][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:117)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 11 others
[pool-6-thread-1]:[2015-05-13
10:32:14,739][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:117)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 11 others
[pool-6-thread-1]:[2015-05-13
10:33:14,739][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:117)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 11 others
[http-bio-7070-exec-6]:[2015-05-13
10:34:02,242][DEBUG][org.apache.kylin.storage.hbase.CubeSegmentTupleIterator.closeScanner(CubeSegmentTupleIterator.java:125)]
- Scan
{"timeRange":[0,9223372036854775807],"batch":-1,"startRow":"\\x00\\x00\\x00\\x00\\x00\\x03\\xFF\\xFF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00","stopRow":"\\x00\\x00\\x00\\x00\\x00\\x03\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\x00","loadColumnFamiliesOnDemand":null,"totalColumns":1,"cacheBlocks":true,"families":{"F1":["M"]},"maxResultSize":-1,"maxVersions":1,"caching":1024}
[http-bio-7070-exec-6]:[2015-05-13
10:34:02,243][ERROR][org.apache.kylin.rest.controller.QueryController.doQuery(QueryController.java:226)]
- Exception when execute sql
java.sql.SQLException: exception while executing query: Scan row count exceeded
threshold: 4000000, please add filter condition to narrow down backend scan
range, like where clause.
at net.hydromatic.avatica.Helper.createException(Helper.java:39)
at
net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:406)
at
net.hydromatic.avatica.AvaticaStatement.executeQueryInternal(AvaticaStatement.java:350)
at
net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:77)
at
org.apache.kylin.rest.service.QueryService.execute(QueryService.java:355)
at
org.apache.kylin.rest.service.QueryService.executeQuery(QueryService.java:275)
at
org.apache.kylin.rest.service.QueryService.query(QueryService.java:119)
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$$d7452894.query(<generated>)
at
org.apache.kylin.rest.controller.QueryController.doQuery(QueryController.java:205)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:91)
at
org.apache.kylin.rest.controller.QueryController$$FastClassByCGLIB$$fc039d0b.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at
com.ryantenney.metrics.spring.TimedMethodInterceptor.invoke(TimedMethodInterceptor.java:48)
at
com.ryantenney.metrics.spring.TimedMethodInterceptor.invoke(TimedMethodInterceptor.java:34)
at
com.ryantenney.metrics.spring.AbstractMetricMethodInterceptor.invoke(AbstractMetricMethodInterceptor.java:59)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at
org.apache.kylin.rest.controller.QueryController$$EnhancerByCGLIB$$198d1f21.query(<generated>)
at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
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(ServletInvocableHandlerMethod.java:96)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.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
com.codahale.metrics.servlet.AbstractInstrumentedFilter.doFilter(AbstractInstrumentedFilter.java:97)
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:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.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(DefaultLoginPageGeneratingFilter.java:91)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.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:314)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:722)
Caused by: org.apache.kylin.storage.hbase.ScanOutOfLimitException: Scan row
count exceeded threshold: 4000000, please add filter condition to narrow down
backend scan range, like where clause.
at
org.apache.kylin.storage.hbase.SerializedHBaseTupleIterator.hasNext(SerializedHBaseTupleIterator.java:102)
at
org.apache.kylin.query.enumerator.CubeEnumerator.moveNext(CubeEnumerator.java:73)
at Baz$1$1.moveNext(Unknown Source)
at
net.hydromatic.linq4j.EnumerableDefaults.groupBy_(EnumerableDefaults.java:662)
at
net.hydromatic.linq4j.EnumerableDefaults.groupBy(EnumerableDefaults.java:632)
at
net.hydromatic.linq4j.DefaultEnumerable.groupBy(DefaultEnumerable.java:284)
at Baz.bind(Unknown Source)
at
net.hydromatic.optiq.jdbc.OptiqPrepare$PrepareResult.getEnumerable(OptiqPrepare.java:270)
at
net.hydromatic.optiq.jdbc.OptiqPrepare$PrepareResult.enumerator(OptiqPrepare.java:280)
at
net.hydromatic.optiq.jdbc.OptiqPrepare$PrepareResult.createCursor(OptiqPrepare.java:248)
at net.hydromatic.optiq.jdbc.MetaImpl.createCursor(MetaImpl.java:611)
at
net.hydromatic.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:161)
at
net.hydromatic.optiq.jdbc.OptiqResultSet.execute(OptiqResultSet.java:58)
at
net.hydromatic.optiq.jdbc.OptiqResultSet.execute(OptiqResultSet.java:35)
at
net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404)
... 93 more
[http-bio-7070-exec-6]:[2015-05-13
10:34:02,245][ERROR][org.apache.kylin.rest.controller.BasicController.handleError(BasicController.java:52)]
-
org.apache.kylin.rest.exception.InternalErrorException: exception while
executing query: Scan row count exceeded threshold: 4000000, please add filter
condition to narrow down backend scan range, like where clause.
at
org.apache.kylin.rest.controller.QueryController.doQuery(QueryController.java:227)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:91)
at
org.apache.kylin.rest.controller.QueryController$$FastClassByCGLIB$$fc039d0b.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at
com.ryantenney.metrics.spring.TimedMethodInterceptor.invoke(TimedMethodInterceptor.java:48)
at
com.ryantenney.metrics.spring.TimedMethodInterceptor.invoke(TimedMethodInterceptor.java:34)
at
com.ryantenney.metrics.spring.AbstractMetricMethodInterceptor.invoke(AbstractMetricMethodInterceptor.java:59)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at
org.apache.kylin.rest.controller.QueryController$$EnhancerByCGLIB$$198d1f21.query(<generated>)
at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
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(ServletInvocableHandlerMethod.java:96)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.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
com.codahale.metrics.servlet.AbstractInstrumentedFilter.doFilter(AbstractInstrumentedFilter.java:97)
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:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.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(DefaultLoginPageGeneratingFilter.java:91)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.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:314)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:722)[pool-6-thread-1]:[2015-05-13
10:21:14,749][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:117)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 11 others
[http-bio-7070-exec-1]:[2015-05-13
10:22:04,923][INFO][org.apache.kylin.rest.controller.QueryController.doQuery(QueryController.java:189)]
- Using project: Demo
[http-bio-7070-exec-1]:[2015-05-13
10:22:04,925][INFO][org.apache.kylin.rest.controller.QueryController.doQuery(QueryController.java:190)]
- The original query: select col1,col2,....col18,
max(val) as valuess
from facttable
group by col1,col2,....col18
order by col1,col2,....col18
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,013][INFO][org.apache.kylin.query.routing.QueryRouter.selectRealization(QueryRouter.java:45)]
- Find candidates by table DEFAULT.FACTTABLE and project=KTDEMO :
CUBE[name=Cube1]
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,014][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:53)]
- Initial realizations order:
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,014][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:54)]
- [Cube1]
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,014][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:55)]
- Applying rule class
org.apache.kylin.query.routing.RoutingRules.RealizationPriorityRule
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,014][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:59)]
- [Cube1]
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,015][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:60)]
- ===================================================
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,015][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:53)]
- Initial realizations order:
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,015][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:54)]
- [Cube1]
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,015][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:55)]
- Applying rule class
org.apache.kylin.query.routing.RoutingRules.RemoveUncapableRealizationsRule
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,016][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:59)]
- [Cube1]
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,016][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:60)]
- ===================================================
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,016][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:53)]
- Initial realizations order:
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,017][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:54)]
- [Cube1]
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,017][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:55)]
- Applying rule class
org.apache.kylin.query.routing.RoutingRules.SimpleQueryMoreColumnsCubeFirstRule
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,017][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:59)]
- [Cube1]
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,018][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:60)]
- ===================================================
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,018][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:53)]
- Initial realizations order:
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,018][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:54)]
- [Cube1]
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,018][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:55)]
- Applying rule class org.apache.kylin.query.routing.RoutingRules.CubesSortRule
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,019][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:59)]
- [Cube1]
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,019][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:60)]
- ===================================================
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,019][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:53)]
- Initial realizations order:
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,019][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:54)]
- [Cube1]
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,020][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:55)]
- Applying rule class
org.apache.kylin.query.routing.RoutingRules.AdjustForWeeklyMatchedRealization
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,020][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:59)]
- [Cube1]
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,020][INFO][org.apache.kylin.query.routing.RoutingRule.applyRules(RoutingRule.java:60)]
- ===================================================
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,021][INFO][org.apache.kylin.query.routing.QueryRouter.selectRealization(QueryRouter.java:54)]
- The realizations remaining:
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,021][INFO][org.apache.kylin.query.routing.QueryRouter.selectRealization(QueryRouter.java:55)]
- [Cube1]
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,021][INFO][org.apache.kylin.query.routing.QueryRouter.selectRealization(QueryRouter.java:56)]
- The realization being chosen: Cube1
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,087][DEBUG][org.apache.kylin.query.enumerator.CubeEnumerator.queryStorage(CubeEnumerator.java:130)]
- query storage...
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,088][INFO][org.apache.kylin.storage.hbase.CubeStorageEngine.isExactAggregation(CubeStorageEngine.java:184)]
- exactAggregation is true
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,090][INFO][org.apache.kylin.storage.hbase.coprocessor.observer.ObserverEnabler.isCoprocessorBeneficial(ObserverEnabler.java:110)]
- Coprocessor is disabled because exactAggregation is true
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,090][INFO][org.apache.kylin.storage.hbase.CubeSegmentTupleIterator.logScan(CubeSegmentTupleIterator.java:236)]
-
Scan hbase table KYLIN_38F5WB8H5U: cuboid exact match, from 262143 to 262143
Start:
\x00\x00\x00\x00\x00\x03\xFF\xFF\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00
-
\x00\x00\x00\x00\x00\x03\xFF\xFF\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00
Stop:
\x00\x00\x00\x00\x00\x03\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\x00
-
\x00\x00\x00\x00\x00\x03\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\x00
[http-bio-7070-exec-1]:[2015-05-13
10:22:05,093][DEBUG][org.apache.kylin.query.enumerator.CubeEnumerator.queryStorage(CubeEnumerator.java:144)]
- return TupleIterator...
[pool-6-thread-1]:[2015-05-13
10:22:14,741][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:117)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 11 others
[pool-6-thread-1]:[2015-05-13
10:23:14,769][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:117)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 11 others
[http-bio-7070-exec-1]:[2015-05-13
10:23:56,409][DEBUG][org.apache.kylin.storage.hbase.CubeSegmentTupleIterator.closeScanner(CubeSegmentTupleIterator.java:125)]
- Scan
{"timeRange":[0,9223372036854775807],"batch":-1,"startRow":"\\x00\\x00\\x00\\x00\\x00\\x03\\xFF\\xFF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00","stopRow":"\\x00\\x00\\x00\\x00\\x00\\x03\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\xFF\\x00","loadColumnFamiliesOnDemand":null,"totalColumns":1,"cacheBlocks":true,"families":{"F1":["M"]},"maxResultSize":-1,"maxVersions":1,"caching":1024}
[http-bio-7070-exec-1]:[2015-05-13
10:23:59,963][WARN][net.sf.ehcache.pool.sizeof.ObjectGraphWalker.checkMaxDepth(ObjectGraphWalker.java:209)]
- The configured limit of 1,000 object references was reached while attempting
to calculate the size of the object graph. Severe performance degradation could
occur if the sizing operation continues. This can be avoided by setting the
CacheManger or Cache <sizeOfPolicy> elements maxDepthExceededBehavior to
"abort" or adding stop points with @IgnoreSizeOf annotations. If performance
degradation is NOT an issue at the configured limit, raise the limit value
using the CacheManager or Cache <sizeOfPolicy> elements maxDepth attribute. For
more information, see the Ehcache configuration documentation.
[pool-6-thread-1]:[2015-05-13
10:24:14,863][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:117)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 11 others
[http-bio-7070-exec-1]:[2015-05-13
10:24:36,099][INFO][org.apache.kylin.rest.service.QueryService.logQuery(QueryService.java:250)]
-
==========================[QUERY]===============================
SQL: select col1,col2,....col18,
max(val) as valuess
from facttable
group by col1,col2,....col18
order by col1,col2,....col18
User: ADMIN
Success: true
Duration: 151.176
Project: Demo
Realization Names: [Cube1]
Cuboid Ids: [262143]
Total scan count: 1000001
Result row count: 1000000
Accept Partial: true
Is Partial Result: true
Hit Cache: false
Message: null
==========================[QUERY]===============================
