Hi,all
Can anyone help me answer my question?
I can use tableau normally after loading the metadate, but why are there so
many errors in kylin.log when tableau loads metadata?
Thanks,
Dandan
At 2017-07-19 10:11:52, "沈丹丹" <[email protected]> wrote:
But the metadata is only 18M, why does it cost much resources.
And there are many errors in kylin.log when tableau loads the metadata.
2017-07-19 09:34:48,415 INFO [Query d1337b1e-3635-467e-8919-88797bb33965-54]
service.QueryService:338 : Using project: bind_financial_manager
2017-07-19 09:34:48,423 INFO [Query d1337b1e-3635-467e-8919-88797bb33965-54]
service.QueryService:339 : The original query: CREATE LOCAL TEMPORARY TABLE
"XTB_EDEBFDEA_ACCJ_EFFB_ACDE_ADECHDECADE_Connect" ( "COL" INTEGER ) ON COMMIT
PRESERVE ROWS
2017-07-19 09:34:48,423 DEBUG [Query d1337b1e-3635-467e-8919-88797bb33965-54]
service.QueryService:342 : Directly return exception as not supported
2017-07-19 09:34:48,424 ERROR [http-bio-7070-exec-6]
controller.BasicController:44 :
org.apache.kylin.rest.exception.InternalErrorException: Not Supported SQL.
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:343)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69)
at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
...
...
For more details,please open the attachment.
Thank you very much!
在 2017-07-19 09:36:05，"Billy Liu" <[email protected]> 写道：
>The root cause is Tableau sends out “select * ” to Kylin which costs much
>resource.
>
>在 2017年7月18日 下午5:51，沈丹丹 <[email protected]>写道：
>
>> yes， I use the live model.
>>
>>
>>
>>
>>
>>
>>
>>
>> 在 2017-07-18 17:25:48，"Billy Liu" <[email protected]> 写道：
>> >Did you use Tableau Live mode?
>> >
>> >在 2017年7月18日 下午2:59，沈丹丹 <[email protected]>写道：
>> >
>> >>
>> >>
>> >>
>> >> Thank you. But the SQL is automatically generated when tableau loads
>> >> metadata, but it not supported. And I can't control it.
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> 在 2017-07-18 14:45:08，"江昆" <[email protected]> 写道：
>> >> >because the sql parser of kylin is calcite,it is different from sql
>> which
>> >> we offen use...you could use your sql in kylin web
>> application-insight,you
>> >> could try then you know what sql could pass or not...good luck...
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >------------------ 原始邮件 ------------------
>> >> >发件人: "沈丹丹";<[email protected]>;
>> >> >发送时间: 2017年7月18日(星期二) 下午2:39
>> >> >收件人: "dev"<[email protected]>;
>> >> >
>> >> >主题: 技术求助
>> >> >
>> >> >
>> >> >
>> >> >大家好：
>> >> > 我在使用kylin整合tableau的时候遇到一些问题，我不知道如何解决，希望能得到你们的帮助。
>> >> 我使用的是kylin1.6版本，jdk1.7版本的，结合tableau9.0使用，但是在tableau加载kylin元数据的时候每次都会花费1
>> >> 0分钟左右，并且内存狂飙至99%导致电脑会卡住一段时间。但是元数据很小，才18M左右。请问这是为什么？
>> 而且看kylin.log文件，里面会报很多Not
>> >> Supported SQL 错误，这个该怎么解决呢？（ps，附件是tableau加载kylin元数据时kylin.log日志文件）
>> >> > 盼回复！谢谢！
>> >>
>>
2017-07-20 09:43:10,427 INFO [Query 8c7f790b-d142-4d15-83f3-6d4cec274f58-50]
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-20 09:43:10,428 INFO [Query 8c7f790b-d142-4d15-83f3-6d4cec274f58-50]
service.QueryService:339 : The original query: CREATE LOCAL TEMPORARY TABLE
"XTB_FACICADJ_BCBH_EICF_ABJB_FDEAFADADFH_Connect" ( "COL" INTEGER ) ON COMMIT
PRESERVE ROWS
2017-07-20 09:43:10,428 DEBUG [Query 8c7f790b-d142-4d15-83f3-6d4cec274f58-50]
service.QueryService:342 : Directly return exception as not supported
2017-07-20 09:43:10,428 ERROR [http-bio-7070-exec-2]
controller.BasicController:44 :
org.apache.kylin.rest.exception.InternalErrorException: Not Supported SQL.
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:343)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69)
at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.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)
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: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:201)
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:343)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
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:209)
at
com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
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:505)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
2017-07-20 09:43:10,581 INFO [Query b87832a2-b90a-4806-8c53-ddf972d1d520-53]
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-20 09:43:10,581 INFO [Query b87832a2-b90a-4806-8c53-ddf972d1d520-53]
service.QueryService:339 : The original query: DROP TABLE
"XTB_FACICADJ_BCBH_EICF_ABJB_FDEAFADADFH_Connect"
2017-07-20 09:43:10,581 DEBUG [Query b87832a2-b90a-4806-8c53-ddf972d1d520-53]
service.QueryService:342 : Directly return exception as not supported
2017-07-20 09:43:10,581 ERROR [http-bio-7070-exec-5]
controller.BasicController:44 :
org.apache.kylin.rest.exception.InternalErrorException: Not Supported SQL.
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:343)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69)
at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.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)
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: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:201)
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:343)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
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:209)
at
com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
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:505)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
2017-07-20 09:43:10,770 INFO [Query d3c611fc-c531-44b6-ab27-31809dc0d119-51]
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-20 09:43:10,771 INFO [Query d3c611fc-c531-44b6-ab27-31809dc0d119-51]
service.QueryService:339 : The original query: DROP TABLE
"XTC_FACICADJ_BCBH_EICF_ABJB_FDEAFADADFH_Connect"
2017-07-20 09:43:10,771 DEBUG [Query d3c611fc-c531-44b6-ab27-31809dc0d119-51]
service.QueryService:342 : Directly return exception as not supported
2017-07-20 09:43:10,771 ERROR [http-bio-7070-exec-3]
controller.BasicController:44 :
org.apache.kylin.rest.exception.InternalErrorException: Not Supported SQL.
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:343)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69)
at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.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)
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: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:201)
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:343)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
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:209)
at
com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
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:505)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
2017-07-20 09:43:19,614 INFO [Query 8e0b8f32-ce8c-4a88-8247-f9f154164946-58]
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-20 09:43:19,614 INFO [Query 8e0b8f32-ce8c-4a88-8247-f9f154164946-58]
service.QueryService:339 : The original query: CREATE LOCAL TEMPORARY TABLE
"XTB_FGJFEGAB_JIIA_EFIE_IBHA_GGEAHDCEFAB_Connect" ( "COL" INTEGER ) ON COMMIT
PRESERVE ROWS
2017-07-20 09:43:19,614 DEBUG [Query 8e0b8f32-ce8c-4a88-8247-f9f154164946-58]
service.QueryService:342 : Directly return exception as not supported
2017-07-20 09:43:19,614 ERROR [http-bio-7070-exec-7]
controller.BasicController:44 :
org.apache.kylin.rest.exception.InternalErrorException: Not Supported SQL.
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:343)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69)
at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.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)
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: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:201)
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:343)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
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:209)
at
com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
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:505)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
2017-07-20 09:43:19,745 INFO [Query a723eb77-ae38-4602-8ee5-f01d5580e771-54]
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-20 09:43:19,745 INFO [Query a723eb77-ae38-4602-8ee5-f01d5580e771-54]
service.QueryService:339 : The original query: DROP TABLE
"XTB_FGJFEGAB_JIIA_EFIE_IBHA_GGEAHDCEFAB_Connect"
2017-07-20 09:43:19,745 DEBUG [Query a723eb77-ae38-4602-8ee5-f01d5580e771-54]
service.QueryService:342 : Directly return exception as not supported
2017-07-20 09:43:19,746 ERROR [http-bio-7070-exec-6]
controller.BasicController:44 :
org.apache.kylin.rest.exception.InternalErrorException: Not Supported SQL.
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:343)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69)
at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.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)
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: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:201)
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:343)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
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:209)
at
com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
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:505)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
2017-07-20 09:43:19,890 INFO [Query 99f2a842-5300-45b3-b37a-e51a33d877b1-60]
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-20 09:43:19,891 INFO [Query 99f2a842-5300-45b3-b37a-e51a33d877b1-60]
service.QueryService:339 : The original query: DROP TABLE
"XTC_FGJFEGAB_JIIA_EFIE_IBHA_GGEAHDCEFAB_Connect"
2017-07-20 09:43:19,891 DEBUG [Query 99f2a842-5300-45b3-b37a-e51a33d877b1-60]
service.QueryService:342 : Directly return exception as not supported
2017-07-20 09:43:19,891 ERROR [http-bio-7070-exec-9]
controller.BasicController:44 :
org.apache.kylin.rest.exception.InternalErrorException: Not Supported SQL.
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:343)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69)
at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.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)
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: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:201)
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:343)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
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:209)
at
com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
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:505)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
2017-07-20 09:43:22,387 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-20 09:43:22,387 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
service.QueryService:339 : The original query: SELECT * FROM
"TN_QUERY"."T_DM_USER_TAG"
2017-07-20 09:43:23,980 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
routing.QueryRouter:48 : The project manager's reference is
org.apache.kylin.metadata.project.ProjectManager@52a209ec
2017-07-20 09:43:23,980 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
routing.QueryRouter:60 : Find candidates by table TN_QUERY.T_DM_USER_TAG and
project=T_DM_USER_TAG : CUBE[name=t_dm_user_tag_cube]
2017-07-20 09:43:23,980 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
routing.QueryRouter:51 : Applying rule: class
org.apache.kylin.query.routing.rules.RemoveBlackoutRealizationsRule,
realizations before: [t_dm_user_tag_cube(CUBE)], realizations after:
[t_dm_user_tag_cube(CUBE)]
2017-07-20 09:43:23,980 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
routing.QueryRouter:51 : Applying rule: class
org.apache.kylin.query.routing.rules.RemoveUncapableRealizationsRule,
realizations before: [t_dm_user_tag_cube(CUBE)], realizations after:
[t_dm_user_tag_cube(CUBE)]
2017-07-20 09:43:23,981 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
rules.RealizationSortRule:40 : CUBE[name=t_dm_user_tag_cube] priority 1 cost
43700.
2017-07-20 09:43:23,981 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
routing.QueryRouter:51 : Applying rule: class
org.apache.kylin.query.routing.rules.RealizationSortRule, realizations before:
[t_dm_user_tag_cube(CUBE)], realizations after: [t_dm_user_tag_cube(CUBE)]
2017-07-20 09:43:23,981 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
routing.QueryRouter:72 : The realizations remaining: [t_dm_user_tag_cube(CUBE)]
And the final chosen one is the first one
2017-07-20 09:43:23,988 DEBUG [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
enumerator.OLAPEnumerator:100 : query storage...
2017-07-20 09:43:23,988 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
cube.RawQueryLastHacker:41 : No group by and aggregation found in this query,
will hack some result for better look of output...
2017-07-20 09:43:23,989 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
gtrecord.GTCubeStorageQueryBase:105 : Cuboid identified:
cube=t_dm_user_tag_cube, cuboidId=274877906943,
groupsD=[TN_QUERY.T_DM_USER_TAG.USERNAME, TN_QUERY.T_DM_USER_TAG.COMPANY_CODE,
TN_QUERY.T_DM_USER_TAG.INVITE_CNT, TN_QUERY.T_DM_USER_TAG.GENDER,
TN_QUERY.T_DM_USER_TAG.INVEST_GRADE, TN_QUERY.T_DM_USER_TAG.USER_ID,
TN_QUERY.T_DM_USER_TAG.YESDAY_REC, TN_QUERY.T_DM_USER_TAG.COMPANY,
TN_QUERY.T_DM_USER_TAG.WITH_RATE, TN_QUERY.T_DM_USER_TAG.PROVINCE,
TN_QUERY.T_DM_USER_TAG.FIRST_AT_INITIAL, TN_QUERY.T_DM_USER_TAG.WITH_INV_TYPE,
TN_QUERY.T_DM_USER_TAG.IS_WOOL, TN_QUERY.T_DM_USER_TAG.DUE_DAY,
TN_QUERY.T_DM_USER_TAG.INVITE_SOURCE, TN_QUERY.T_DM_USER_TAG.PLATFORM,
TN_QUERY.T_DM_USER_TAG.MAX_INV_AT, TN_QUERY.T_DM_USER_TAG.FIRST_AMOUNT,
TN_QUERY.T_DM_USER_TAG.YESDAY_DUE, TN_QUERY.T_DM_USER_TAG.CLIENT_PUSH,
TN_QUERY.T_DM_USER_TAG.AGEREGION, TN_QUERY.T_DM_USER_TAG.CONSTELLATIONS,
TN_QUERY.T_DM_USER_TAG.COU_BAL_AMOUNT, TN_QUERY.T_DM_USER_TAG.LOYAL,
TN_QUERY.T_DM_USER_TAG.FIRST_AT, TN_QUERY.T_DM_USER_TAG.INV_COMPANY,
TN_QUERY.T_DM_USER_TAG.IS_INVEST, TN_QUERY.T_DM_USER_TAG.MAX_INV_AT_INITIAL,
TN_QUERY.T_DM_USER_TAG.HOLDING_AMOUNT_MAX, TN_QUERY.T_DM_USER_TAG.SOURCE,
TN_QUERY.T_DM_USER_TAG.CITY, TN_QUERY.T_DM_USER_TAG.BAIDU_PUSH,
TN_QUERY.T_DM_USER_TAG.INV_AMOUNT, TN_QUERY.T_DM_USER_TAG.HAVE_INS_COUP,
TN_QUERY.T_DM_USER_TAG.LIFE_CYCLE, TN_QUERY.T_DM_USER_TAG.TIME_PREFER,
TN_QUERY.T_DM_USER_TAG.HOLDING_AMOUNT, TN_QUERY.T_DM_USER_TAG.ACC_AMOUNT],
otherDimsD=[]
2017-07-20 09:43:23,989 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
gtrecord.GTCubeStorageQueryBase:230 : GroupD :[TN_QUERY.T_DM_USER_TAG.USERNAME,
TN_QUERY.T_DM_USER_TAG.COMPANY_CODE, TN_QUERY.T_DM_USER_TAG.INVITE_CNT,
TN_QUERY.T_DM_USER_TAG.GENDER, TN_QUERY.T_DM_USER_TAG.INVEST_GRADE,
TN_QUERY.T_DM_USER_TAG.USER_ID, TN_QUERY.T_DM_USER_TAG.YESDAY_REC,
TN_QUERY.T_DM_USER_TAG.COMPANY, TN_QUERY.T_DM_USER_TAG.WITH_RATE,
TN_QUERY.T_DM_USER_TAG.PROVINCE, TN_QUERY.T_DM_USER_TAG.FIRST_AT_INITIAL,
TN_QUERY.T_DM_USER_TAG.WITH_INV_TYPE, TN_QUERY.T_DM_USER_TAG.IS_WOOL,
TN_QUERY.T_DM_USER_TAG.DUE_DAY, TN_QUERY.T_DM_USER_TAG.INVITE_SOURCE,
TN_QUERY.T_DM_USER_TAG.PLATFORM, TN_QUERY.T_DM_USER_TAG.MAX_INV_AT,
TN_QUERY.T_DM_USER_TAG.FIRST_AMOUNT, TN_QUERY.T_DM_USER_TAG.YESDAY_DUE,
TN_QUERY.T_DM_USER_TAG.CLIENT_PUSH, TN_QUERY.T_DM_USER_TAG.AGEREGION,
TN_QUERY.T_DM_USER_TAG.CONSTELLATIONS, TN_QUERY.T_DM_USER_TAG.COU_BAL_AMOUNT,
TN_QUERY.T_DM_USER_TAG.LOYAL, TN_QUERY.T_DM_USER_TAG.FIRST_AT,
TN_QUERY.T_DM_USER_TAG.INV_COMPANY, TN_QUERY.T_DM_USER_TAG.IS_INVEST,
TN_QUERY.T_DM_USER_TAG.MAX_INV_AT_INITIAL,
TN_QUERY.T_DM_USER_TAG.HOLDING_AMOUNT_MAX, TN_QUERY.T_DM_USER_TAG.SOURCE,
TN_QUERY.T_DM_USER_TAG.CITY, TN_QUERY.T_DM_USER_TAG.BAIDU_PUSH,
TN_QUERY.T_DM_USER_TAG.INV_AMOUNT, TN_QUERY.T_DM_USER_TAG.HAVE_INS_COUP,
TN_QUERY.T_DM_USER_TAG.LIFE_CYCLE, TN_QUERY.T_DM_USER_TAG.TIME_PREFER,
TN_QUERY.T_DM_USER_TAG.HOLDING_AMOUNT, TN_QUERY.T_DM_USER_TAG.ACC_AMOUNT]
2017-07-20 09:43:23,989 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
gtrecord.GTCubeStorageQueryBase:231 : SingleValueD :[]
2017-07-20 09:43:23,989 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
gtrecord.GTCubeStorageQueryBase:232 : Cuboid columns
:[TN_QUERY.T_DM_USER_TAG.USER_ID, TN_QUERY.T_DM_USER_TAG.USERNAME,
TN_QUERY.T_DM_USER_TAG.HOLDING_AMOUNT_MAX, TN_QUERY.T_DM_USER_TAG.MAX_INV_AT,
TN_QUERY.T_DM_USER_TAG.LOYAL, TN_QUERY.T_DM_USER_TAG.LIFE_CYCLE,
TN_QUERY.T_DM_USER_TAG.COU_BAL_AMOUNT, TN_QUERY.T_DM_USER_TAG.HOLDING_AMOUNT,
TN_QUERY.T_DM_USER_TAG.PROVINCE, TN_QUERY.T_DM_USER_TAG.CITY,
TN_QUERY.T_DM_USER_TAG.PLATFORM, TN_QUERY.T_DM_USER_TAG.IS_INVEST,
TN_QUERY.T_DM_USER_TAG.GENDER, TN_QUERY.T_DM_USER_TAG.AGEREGION,
TN_QUERY.T_DM_USER_TAG.MAX_INV_AT_INITIAL, TN_QUERY.T_DM_USER_TAG.IS_WOOL,
TN_QUERY.T_DM_USER_TAG.BAIDU_PUSH, TN_QUERY.T_DM_USER_TAG.CLIENT_PUSH,
TN_QUERY.T_DM_USER_TAG.HAVE_INS_COUP, TN_QUERY.T_DM_USER_TAG.FIRST_AT,
TN_QUERY.T_DM_USER_TAG.FIRST_AT_INITIAL, TN_QUERY.T_DM_USER_TAG.SOURCE,
TN_QUERY.T_DM_USER_TAG.INVITE_SOURCE, TN_QUERY.T_DM_USER_TAG.COMPANY_CODE,
TN_QUERY.T_DM_USER_TAG.FIRST_AMOUNT, TN_QUERY.T_DM_USER_TAG.INV_AMOUNT,
TN_QUERY.T_DM_USER_TAG.INVEST_GRADE, TN_QUERY.T_DM_USER_TAG.ACC_AMOUNT,
TN_QUERY.T_DM_USER_TAG.COMPANY, TN_QUERY.T_DM_USER_TAG.INV_COMPANY,
TN_QUERY.T_DM_USER_TAG.CONSTELLATIONS, TN_QUERY.T_DM_USER_TAG.WITH_INV_TYPE,
TN_QUERY.T_DM_USER_TAG.INVITE_CNT, TN_QUERY.T_DM_USER_TAG.TIME_PREFER,
TN_QUERY.T_DM_USER_TAG.WITH_RATE, TN_QUERY.T_DM_USER_TAG.DUE_DAY,
TN_QUERY.T_DM_USER_TAG.YESDAY_DUE, TN_QUERY.T_DM_USER_TAG.YESDAY_REC]
2017-07-20 09:43:23,990 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
gtrecord.GTCubeStorageQueryBase:238 : Does not need storage aggregation
2017-07-20 09:43:23,990 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
storage.StorageContext:134 : Not enabling limit push down because the
limit(including offset) 1000000 is larger than kylin.query.pushdown.limit.max
10000
2017-07-20 09:43:23,990 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
gtrecord.CubeSegmentScanner:57 : Init CubeSegmentScanner for segment
19700101000000_2922789940817071255
2017-07-20 09:43:23,992 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
dict.DictionaryManager:97 : Dict with resource path
/dict/TN_QUERY.FACT_TABLE_ALL/USER_ID/c9f52eb0-2616-437b-9954-d32051473c77.dict
is removed due to EXPIRED
2017-07-20 09:43:23,993 DEBUG [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
v2.CubeHBaseRPC:297 : hbase.rpc.timeout = 60000 ms, use 54000 ms as timeout for
coprocessor
2017-07-20 09:43:23,995 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
v2.CubeHBaseEndpointRPC:138 : Serialized scanRequestBytes 5978 bytes,
rawScanBytesString 142 bytes
2017-07-20 09:43:23,996 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
v2.CubeHBaseEndpointRPC:140 : The scan 19a06356 for segment
t_dm_user_tag_cube[19700101000000_2922789940817071255] is as below with 1
separate raw scans, shard part of start/end key is set to 0
2017-07-20 09:43:23,997 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
v2.CubeHBaseRPC:278 : Visiting hbase table KYLIN_LQ9O7Q5LFA: cuboid exact
match, from 274877906943 to 274877906943 Start:
\x00\x00\x00\x00\x00\x3F\xFF\xFF\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\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\x00\x00
(\x00\x00\x00\x00\x00?\xFF\xFF\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\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\x00\x00)
Stop:
\x00\x00\x00\x00\x00\x3F\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\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?\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\x00),
No Fuzzy Key
2017-07-20 09:43:23,997 DEBUG [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
v2.CubeHBaseEndpointRPC:145 : Submitting rpc to 1 shards starting from shard 0,
scan range count 1
2017-07-20 09:43:23,998 DEBUG [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
enumerator.OLAPEnumerator:116 : return TupleIterator...
2017-07-20 09:43:28,542 INFO [kylin-coproc--pool5-t90]
v2.CubeHBaseEndpointRPC:199 : <sub-thread for Query
d87060cd-e0a5-460c-b0fa-94564ffe67ec GTScanRequest 19a06356>Endpoint RPC
returned from HTable KYLIN_LQ9O7Q5LFA Shard
\x4B\x59\x4C\x49\x4E\x5F\x4C\x51\x39\x4F\x37\x51\x35\x4C\x46\x41\x2C\x2C\x31\x35\x30\x30\x35\x31\x33\x35\x32\x30\x31\x31\x34\x2E\x30\x31\x63\x64\x62\x64\x34\x33\x65\x63\x66\x63\x33\x33\x66\x66\x61\x33\x65\x66\x66\x32\x39\x66\x30\x30\x36\x37\x35\x62\x33\x63\x2E
on host: hadoop-senior03.ctcf.com.Total scanned row: 1159573. Total
filtered/aggred row: 0. Time elapsed in EP: 4427(ms). Server CPU usage:
0.0017839457714709853, server physical mem left: 8.2975744E9, server swap mem
left:5.368700928E9.Etc message: start latency: 10@4,agg done@3157,compress
done@4426,server stats done@4427,
debugGitTag:ed6982c8b3baaad08b7e4956001339979724d9a7;.Normal Complete: true.
2017-07-20 09:43:29,072 DEBUG [kylin-coproc--pool5-t90]
util.CompressionUtils:67 : Original: 22322168 bytes. Decompressed: 82206724
bytes. Time: 530
2017-07-20 09:43:38,630 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
service.QueryService:578 : Scan count for each storageContext: 1159573,
2017-07-20 09:43:38,631 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
service.QueryService:361 : Stats of SQL response: isException: false, duration:
16244, total scan count 1159573
2017-07-20 09:43:38,703 WARN [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
sizeof.ObjectGraphWalker: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.
2017-07-20 09:44:01,858 INFO [Query d87060cd-e0a5-460c-b0fa-94564ffe67ec-49]
service.QueryService:286 :
==========================[QUERY]===============================
Query Id: d87060cd-e0a5-460c-b0fa-94564ffe67ec
SQL: SELECT * FROM "TN_QUERY"."T_DM_USER_TAG"
User: ADMIN
Success: true
Duration: 16.244
Project: t_dm_user_tag
Realization Names: [t_dm_user_tag_cube]
Cuboid Ids: [274877906943]
Total scan count: 1159573
Result row count: 1159573
Accept Partial: false
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Message: null
==========================[QUERY]===============================
2017-07-20 09:58:29,766 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-20 09:58:29,767 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
service.QueryService:339 : The original query: SELECT SUM(1) AS "COL" FROM
"TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG" HAVING COUNT(1)>0
2017-07-20 09:58:29,767 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
service.QueryService:442 : The corrected query: SELECT COUNT(1) AS "COL" FROM
"TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG"
2017-07-20 09:58:29,787 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
routing.QueryRouter:48 : The project manager's reference is
org.apache.kylin.metadata.project.ProjectManager@52a209ec
2017-07-20 09:58:29,787 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
routing.QueryRouter:60 : Find candidates by table TN_QUERY.T_DM_USER_TAG and
project=T_DM_USER_TAG : CUBE[name=t_dm_user_tag_cube]
2017-07-20 09:58:29,788 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
routing.QueryRouter:51 : Applying rule: class
org.apache.kylin.query.routing.rules.RemoveBlackoutRealizationsRule,
realizations before: [t_dm_user_tag_cube(CUBE)], realizations after:
[t_dm_user_tag_cube(CUBE)]
2017-07-20 09:58:29,788 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
routing.QueryRouter:51 : Applying rule: class
org.apache.kylin.query.routing.rules.RemoveUncapableRealizationsRule,
realizations before: [t_dm_user_tag_cube(CUBE)], realizations after:
[t_dm_user_tag_cube(CUBE)]
2017-07-20 09:58:29,788 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
rules.RealizationSortRule:40 : CUBE[name=t_dm_user_tag_cube] priority 1 cost
437.
2017-07-20 09:58:29,788 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
routing.QueryRouter:51 : Applying rule: class
org.apache.kylin.query.routing.rules.RealizationSortRule, realizations before:
[t_dm_user_tag_cube(CUBE)], realizations after: [t_dm_user_tag_cube(CUBE)]
2017-07-20 09:58:29,788 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
routing.QueryRouter:72 : The realizations remaining: [t_dm_user_tag_cube(CUBE)]
And the final chosen one is the first one
2017-07-20 09:58:29,819 DEBUG [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
enumerator.OLAPEnumerator:100 : query storage...
2017-07-20 09:58:29,819 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
gtrecord.GTCubeStorageQueryBase:105 : Cuboid identified:
cube=t_dm_user_tag_cube, cuboidId=206695301120, groupsD=[], otherDimsD=[]
2017-07-20 09:58:29,820 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
gtrecord.GTCubeStorageQueryBase:230 : GroupD :[]
2017-07-20 09:58:29,820 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
gtrecord.GTCubeStorageQueryBase:231 : SingleValueD :[]
2017-07-20 09:58:29,820 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
gtrecord.GTCubeStorageQueryBase:232 : Cuboid columns
:[TN_QUERY.T_DM_USER_TAG.USER_ID, TN_QUERY.T_DM_USER_TAG.USERNAME,
TN_QUERY.T_DM_USER_TAG.PROVINCE]
2017-07-20 09:58:29,820 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
gtrecord.GTCubeStorageQueryBase:241 : Need storage aggregation
2017-07-20 09:58:29,820 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
storage.StorageContext:134 : Not enabling limit push down because the
limit(including offset) 1000000 is larger than kylin.query.pushdown.limit.max
10000
2017-07-20 09:58:29,821 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
gtrecord.CubeSegmentScanner:57 : Init CubeSegmentScanner for segment
19700101000000_2922789940817071255
2017-07-20 09:58:29,822 DEBUG [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
v2.CubeHBaseRPC:297 : hbase.rpc.timeout = 60000 ms, use 54000 ms as timeout for
coprocessor
2017-07-20 09:58:29,822 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
v2.CubeHBaseEndpointRPC:138 : Serialized scanRequestBytes 650 bytes,
rawScanBytesString 52 bytes
2017-07-20 09:58:29,822 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
v2.CubeHBaseEndpointRPC:140 : The scan 7403e42d for segment
t_dm_user_tag_cube[19700101000000_2922789940817071255] is as below with 1
separate raw scans, shard part of start/end key is set to 0
2017-07-20 09:58:29,823 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
v2.CubeHBaseRPC:278 : Visiting hbase table KYLIN_LQ9O7Q5LFA: cuboid require
post aggregation, from 0 to 206695301120 Start:
\x00\x00\x00\x00\x00\x30\x20\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00
(\x00\x00\x00\x00\x000 \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00) Stop:
\x00\x00\x00\x00\x00\x30\x20\x00\x00\x00\xFF\xFF\xFF\xFF\xFF\xFF\xFF\x00
(\x00\x00\x00\x00\x000 \x00\x00\x00\xFF\xFF\xFF\xFF\xFF\xFF\xFF\x00), No Fuzzy
Key
2017-07-20 09:58:29,823 DEBUG [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
v2.CubeHBaseEndpointRPC:145 : Submitting rpc to 1 shards starting from shard 0,
scan range count 1
2017-07-20 09:58:29,823 DEBUG [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
enumerator.OLAPEnumerator:116 : return TupleIterator...
2017-07-20 09:58:31,521 INFO [kylin-coproc--pool5-t91]
v2.CubeHBaseEndpointRPC:199 : <sub-thread for Query
f9b293c1-32a4-4ad0-b98e-61773d69c15b GTScanRequest 7403e42d>Endpoint RPC
returned from HTable KYLIN_LQ9O7Q5LFA Shard
\x4B\x59\x4C\x49\x4E\x5F\x4C\x51\x39\x4F\x37\x51\x35\x4C\x46\x41\x2C\x2C\x31\x35\x30\x30\x35\x31\x33\x35\x32\x30\x31\x31\x34\x2E\x30\x31\x63\x64\x62\x64\x34\x33\x65\x63\x66\x63\x33\x33\x66\x66\x61\x33\x65\x66\x66\x32\x39\x66\x30\x30\x36\x37\x35\x62\x33\x63\x2E
on host: hadoop-senior03.ctcf.com.Total scanned row: 1159573. Total
filtered/aggred row: 1159572. Time elapsed in EP: 1694(ms). Server CPU usage:
0.0029187343923971474, server physical mem left: 8.305569792E9, server swap mem
left:5.368700928E9.Etc message: start latency: 2@1,agg done@1693,compress
done@1693,server stats done@1694,
debugGitTag:ed6982c8b3baaad08b7e4956001339979724d9a7;.Normal Complete: true.
2017-07-20 09:58:31,522 DEBUG [kylin-coproc--pool5-t91]
util.CompressionUtils:67 : Original: 12 bytes. Decompressed: 4 bytes. Time: 0
2017-07-20 09:58:31,522 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
service.QueryService:578 : Scan count for each storageContext: 1,
2017-07-20 09:58:31,523 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
service.QueryService:361 : Stats of SQL response: isException: false, duration:
1756, total scan count 1
2017-07-20 09:58:31,523 INFO [Query f9b293c1-32a4-4ad0-b98e-61773d69c15b-50]
service.QueryService:286 :
==========================[QUERY]===============================
Query Id: f9b293c1-32a4-4ad0-b98e-61773d69c15b
SQL: SELECT COUNT(1) AS "COL" FROM "TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG"
User: ADMIN
Success: true
Duration: 1.756
Project: t_dm_user_tag
Realization Names: [t_dm_user_tag_cube]
Cuboid Ids: [206695301120]
Total scan count: 1
Result row count: 1
Accept Partial: false
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Message: null
==========================[QUERY]===============================
2017-07-20 09:58:31,704 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-20 09:58:31,705 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
service.QueryService:339 : The original query: SELECT SUM(1) AS "COL" FROM
"TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG" HAVING COUNT(1)>0
2017-07-20 09:58:31,705 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
service.QueryService:442 : The corrected query: SELECT COUNT(1) AS "COL" FROM
"TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG"
2017-07-20 09:58:31,722 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
routing.QueryRouter:48 : The project manager's reference is
org.apache.kylin.metadata.project.ProjectManager@52a209ec
2017-07-20 09:58:31,723 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
routing.QueryRouter:60 : Find candidates by table TN_QUERY.T_DM_USER_TAG and
project=T_DM_USER_TAG : CUBE[name=t_dm_user_tag_cube]
2017-07-20 09:58:31,723 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
routing.QueryRouter:51 : Applying rule: class
org.apache.kylin.query.routing.rules.RemoveBlackoutRealizationsRule,
realizations before: [t_dm_user_tag_cube(CUBE)], realizations after:
[t_dm_user_tag_cube(CUBE)]
2017-07-20 09:58:31,723 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
routing.QueryRouter:51 : Applying rule: class
org.apache.kylin.query.routing.rules.RemoveUncapableRealizationsRule,
realizations before: [t_dm_user_tag_cube(CUBE)], realizations after:
[t_dm_user_tag_cube(CUBE)]
2017-07-20 09:58:31,723 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
rules.RealizationSortRule:40 : CUBE[name=t_dm_user_tag_cube] priority 1 cost
437.
2017-07-20 09:58:31,723 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
routing.QueryRouter:51 : Applying rule: class
org.apache.kylin.query.routing.rules.RealizationSortRule, realizations before:
[t_dm_user_tag_cube(CUBE)], realizations after: [t_dm_user_tag_cube(CUBE)]
2017-07-20 09:58:31,724 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
routing.QueryRouter:72 : The realizations remaining: [t_dm_user_tag_cube(CUBE)]
And the final chosen one is the first one
2017-07-20 09:58:31,746 DEBUG [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
enumerator.OLAPEnumerator:100 : query storage...
2017-07-20 09:58:31,747 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
gtrecord.GTCubeStorageQueryBase:105 : Cuboid identified:
cube=t_dm_user_tag_cube, cuboidId=206695301120, groupsD=[], otherDimsD=[]
2017-07-20 09:58:31,747 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
gtrecord.GTCubeStorageQueryBase:230 : GroupD :[]
2017-07-20 09:58:31,747 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
gtrecord.GTCubeStorageQueryBase:231 : SingleValueD :[]
2017-07-20 09:58:31,747 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
gtrecord.GTCubeStorageQueryBase:232 : Cuboid columns
:[TN_QUERY.T_DM_USER_TAG.USER_ID, TN_QUERY.T_DM_USER_TAG.USERNAME,
TN_QUERY.T_DM_USER_TAG.PROVINCE]
2017-07-20 09:58:31,747 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
gtrecord.GTCubeStorageQueryBase:241 : Need storage aggregation
2017-07-20 09:58:31,748 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
storage.StorageContext:134 : Not enabling limit push down because the
limit(including offset) 1000000 is larger than kylin.query.pushdown.limit.max
10000
2017-07-20 09:58:31,748 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
gtrecord.CubeSegmentScanner:57 : Init CubeSegmentScanner for segment
19700101000000_2922789940817071255
2017-07-20 09:58:31,749 DEBUG [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
v2.CubeHBaseRPC:297 : hbase.rpc.timeout = 60000 ms, use 54000 ms as timeout for
coprocessor
2017-07-20 09:58:31,749 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
v2.CubeHBaseEndpointRPC:138 : Serialized scanRequestBytes 650 bytes,
rawScanBytesString 52 bytes
2017-07-20 09:58:31,750 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
v2.CubeHBaseEndpointRPC:140 : The scan 45e24811 for segment
t_dm_user_tag_cube[19700101000000_2922789940817071255] is as below with 1
separate raw scans, shard part of start/end key is set to 0
2017-07-20 09:58:31,750 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
v2.CubeHBaseRPC:278 : Visiting hbase table KYLIN_LQ9O7Q5LFA: cuboid require
post aggregation, from 0 to 206695301120 Start:
\x00\x00\x00\x00\x00\x30\x20\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00
(\x00\x00\x00\x00\x000 \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00) Stop:
\x00\x00\x00\x00\x00\x30\x20\x00\x00\x00\xFF\xFF\xFF\xFF\xFF\xFF\xFF\x00
(\x00\x00\x00\x00\x000 \x00\x00\x00\xFF\xFF\xFF\xFF\xFF\xFF\xFF\x00), No Fuzzy
Key
2017-07-20 09:58:31,750 DEBUG [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
v2.CubeHBaseEndpointRPC:145 : Submitting rpc to 1 shards starting from shard 0,
scan range count 1
2017-07-20 09:58:31,751 DEBUG [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
enumerator.OLAPEnumerator:116 : return TupleIterator...
2017-07-20 09:58:33,156 INFO [kylin-coproc--pool5-t92]
v2.CubeHBaseEndpointRPC:199 : <sub-thread for Query
1d0067f3-613d-4a7a-b735-b9df42f3eb8b GTScanRequest 45e24811>Endpoint RPC
returned from HTable KYLIN_LQ9O7Q5LFA Shard
\x4B\x59\x4C\x49\x4E\x5F\x4C\x51\x39\x4F\x37\x51\x35\x4C\x46\x41\x2C\x2C\x31\x35\x30\x30\x35\x31\x33\x35\x32\x30\x31\x31\x34\x2E\x30\x31\x63\x64\x62\x64\x34\x33\x65\x63\x66\x63\x33\x33\x66\x66\x61\x33\x65\x66\x66\x32\x39\x66\x30\x30\x36\x37\x35\x62\x33\x63\x2E
on host: hadoop-senior03.ctcf.com.Total scanned row: 1159573. Total
filtered/aggred row: 1159572. Time elapsed in EP: 1403(ms). Server CPU usage:
0.11153846153846154, server physical mem left: 8.305410048E9, server swap mem
left:5.368700928E9.Etc message: start latency: 0@1,agg done@1402,compress
done@1402,server stats done@1402,
debugGitTag:ed6982c8b3baaad08b7e4956001339979724d9a7;.Normal Complete: true.
2017-07-20 09:58:33,157 DEBUG [kylin-coproc--pool5-t92]
util.CompressionUtils:67 : Original: 12 bytes. Decompressed: 4 bytes. Time: 1
2017-07-20 09:58:33,157 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
service.QueryService:578 : Scan count for each storageContext: 1,
2017-07-20 09:58:33,157 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
service.QueryService:361 : Stats of SQL response: isException: false, duration:
1452, total scan count 1
2017-07-20 09:58:33,158 INFO [Query 1d0067f3-613d-4a7a-b735-b9df42f3eb8b-50]
service.QueryService:286 :
==========================[QUERY]===============================
Query Id: 1d0067f3-613d-4a7a-b735-b9df42f3eb8b
SQL: SELECT COUNT(1) AS "COL" FROM "TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG"
User: ADMIN
Success: true
Duration: 1.452
Project: t_dm_user_tag
Realization Names: [t_dm_user_tag_cube]
Cuboid Ids: [206695301120]
Total scan count: 1
Result row count: 1
Accept Partial: false
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Message: null
==========================[QUERY]===============================
