From user-return-3599-archive-asf-public=cust-asf.ponee.io@kylin.apache.org Sat Oct 13 14:49:36 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 81C2218067A for ; Sat, 13 Oct 2018 14:49:35 +0200 (CEST) Received: (qmail 58235 invoked by uid 500); 13 Oct 2018 12:49:34 -0000 Mailing-List: contact user-help@kylin.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@kylin.apache.org Delivered-To: mailing list user@kylin.apache.org Received: (qmail 58221 invoked by uid 99); 13 Oct 2018 12:49:34 -0000 Received: from mail-relay.apache.org (HELO mailrelay1-lw-us.apache.org) (207.244.88.152) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 13 Oct 2018 12:49:34 +0000 Received: from mail-ot1-f49.google.com (mail-ot1-f49.google.com [209.85.210.49]) by mailrelay1-lw-us.apache.org (ASF Mail Server at mailrelay1-lw-us.apache.org) with ESMTPSA id 60A2E146E for ; Sat, 13 Oct 2018 12:49:33 +0000 (UTC) Received: by mail-ot1-f49.google.com with SMTP id c23so13083653otl.9 for ; Sat, 13 Oct 2018 05:49:33 -0700 (PDT) X-Gm-Message-State: ABuFfoj8n1tWTr3ioDqYpYOEV76rsNxeZnt/LF3eqzs4ER58XKRuQ9YV Ddu/NqglT+CzWcX9gxODacZN2eCWE40cKb9942Y= X-Google-Smtp-Source: ACcGV63CcXEamJW2bZXNf60gDp7GE+Yd+J66QCNzDiWpnV98ah2SsrDvqc2VY3dCrKeN7g+4U74zCeFZ6r8NtR31EoI= X-Received: by 2002:a9d:724f:: with SMTP id a15mr5894157otk.320.1539434972669; Sat, 13 Oct 2018 05:49:32 -0700 (PDT) MIME-Version: 1.0 References: <5bc0651e.1c69fb81.b9e8b.0565SMTPIN_ADDED_BROKEN@mx.google.com> In-Reply-To: <5bc0651e.1c69fb81.b9e8b.0565SMTPIN_ADDED_BROKEN@mx.google.com> From: Billy Liu Date: Sat, 13 Oct 2018 20:49:21 +0800 X-Gmail-Original-Message-ID: Message-ID: Subject: =?UTF-8?B?UmU6IOWkmuihqOWFs+iBlOW4puWPguafpeivouW8guW4uA==?= To: user Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable The error trace is not complete, please trace more. In most cases, there would be another exception around the context. With Warm regards Billy Liu zhangpeng@bcpeople.com =E4=BA=8E2018=E5=B9=B410=E6= =9C=8812=E6=97=A5=E5=91=A8=E4=BA=94 =E4=B8=8B=E5=8D=885:10=E5=86=99=E9=81= =93=EF=BC=9A > > HI ALL: > =E6=88=91=E5=9C=A8=E4=BD=BF=E7=94=A8JDBC=E9=A9=B1=E5=8A=A8=E6=9F=A5= =E8=AF=A2kylin=E6=95=B0=E6=8D=AE=E6=97=B6=EF=BC=8C=E5=8D=95=E8=A1=A8=E5=B8= =A6=E5=8F=82=E6=9F=A5=E8=AF=A2=E4=B8=8D=E4=BC=9A=E6=8A=A5=E9=94=99=EF=BC=8C= =E4=BD=86=E6=88=91=E5=A4=9A=E8=A1=A8=E5=85=B3=E8=81=94=EF=BC=88join=EF=BC= =89=E5=B8=A6=E5=8F=82=E6=9F=A5=E8=AF=A2=EF=BC=8C=E4=BC=9A=E6=8A=A5=E6=9C=AA= =E7=9F=A5=E5=BC=82=E5=B8=B8=E4=BF=A1=E6=81=AF=E3=80=82 > > =E7=89=88=E6=9C=AC=E4=BF=A1=E6=81=AF > - CDH=EF=BC=9A6.0.0 > - HIVE=EF=BC=9A2.1.1 > - HBase=EF=BC=9A2.0.0 > - Hadoop 3.0.0 > - Kylin=E7=89=88=E6=9C=AC=EF=BC=9Aapache-kylin-2.5.0-bin-cdh60.tar.gz > > =E6=9F=A5=E8=AF=A2=E8=AF=B7=E6=B1=82=EF=BC=9A > { > "sql":"SELECT > t1.time, > (t1.column_1 - t2.column_2) > FROM > ( > SELECT > count(column_1) as column_1, > time > FROM > table1 > WHERE > time =3D ? > )t1 > LEFT JOIN > ( > SELECT > count(column_2) as column_2, > time > FROM > table2 > WHERE > time =3D ? > > ) t2 ON t1.time =3D t2.time", > "project":"BI", > "acceptPartial":false, > "backdoorToggles":{ > "ATTR_STATEMENT_MAX_ROWS":"0" > }, > "params":[ > { > "className":"java.lang.String", > "value":"2018-06-01" > }, > { > "className":"java.lang.String", > "value":"2018-06-01" > } > ] > } > > =E5=BC=82=E5=B8=B8=E4=BF=A1=E6=81=AF=EF=BC=9A > Realization Names: [CUBE[name=3DBI_order_apply_2], CUBE[name=3DBI_o= rder_apply_2]] > Cuboid Ids: [] > Total scan count: 0 > Total scan bytes: 0 > Result row count: 0 > Accept Partial: false > Is Partial Result: false > Hit Exception Cache: false > Storage cache used: false > Is Query Push-Down: false > Is Prepare: false > Trace URL: null > Message: Unknown error. > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D[QUERY]=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > > 2018-10-11 10:21:29,168 ERROR [http-nio-7070-exec-17] controller.BasicCon= troller:62 : > org.apache.kylin.rest.exception.InternalErrorException: Unknown error. > at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryServi= ce.java:424) > at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryServi= ce.java:351) > at org.apache.kylin.rest.controller.QueryController.query(QueryController= .java:86) > at sun.reflect.GeneratedMethodAccessor155.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess= orImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke= (InvocableHandlerMethod.java:205) > at org.springframework.web.method.support.InvocableHandlerMethod.invokeFo= rRequest(InvocableHandlerMethod.java:133) > at org.springframework.web.servlet.mvc.method.annotation.ServletInvocable= HandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHa= ndlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHa= ndlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapte= r.handle(AbstractHandlerMethodAdapter.java:85) > at org.springframework.web.servlet.DispatcherServlet.doDispatch(Dispatche= rServlet.java:967) > at org.springframework.web.servlet.DispatcherServlet.doService(Dispatcher= Servlet.java:901) > at org.springframework.web.servlet.FrameworkServlet.processRequest(Framew= orkServlet.java:970) > at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServl= et.java:872) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) > at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServ= let.java:846) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli= cationFilterChain.java:231) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi= lterChain.java:166) > at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli= cationFilterChain.java:193) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi= lterChain.java:166) > at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.d= oFilter(FilterChainProxy.java:317) > at org.springframework.security.web.access.intercept.FilterSecurityInterc= eptor.invoke(FilterSecurityInterceptor.java:127) > at org.springframework.security.web.access.intercept.FilterSecurityInterc= eptor.doFilter(FilterSecurityInterceptor.java:91) > at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.d= oFilter(FilterChainProxy.java:331) > at org.springframework.security.web.access.ExceptionTranslationFilter.doF= ilter(ExceptionTranslationFilter.java:114) > at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.d= oFilter(FilterChainProxy.java:331) > at org.springframework.security.web.session.SessionManagementFilter.doFil= ter(SessionManagementFilter.java:137) > at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.d= oFilter(FilterChainProxy.java:331) > at org.springframework.security.web.authentication.AnonymousAuthenticatio= nFilter.doFilter(AnonymousAuthenticationFilter.java:111) > at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.d= oFilter(FilterChainProxy.java:331) > at org.springframework.security.web.servletapi.SecurityContextHolderAware= RequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) > at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.d= oFilter(FilterChainProxy.java:331) > at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.= doFilter(RequestCacheAwareFilter.java:63) > at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.d= oFilter(FilterChainProxy.java:331) > at org.springframework.security.web.authentication.www.BasicAuthenticatio= nFilter.doFilterInternal(BasicAuthenticationFilter.java:215) > at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRe= questFilter.java:107) > at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.d= oFilter(FilterChainProxy.java:331) > at org.springframework.security.web.authentication.AbstractAuthentication= ProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) > at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.d= oFilter(FilterChainProxy.java:331) > at org.springframework.security.web.authentication.logout.LogoutFilter.do= Filter(LogoutFilter.java:116) > at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.d= oFilter(FilterChainProxy.java:331) > at org.springframework.security.web.header.HeaderWriterFilter.doFilterInt= ernal(HeaderWriterFilter.java:64) > at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRe= questFilter.java:107) > at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.d= oFilter(FilterChainProxy.java:331) > at org.springframework.security.web.context.request.async.WebAsyncManager= IntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56= ) > at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRe= questFilter.java:107) > at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.d= oFilter(FilterChainProxy.java:331) > at org.springframework.security.web.context.SecurityContextPersistenceFil= ter.doFilter(SecurityContextPersistenceFilter.java:105) > at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.d= oFilter(FilterChainProxy.java:331) > at org.springframework.security.web.FilterChainProxy.doFilterInternal(Fil= terChainProxy.java:214) > at org.springframework.security.web.FilterChainProxy.doFilter(FilterChain= Proxy.java:177) > at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(De= legatingFilterProxy.java:346) > at org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegati= ngFilterProxy.java:262) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli= cationFilterChain.java:193) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi= lterChain.java:166) > 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(Appli= cationFilterChain.java:193) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi= lterChain.java:166) > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa= lve.java:198) > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa= lve.java:96) > at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticat= orBase.java:493) > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja= va:140) > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja= va:81) > at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAcces= sLogValve.java:650) > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValv= e.java:87) > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java= :342) > at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:= 800) > at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLigh= t.java:66) > at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractP= rotocol.java:806) > at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoi= nt.java:1498) > at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase= .java:49) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.j= ava:1149) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.= java:624) > at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThr= ead.java:61) > at java.lang.Thread.run(Thread.java:748) > > =E4=BB=A5=E4=B8=8A=E4=B8=BA=E5=85=A8=E9=83=A8=E4=BF=A1=E6=81=AF=EF=BC= =8C=E8=B0=A2=E8=B0=A2=E3=80=82 > ________________________________ > zhangpeng@bcpeople.com