org.apache.kylin.rest.exception.InternalErrorException: Error while executing SQL "select sum(pv_1d_001) pv from lbs_ad_pv_1d group by INDS order by pv desc LIMIT 50000": Can't find any realization. Please confirm with providers. SQL digest: fact table LBS.LBS_AD_PV_1D,group by [LBS.LBS_AD_PV_1D.INDS],filter on [],with aggregates[FunctionDesc [expression=SUM, parameter=ParameterDesc [type=column, value=PV_1D_001, nextParam=null], returnType=null]].

kylin-user | lancelot chen | 9 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Re: Usage of TOP_N measure

    kylin-user | 9 months ago | lancelot chen
    org.apache.kylin.rest.exception.InternalErrorException: Error while executing SQL "select sum(pv_1d_001) pv from lbs_ad_pv_1d group by INDS order by pv desc LIMIT 50000": Can't find any realization. Please confirm with providers. SQL digest: fact table LBS.LBS_AD_PV_1D,group by [LBS.LBS_AD_PV_1D.INDS],filter on [],with aggregates[FunctionDesc [expression=SUM, parameter=ParameterDesc [type=column, value=PV_1D_001, nextParam=null], returnType=null]].
  2. 0

    Re: Usage of TOP_N measure

    incubator-kylin-user | 9 months ago | lancelot chen
    org.apache.kylin.rest.exception.InternalErrorException: Error while executing SQL "select sum(pv_1d_001) pv from lbs_ad_pv_1d group by INDS order by pv desc LIMIT 50000": Can't find any realization. Please confirm with providers. SQL digest: fact table LBS.LBS_AD_PV_1D,group by [LBS.LBS_AD_PV_1D.INDS],filter on [],with aggregates[FunctionDesc [expression=SUM, parameter=ParameterDesc [type=column, value=PV_1D_001, nextParam=null], returnType=null]].
  3. 0

    kylin org sample query failed as "Error when scan from lower key @ to upper key" after build successfully

    kylin-user | 1 year ago | Gqchen
    org.apache.kylin.rest.exception.InternalErrorException: Error when scan from lower key @ to upper key @��� on table KYLIN_FOBSAT4IR6. while executing SQL: "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 LIMIT 10"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: kylin org sample query failed as "Error when scan from lower key @ to upper key" after build successfully

    kylin-user | 1 year ago | Zhang, Edward (GDI Hadoop)
    org.apache.kylin.rest.exception.InternalErrorException: Error when scan from lower key @ to upper key @��� on table KYLIN_FOBSAT4IR6. while executing SQL: "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 LIMIT 10"
  6. 0

    Re: kylin org sample query failed as "Error when scan from lower key @ to upper key" after build successfully

    kylin-user | 1 year ago | Zhang, Edward (GDI Hadoop)
    org.apache.kylin.rest.exception.InternalErrorException: Error when scan from lower key @ to upper key @��� on table KYLIN_FOBSAT4IR6. while executing SQL: "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 LIMIT 10"

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.apache.kylin.rest.exception.InternalErrorException

      Error while executing SQL "select sum(pv_1d_001) pv from lbs_ad_pv_1d group by INDS order by pv desc LIMIT 50000": Can't find any realization. Please confirm with providers. SQL digest: fact table LBS.LBS_AD_PV_1D,group by [LBS.LBS_AD_PV_1D.INDS],filter on [],with aggregates[FunctionDesc [expression=SUM, parameter=ParameterDesc [type=column, value=PV_1D_001, nextParam=null], returnType=null]].

      at org.apache.kylin.rest.controller.QueryController.doQueryWithCache()
    2. org.apache.kylin
      QueryController.query
      1. org.apache.kylin.rest.controller.QueryController.doQueryWithCache(QueryController.java:224)
      2. org.apache.kylin.rest.controller.QueryController.query(QueryController.java:94)
      2 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:601)
      4 frames
    4. Spring
      InvocableHandlerMethod.invokeForRequest
      1. org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213)
      2. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)
      2 frames
    5. Spring MVC
      FrameworkServlet.doPost
      1. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)
      2. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)
      3. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)
      4. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
      5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
      6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
      7. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
      8. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
      8 frames
    6. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      2 frames
    7. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      2 frames
    8. Tomcat WS
      WsFilter.doFilter
      1. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
      1 frame
    9. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      2 frames
    10. Spring Security
      FilterChainProxy.doFilter
      1. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
      2. org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
      3. org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
      4. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      5. org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
      6. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      7. org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
      8. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      9. org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
      10. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      11. org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
      12. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      13. org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
      14. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      15. org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201)
      16. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      17. org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91)
      18. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      19. org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
      20. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      21. org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
      22. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      23. org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
      24. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
      25. org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
      26. org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
      26 frames
    11. Spring
      DelegatingFilterProxy.doFilter
      1. org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
      2. org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
      2 frames
    12. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      2 frames
    13. CORS Filter
      CORSFilter.doFilter
      1. com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:195)
      2. com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:266)
      2 frames
    14. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
      8. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
      9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
      10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
      10 frames
    15. Grizzly HTTP
      JIoEndpoint$SocketProcessor.run
      1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
      2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
      3. org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
      3 frames
    16. Java RT
      ThreadPoolExecutor$Worker.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
      2 frames
    17. Tomcat Util
      TaskThread$WrappingRunnable.run
      1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      1 frame
    18. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:722)
      1 frame