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.
