It says "Error in coprocessor". Maybe you were upgraded from a previous version but forgot to re-deploy the coprocessor?
On Sun, Sep 25, 2016 at 5:06 PM, ray <[email protected]> wrote: > thanks for reply, the version is apache-kylin-1.5.4-HBase1.x-bin > > I also tried the query SQL you mentioned but get the same error, do you > have > any advise? > > > > Yiming Liu-2 wrote > > It seems you were running "select * from kylin_sales LIMIT 50000", not > > "select > > part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers > > from kylin_sales group by part_dt order by part_dt". > > > > Which Kylin version used? There supposed be more exception logs, could > you > > check again? > > > > 2016-09-25 11:32 GMT+08:00 ray < > > > 290415881@ > > >>: > > > >> I use the sample data to build cube and want to execute some query like > >> "select part_dt, sum(price) as total_selled, count(distinct seller_id) > as > >> sellers from kylin_sales group by part_dt order by part_dt", but it > >> returns > >> "Error in coprocessor". Please help! > >> > >> ps: I already set kylin.coprocessor.local.jar in kylin.properties > >> > >> The logs as below: > >> > >> Message: Error while executing SQL "select * from kylin_sales LIMIT > >> 50000": > >> Error in coprocessor > >> ==========================[QUERY]=============================== > >> > >> 2016-09-25 11:09:40,761 ERROR [http-bio-7070-exec-3] > >> controller.BasicController:44 : > >> org.apache.kylin.rest.exception.InternalErrorException: Error while > >> executing SQL "select * from kylin_sales LIMIT 50000": Error in > >> coprocessor > >> at > >> org.apache.kylin.rest.controller.QueryController.doQueryWithCache( > >> QueryController.java:225) > >> at > >> org.apache.kylin.rest.controller.QueryController. > >> query(QueryController.java:94) > >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > >> at > >> sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java: > >> 62) > >> at > >> sun.reflect.DelegatingMethodAccessorImpl.invoke( > >> DelegatingMethodAccessorImpl.java:43) > >> at java.lang.reflect.Method.invoke(Method.java:497) > >> at > >> org.springframework.web.method.support.InvocableHandlerMethod.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. > SecurityContextHolderAwareRequ > >> estFilter.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) > >> > >> -- > >> View this message in context: http://apache-kylin.74782.x6. > >> nabble.com/query-error-and-return-detail-Error-in- > coprocessor-tp5891.html > >> Sent from the Apache Kylin mailing list archive at Nabble.com. > >> > > > > > > > > -- > > With Warm regards > > > > Yiming Liu (刘一鸣) > > > > -- > View this message in context: http://apache-kylin.74782.x6. > nabble.com/query-error-and-return-detail-Error-in- > coprocessor-tp5891p5894.html > Sent from the Apache Kylin mailing list archive at Nabble.com. >
