技术求助

沈丹丹 Mon, 17 Jul 2017 23:45:55 -0700

大家好：
        
我在使用kylin整合tableau的时候遇到一些问题，我不知道如何解决，希望能得到你们的帮助。我使用的是kylin1.6版本，jdk1.7版本的，结合tableau9.0使用，但是在tableau加载kylin元数据的时候每次都会花费10分钟左右，并且内存狂飙至99%导致电脑会卡住一段时间。但是元数据很小，才18M左右。请问这是为什么？而且看kylin.log文件，里面会报很多Not
 Supported SQL 错误，这个该怎么解决呢？（ps，附件是tableau加载kylin元数据时kylin.log日志文件）
        盼回复！谢谢！

2017-07-18 13:53:52,813 INFO  [Query 600247da-40ec-4f39-81d3-fe224f00110b-52] 
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-18 13:53:52,813 INFO  [Query 600247da-40ec-4f39-81d3-fe224f00110b-52] 
service.QueryService:339 : The original query:  CREATE LOCAL TEMPORARY TABLE 
"XTB_BGAFAAFJ_FEAD_EHCC_BBGA_DAACEBDGECE_Connect" (  "COL" INTEGER  ) ON COMMIT 
PRESERVE ROWS
2017-07-18 13:53:52,814 DEBUG [Query 600247da-40ec-4f39-81d3-fe224f00110b-52] 
service.QueryService:342 : Directly return exception as not supported
2017-07-18 13:53:52,814 ERROR [http-bio-7070-exec-4] 
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-18 13:53:52,932 INFO  [Query 168976b8-b3c8-4919-b8e9-0d99241c2630-50] 
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-18 13:53:52,933 INFO  [Query 168976b8-b3c8-4919-b8e9-0d99241c2630-50] 
service.QueryService:339 : The original query:  DROP TABLE 
"XTB_BGAFAAFJ_FEAD_EHCC_BBGA_DAACEBDGECE_Connect"
2017-07-18 13:53:52,933 DEBUG [Query 168976b8-b3c8-4919-b8e9-0d99241c2630-50] 
service.QueryService:342 : Directly return exception as not supported
2017-07-18 13:53:52,933 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: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-18 13:53:53,109 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-18 13:53:53,109 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
service.QueryService:339 : The original query:  SELECT * FROM 
"TN_QUERY"."T_DM_USER_TAG"
2017-07-18 13:53:53,131 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
routing.QueryRouter:48 : The project manager's reference is 
org.apache.kylin.metadata.project.ProjectManager@52a209ec
2017-07-18 13:53:53,131 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
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-18 13:53:53,131 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
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-18 13:53:53,131 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
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-18 13:53:53,132 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
rules.RealizationSortRule:40 : CUBE[name=t_dm_user_tag_cube] priority 1 cost 
43700. 
2017-07-18 13:53:53,132 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
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-18 13:53:53,132 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
routing.QueryRouter:72 : The realizations remaining: [t_dm_user_tag_cube(CUBE)] 
And the final chosen one is the first one
2017-07-18 13:53:53,138 DEBUG [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
enumerator.OLAPEnumerator:100 : query storage...
2017-07-18 13:53:53,138 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
cube.RawQueryLastHacker:41 : No group by and aggregation found in this query, 
will hack some result for better look of output...
2017-07-18 13:53:53,139 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
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-18 13:53:53,139 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
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-18 13:53:53,139 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
gtrecord.GTCubeStorageQueryBase:231 : SingleValueD :[]
2017-07-18 13:53:53,139 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
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-18 13:53:53,139 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
gtrecord.GTCubeStorageQueryBase:238 : Does not need storage aggregation
2017-07-18 13:53:53,140 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
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-18 13:53:53,140 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
gtrecord.CubeSegmentScanner:57 : Init CubeSegmentScanner for segment 
19700101000000_2922789940817071255
2017-07-18 13:53:53,142 DEBUG [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
v2.CubeHBaseRPC:297 : hbase.rpc.timeout = 60000 ms, use 54000 ms as timeout for 
coprocessor
2017-07-18 13:53:53,144 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
v2.CubeHBaseEndpointRPC:138 : Serialized scanRequestBytes 5978 bytes, 
rawScanBytesString 142 bytes
2017-07-18 13:53:53,144 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
v2.CubeHBaseEndpointRPC:140 : The scan 38b0d923 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-18 13:53:53,145 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
v2.CubeHBaseRPC:278 : Visiting hbase table KYLIN_7K0TGUP00N: 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-18 13:53:53,145 DEBUG [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
v2.CubeHBaseEndpointRPC:145 : Submitting rpc to 1 shards starting from shard 0, 
scan range count 1
2017-07-18 13:53:53,146 DEBUG [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
enumerator.OLAPEnumerator:116 : return TupleIterator...
2017-07-18 13:53:57,122 INFO  [kylin-coproc--pool5-t55] 
v2.CubeHBaseEndpointRPC:199 : <sub-thread for Query 
f92d185d-66dc-48e3-a2b9-e821c8895b0b GTScanRequest 38b0d923>Endpoint RPC 
returned from HTable KYLIN_7K0TGUP00N Shard 
\x4B\x59\x4C\x49\x4E\x5F\x37\x4B\x30\x54\x47\x55\x50\x30\x30\x4E\x2C\x2C\x31\x34\x39\x39\x36\x36\x37\x33\x38\x34\x39\x39\x31\x2E\x63\x33\x63\x64\x34\x34\x66\x34\x36\x64\x31\x34\x61\x34\x36\x34\x66\x61\x33\x31\x33\x30\x35\x30\x65\x66\x38\x34\x61\x35\x31\x61\x2E
 on host: hadoop-senior03.ctcf.com.Total scanned row: 1151438. Total 
filtered/aggred row: 0. Time elapsed in EP: 3857(ms). Server CPU usage: 
0.10253920058345055, server physical mem left: 1.2770152448E10, server swap mem 
left:5.368700928E9.Etc message: start latency: 7@3,agg done@2682,compress 
done@3856,server stats done@3857, 
debugGitTag:ed6982c8b3baaad08b7e4956001339979724d9a7;.Normal Complete: true.
2017-07-18 13:53:57,659 DEBUG [kylin-coproc--pool5-t55] 
util.CompressionUtils:67 : Original: 22198859 bytes. Decompressed: 81627006 
bytes. Time: 536
2017-07-18 13:54:05,160 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
service.QueryService:578 : Scan count for each storageContext: 1151438,
2017-07-18 13:54:05,161 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
service.QueryService:361 : Stats of SQL response: isException: false, duration: 
12051, total scan count 1151438
2017-07-18 13:54:05,230 WARN  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
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-18 13:54:26,075 INFO  [Query f92d185d-66dc-48e3-a2b9-e821c8895b0b-58] 
service.QueryService:286 : 
==========================[QUERY]===============================
Query Id: f92d185d-66dc-48e3-a2b9-e821c8895b0b
SQL: SELECT * FROM "TN_QUERY"."T_DM_USER_TAG"
User: ADMIN
Success: true
Duration: 12.051
Project: t_dm_user_tag
Realization Names: [t_dm_user_tag_cube]
Cuboid Ids: [274877906943]
Total scan count: 1151438
Result row count: 1151438
Accept Partial: false
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Message: null
==========================[QUERY]===============================

2017-07-18 14:02:20,868 INFO  [Query 15746b12-9c5d-420f-a658-b20a7ed6c92d-61] 
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-18 14:02:20,868 INFO  [Query 15746b12-9c5d-420f-a658-b20a7ed6c92d-61] 
service.QueryService:339 : The original query:  SELECT 
"T_DM_USER_TAG"."CLIENT_PUSH" AS "COL" FROM "TN_QUERY"."T_DM_USER_TAG" 
"T_DM_USER_TAG" GROUP BY 1
2017-07-18 14:02:20,880 ERROR [Query 15746b12-9c5d-420f-a658-b20a7ed6c92d-61] 
runtime.CalciteException:59 : 
org.apache.calcite.sql.validate.SqlValidatorException: Expression 
'T_DM_USER_TAG.CLIENT_PUSH' is not being grouped
2017-07-18 14:02:20,880 ERROR [Query 15746b12-9c5d-420f-a658-b20a7ed6c92d-61] 
runtime.CalciteException:61 : 
org.apache.calcite.runtime.CalciteContextException: From line 1, column 8 to 
line 1, column 36: Expression 'T_DM_USER_TAG.CLIENT_PUSH' is not being grouped
2017-07-18 14:02:20,880 ERROR [Query 15746b12-9c5d-420f-a658-b20a7ed6c92d-61] 
service.QueryService:374 : Exception when execute sql
java.sql.SQLException: Error while executing SQL "SELECT 
"T_DM_USER_TAG"."CLIENT_PUSH" AS "COL" FROM "TN_QUERY"."T_DM_USER_TAG" 
"T_DM_USER_TAG" GROUP BY 1": From line 1, column 8 to line 1, column 36: 
Expression 'T_DM_USER_TAG.CLIENT_PUSH' is not being grouped
        at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
        at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
        at 
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:147)
        at 
org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:208)
        at 
org.apache.kylin.rest.service.QueryService.execute(QueryService.java:540)
        at 
org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:454)
        at 
org.apache.kylin.rest.service.QueryService.query(QueryService.java:151)
        at 
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:356)
        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)
Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, 
column 8 to line 1, column 36: Expression 'T_DM_USER_TAG.CLIENT_PUSH' is not 
being grouped
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at 
org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:405)
        at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:800)
        at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:785)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3989)
        at org.apache.calcite.sql.validate.AggChecker.visit(AggChecker.java:110)
        at org.apache.calcite.sql.validate.AggChecker.visit(AggChecker.java:39)
        at org.apache.calcite.sql.SqlIdentifier.accept(SqlIdentifier.java:308)
        at 
org.apache.calcite.sql.util.SqlBasicVisitor$ArgHandlerImpl.visitChild(SqlBasicVisitor.java:119)
        at 
org.apache.calcite.sql.SqlAsOperator.acceptCall(SqlAsOperator.java:121)
        at org.apache.calcite.sql.validate.AggChecker.visit(AggChecker.java:175)
        at org.apache.calcite.sql.validate.AggChecker.visit(AggChecker.java:39)
        at org.apache.calcite.sql.SqlCall.accept(SqlCall.java:135)
        at 
org.apache.calcite.sql.validate.AggregatingSelectScope.checkAggregateExpr(AggregatingSelectScope.java:232)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelectList(SqlValidatorImpl.java:3502)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3000)
        at 
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
        at 
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:864)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:845)
        at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:208)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:820)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:536)
        at 
org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:533)
        at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:224)
        at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:193)
        at 
org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:724)
        at 
org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:591)
        at 
org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:561)
        at 
org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:215)
        at 
org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:594)
        at 
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:613)
        at 
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:139)
        ... 76 more
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Expression 
'T_DM_USER_TAG.CLIENT_PUSH' is not being grouped
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at 
org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:405)
        at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:514)
        ... 107 more
2017-07-18 14:02:20,882 INFO  [Query 15746b12-9c5d-420f-a658-b20a7ed6c92d-61] 
service.QueryService:286 : 
==========================[QUERY]===============================
Query Id: 15746b12-9c5d-420f-a658-b20a7ed6c92d
SQL: SELECT "T_DM_USER_TAG"."CLIENT_PUSH" AS "COL" FROM 
"TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG" GROUP BY 1
User: ADMIN
Success: false
Duration: 0.0
Project: t_dm_user_tag
Realization Names: []
Cuboid Ids: []
Total scan count: 0
Result row count: 0
Accept Partial: false
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Message: Error while executing SQL "SELECT "T_DM_USER_TAG"."CLIENT_PUSH" AS 
"COL" FROM "TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG" GROUP BY 1": From line 1, 
column 8 to line 1, column 36: Expression 'T_DM_USER_TAG.CLIENT_PUSH' is not 
being grouped
==========================[QUERY]===============================

2017-07-18 14:02:20,882 ERROR [http-bio-7070-exec-10] 
controller.BasicController:44 : 
org.apache.kylin.rest.exception.InternalErrorException: Error while executing 
SQL "SELECT "T_DM_USER_TAG"."CLIENT_PUSH" AS "COL" FROM 
"TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG" GROUP BY 1": From line 1, column 8 
to line 1, column 36: Expression 'T_DM_USER_TAG.CLIENT_PUSH' is not being 
grouped
        at 
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:391)
        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-18 14:02:22,108 INFO  [Query 42abadc0-9908-43e1-ab6e-37341ba264e5-53] 
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-18 14:02:22,109 INFO  [Query 42abadc0-9908-43e1-ab6e-37341ba264e5-53] 
service.QueryService:339 : The original query:  SELECT 
"T_DM_USER_TAG"."CLIENT_PUSH" AS "COL" FROM "TN_QUERY"."T_DM_USER_TAG" 
"T_DM_USER_TAG" GROUP BY "COL"
2017-07-18 14:02:22,120 ERROR [Query 42abadc0-9908-43e1-ab6e-37341ba264e5-53] 
runtime.CalciteException:59 : 
org.apache.calcite.sql.validate.SqlValidatorException: Column 'COL' not found 
in any table
2017-07-18 14:02:22,120 ERROR [Query 42abadc0-9908-43e1-ab6e-37341ba264e5-53] 
runtime.CalciteException:61 : 
org.apache.calcite.runtime.CalciteContextException: From line 1, column 104 to 
line 1, column 108: Column 'COL' not found in any table
2017-07-18 14:02:22,120 ERROR [Query 42abadc0-9908-43e1-ab6e-37341ba264e5-53] 
service.QueryService:374 : Exception when execute sql
java.sql.SQLException: Error while executing SQL "SELECT 
"T_DM_USER_TAG"."CLIENT_PUSH" AS "COL" FROM "TN_QUERY"."T_DM_USER_TAG" 
"T_DM_USER_TAG" GROUP BY "COL"": From line 1, column 104 to line 1, column 108: 
Column 'COL' not found in any table
        at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
        at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
        at 
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:147)
        at 
org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:208)
        at 
org.apache.kylin.rest.service.QueryService.execute(QueryService.java:540)
        at 
org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:454)
        at 
org.apache.kylin.rest.service.QueryService.query(QueryService.java:151)
        at 
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:356)
        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)
Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, 
column 104 to line 1, column 108: Column 'COL' not found in any table
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at 
org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:405)
        at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:800)
        at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:785)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3989)
        at 
org.apache.calcite.sql.validate.EmptyScope.findQualifyingTableName(EmptyScope.java:108)
        at 
org.apache.calcite.sql.validate.DelegatingScope.findQualifyingTableName(DelegatingScope.java:113)
        at 
org.apache.calcite.sql.validate.ListScope.findQualifyingTableName(ListScope.java:150)
        at 
org.apache.calcite.sql.validate.DelegatingScope.fullyQualify(DelegatingScope.java:156)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl$Expander.visit(SqlValidatorImpl.java:4485)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl$Expander.visit(SqlValidatorImpl.java:4465)
        at org.apache.calcite.sql.SqlIdentifier.accept(SqlIdentifier.java:308)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.expand(SqlValidatorImpl.java:4163)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateGroupClause(SqlValidatorImpl.java:3342)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2992)
        at 
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
        at 
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:864)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:845)
        at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:208)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:820)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:536)
        at 
org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:533)
        at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:224)
        at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:193)
        at 
org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:724)
        at 
org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:591)
        at 
org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:561)
        at 
org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:215)
        at 
org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:594)
        at 
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:613)
        at 
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:139)
        ... 76 more
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Column 'COL' 
not found in any table
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at 
org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:405)
        at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:514)
        ... 106 more
2017-07-18 14:02:22,122 INFO  [Query 42abadc0-9908-43e1-ab6e-37341ba264e5-53] 
service.QueryService:286 : 
==========================[QUERY]===============================
Query Id: 42abadc0-9908-43e1-ab6e-37341ba264e5
SQL: SELECT "T_DM_USER_TAG"."CLIENT_PUSH" AS "COL" FROM 
"TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG" GROUP BY "COL"
User: ADMIN
Success: false
Duration: 0.0
Project: t_dm_user_tag
Realization Names: []
Cuboid Ids: []
Total scan count: 0
Result row count: 0
Accept Partial: false
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Message: Error while executing SQL "SELECT "T_DM_USER_TAG"."CLIENT_PUSH" AS 
"COL" FROM "TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG" GROUP BY "COL"": From 
line 1, column 104 to line 1, column 108: Column 'COL' not found in any table
==========================[QUERY]===============================

2017-07-18 14:02:22,122 ERROR [http-bio-7070-exec-5] 
controller.BasicController:44 : 
org.apache.kylin.rest.exception.InternalErrorException: Error while executing 
SQL "SELECT "T_DM_USER_TAG"."CLIENT_PUSH" AS "COL" FROM 
"TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG" GROUP BY "COL"": From line 1, column 
104 to line 1, column 108: Column 'COL' not found in any table
        at 
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:391)
        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-18 14:02:22,376 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-18 14:02:22,377 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
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-18 14:02:22,377 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
service.QueryService:442 : The corrected query: SELECT COUNT(1) AS "COL" FROM 
"TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG" 
2017-07-18 14:02:22,397 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
routing.QueryRouter:48 : The project manager's reference is 
org.apache.kylin.metadata.project.ProjectManager@52a209ec
2017-07-18 14:02:22,398 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
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-18 14:02:22,398 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
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-18 14:02:22,398 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
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-18 14:02:22,398 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
rules.RealizationSortRule:40 : CUBE[name=t_dm_user_tag_cube] priority 1 cost 
437. 
2017-07-18 14:02:22,399 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
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-18 14:02:22,399 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
routing.QueryRouter:72 : The realizations remaining: [t_dm_user_tag_cube(CUBE)] 
And the final chosen one is the first one
2017-07-18 14:02:22,424 DEBUG [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
enumerator.OLAPEnumerator:100 : query storage...
2017-07-18 14:02:22,424 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
gtrecord.GTCubeStorageQueryBase:105 : Cuboid identified: 
cube=t_dm_user_tag_cube, cuboidId=206695301120, groupsD=[], otherDimsD=[]
2017-07-18 14:02:22,425 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
gtrecord.GTCubeStorageQueryBase:230 : GroupD :[]
2017-07-18 14:02:22,425 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
gtrecord.GTCubeStorageQueryBase:231 : SingleValueD :[]
2017-07-18 14:02:22,425 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
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-18 14:02:22,425 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
gtrecord.GTCubeStorageQueryBase:241 : Need storage aggregation
2017-07-18 14:02:22,425 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
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-18 14:02:22,426 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
gtrecord.CubeSegmentScanner:57 : Init CubeSegmentScanner for segment 
19700101000000_2922789940817071255
2017-07-18 14:02:22,427 DEBUG [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
v2.CubeHBaseRPC:297 : hbase.rpc.timeout = 60000 ms, use 54000 ms as timeout for 
coprocessor
2017-07-18 14:02:22,427 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
v2.CubeHBaseEndpointRPC:138 : Serialized scanRequestBytes 650 bytes, 
rawScanBytesString 52 bytes
2017-07-18 14:02:22,427 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
v2.CubeHBaseEndpointRPC:140 : The scan 1f2f839b 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-18 14:02:22,428 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
v2.CubeHBaseRPC:278 : Visiting hbase table KYLIN_7K0TGUP00N: 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-18 14:02:22,428 DEBUG [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
v2.CubeHBaseEndpointRPC:145 : Submitting rpc to 1 shards starting from shard 0, 
scan range count 1
2017-07-18 14:02:22,428 DEBUG [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
enumerator.OLAPEnumerator:116 : return TupleIterator...
2017-07-18 14:02:25,470 INFO  [kylin-coproc--pool5-t56] 
v2.CubeHBaseEndpointRPC:199 : <sub-thread for Query 
b187dc6e-6803-4648-99f5-37b6b112559f GTScanRequest 1f2f839b>Endpoint RPC 
returned from HTable KYLIN_7K0TGUP00N Shard 
\x4B\x59\x4C\x49\x4E\x5F\x37\x4B\x30\x54\x47\x55\x50\x30\x30\x4E\x2C\x2C\x31\x34\x39\x39\x36\x36\x37\x33\x38\x34\x39\x39\x31\x2E\x63\x33\x63\x64\x34\x34\x66\x34\x36\x64\x31\x34\x61\x34\x36\x34\x66\x61\x33\x31\x33\x30\x35\x30\x65\x66\x38\x34\x61\x35\x31\x61\x2E
 on host: hadoop-senior03.ctcf.com.Total scanned row: 1151438. Total 
filtered/aggred row: 1151437. Time elapsed in EP: 1458(ms). Server CPU usage: 
0.10130972527052957, server physical mem left: 1.276850176E10, server swap mem 
left:5.368700928E9.Etc message: start latency: 1585@1,agg done@1457,compress 
done@1457,server stats done@1458, 
debugGitTag:ed6982c8b3baaad08b7e4956001339979724d9a7;.Normal Complete: true.
2017-07-18 14:02:25,470 DEBUG [kylin-coproc--pool5-t56] 
util.CompressionUtils:67 : Original: 12 bytes. Decompressed: 4 bytes. Time: 0
2017-07-18 14:02:25,470 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
service.QueryService:578 : Scan count for each storageContext: 1,
2017-07-18 14:02:25,471 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
service.QueryService:361 : Stats of SQL response: isException: false, duration: 
3094, total scan count 1
2017-07-18 14:02:25,472 INFO  [Query b187dc6e-6803-4648-99f5-37b6b112559f-59] 
service.QueryService:286 : 
==========================[QUERY]===============================
Query Id: b187dc6e-6803-4648-99f5-37b6b112559f
SQL: SELECT COUNT(1) AS "COL" FROM "TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG" 
User: ADMIN
Success: true
Duration: 3.094
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-18 14:02:25,587 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-18 14:02:25,587 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
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-18 14:02:25,587 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
service.QueryService:442 : The corrected query: SELECT COUNT(1) AS "COL" FROM 
"TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG" 
2017-07-18 14:02:25,607 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
routing.QueryRouter:48 : The project manager's reference is 
org.apache.kylin.metadata.project.ProjectManager@52a209ec
2017-07-18 14:02:25,607 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
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-18 14:02:25,607 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
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-18 14:02:25,607 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
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-18 14:02:25,607 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
rules.RealizationSortRule:40 : CUBE[name=t_dm_user_tag_cube] priority 1 cost 
437. 
2017-07-18 14:02:25,608 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
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-18 14:02:25,608 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
routing.QueryRouter:72 : The realizations remaining: [t_dm_user_tag_cube(CUBE)] 
And the final chosen one is the first one
2017-07-18 14:02:25,631 DEBUG [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
enumerator.OLAPEnumerator:100 : query storage...
2017-07-18 14:02:25,631 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
gtrecord.GTCubeStorageQueryBase:105 : Cuboid identified: 
cube=t_dm_user_tag_cube, cuboidId=206695301120, groupsD=[], otherDimsD=[]
2017-07-18 14:02:25,631 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
gtrecord.GTCubeStorageQueryBase:230 : GroupD :[]
2017-07-18 14:02:25,632 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
gtrecord.GTCubeStorageQueryBase:231 : SingleValueD :[]
2017-07-18 14:02:25,632 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
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-18 14:02:25,632 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
gtrecord.GTCubeStorageQueryBase:241 : Need storage aggregation
2017-07-18 14:02:25,632 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
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-18 14:02:25,632 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
gtrecord.CubeSegmentScanner:57 : Init CubeSegmentScanner for segment 
19700101000000_2922789940817071255
2017-07-18 14:02:25,633 DEBUG [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
v2.CubeHBaseRPC:297 : hbase.rpc.timeout = 60000 ms, use 54000 ms as timeout for 
coprocessor
2017-07-18 14:02:25,634 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
v2.CubeHBaseEndpointRPC:138 : Serialized scanRequestBytes 650 bytes, 
rawScanBytesString 52 bytes
2017-07-18 14:02:25,634 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
v2.CubeHBaseEndpointRPC:140 : The scan d8623d4 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-18 14:02:25,634 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
v2.CubeHBaseRPC:278 : Visiting hbase table KYLIN_7K0TGUP00N: 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-18 14:02:25,635 DEBUG [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
v2.CubeHBaseEndpointRPC:145 : Submitting rpc to 1 shards starting from shard 0, 
scan range count 1
2017-07-18 14:02:25,635 DEBUG [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
enumerator.OLAPEnumerator:116 : return TupleIterator...
2017-07-18 14:02:26,972 INFO  [kylin-coproc--pool5-t57] 
v2.CubeHBaseEndpointRPC:199 : <sub-thread for Query 
fb1c9660-e9b3-4bd9-9390-e248e1158be7 GTScanRequest d8623d4>Endpoint RPC 
returned from HTable KYLIN_7K0TGUP00N Shard 
\x4B\x59\x4C\x49\x4E\x5F\x37\x4B\x30\x54\x47\x55\x50\x30\x30\x4E\x2C\x2C\x31\x34\x39\x39\x36\x36\x37\x33\x38\x34\x39\x39\x31\x2E\x63\x33\x63\x64\x34\x34\x66\x34\x36\x64\x31\x34\x61\x34\x36\x34\x66\x61\x33\x31\x33\x30\x35\x30\x65\x66\x38\x34\x61\x35\x31\x61\x2E
 on host: hadoop-senior03.ctcf.com.Total scanned row: 1151438. Total 
filtered/aggred row: 1151437. Time elapsed in EP: 1333(ms). Server CPU usage: 
0.16110183639398998, server physical mem left: 1.2768342016E10, server swap mem 
left:5.368700928E9.Etc message: start latency: 5@0,agg done@1332,compress 
done@1332,server stats done@1333, 
debugGitTag:ed6982c8b3baaad08b7e4956001339979724d9a7;.Normal Complete: true.
2017-07-18 14:02:26,972 DEBUG [kylin-coproc--pool5-t57] 
util.CompressionUtils:67 : Original: 12 bytes. Decompressed: 4 bytes. Time: 0
2017-07-18 14:02:26,973 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
service.QueryService:578 : Scan count for each storageContext: 1,
2017-07-18 14:02:26,973 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
service.QueryService:361 : Stats of SQL response: isException: false, duration: 
1386, total scan count 1
2017-07-18 14:02:26,973 INFO  [Query fb1c9660-e9b3-4bd9-9390-e248e1158be7-59] 
service.QueryService:286 : 
==========================[QUERY]===============================
Query Id: fb1c9660-e9b3-4bd9-9390-e248e1158be7
SQL: SELECT COUNT(1) AS "COL" FROM "TN_QUERY"."T_DM_USER_TAG" "T_DM_USER_TAG" 
User: ADMIN
Success: true
Duration: 1.386
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-18 14:02:27,245 INFO  [Query e4ab26b8-cf33-4156-84a8-6fa0831fdf11-59] 
service.QueryService:338 : Using project: t_dm_user_tag
2017-07-18 14:02:27,245 INFO  [Query e4ab26b8-cf33-4156-84a8-6fa0831fdf11-59] 
service.QueryService:339 : The original query:  DROP TABLE 
"XTC_BGAFAAFJ_FEAD_EHCC_BBGA_DAACEBDGECE_Connect"
2017-07-18 14:02:27,245 DEBUG [Query e4ab26b8-cf33-4156-84a8-6fa0831fdf11-59] 
service.QueryService:342 : Directly return exception as not supported
2017-07-18 14:02:27,246 ERROR [http-bio-7070-exec-8] 
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)

技术求助

Reply via email to