kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Li Yang <liy...@apache.org>
Subject Re: query error and return detail "Error in coprocessor"
Date Wed, 28 Sep 2016 05:21:17 GMT
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 <290415881@qq.com> 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.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message