java.sql.SQLException: error 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": Error when scan from lower key @ to upper key @��� on table KYLIN_FOBSAT4IR6.

incubator-kylin-user | Zhang, Edward (GDI Hadoop) | 1 year 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: kylin org sample query failed as "Error when scan from lower key @ to upper key" after build successfully

    kylin-user | 1 year ago | Gqchen
    java.sql.SQLException: error 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": Error when scan from lower key @ to upper key @��� on table KYLIN_FOBSAT4IR6.
  2. 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)
    java.sql.SQLException: error 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": Error when scan from lower key @ to upper key @��� on table KYLIN_FOBSAT4IR6.
  3. 0

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

    incubator-kylin-user | 1 year ago | Gqchen
    java.sql.SQLException: error 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": Error when scan from lower key @ to upper key @��� on table KYLIN_FOBSAT4IR6.
  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

    incubator-kylin-user | 1 year ago | Zhang, Edward (GDI Hadoop)
    java.sql.SQLException: error 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": Error when scan from lower key @ to upper key @��� on table KYLIN_FOBSAT4IR6.

    Root Cause Analysis

    1. java.lang.NoSuchMethodError

      org.apache.hadoop.hbase.client.Scan.setCaching(I)V

      at org.apache.kylin.storage.hbase.CubeSegmentTupleIterator.tuneScanParameters()
    2. org.apache.kylin
      CubeEnumerator.moveNext
      1. org.apache.kylin.storage.hbase.CubeSegmentTupleIterator.tuneScanParameters(CubeSegmentTupleIterator.java:270)
      2. org.apache.kylin.storage.hbase.CubeSegmentTupleIterator.buildScan(CubeSegmentTupleIterator.java:254)
      3. org.apache.kylin.storage.hbase.CubeSegmentTupleIterator.doScan(CubeSegmentTupleIterator.java:212)
      4. org.apache.kylin.storage.hbase.CubeSegmentTupleIterator.scanNextRange(CubeSegmentTupleIterator.java:202)
      5. org.apache.kylin.storage.hbase.CubeSegmentTupleIterator.<init>(CubeSegmentTupleIterator.java:113)
      6. org.apache.kylin.storage.hbase.SerializedHBaseTupleIterator.<init>(SerializedHBaseTupleIterator.java:64)
      7. org.apache.kylin.storage.hbase.CubeStorageEngine.search(CubeStorageEngine.java:143)
      8. org.apache.kylin.query.enumerator.CubeEnumerator.queryStorage(CubeEnumerator.java:149)
      9. org.apache.kylin.query.enumerator.CubeEnumerator.moveNext(CubeEnumerator.java:74)
      9 frames
    3. Unknown
      Baz$1$1.moveNext
      1. Baz$1$1.moveNext(Unknown Source)
      1 frame
    4. org.apache.calcite
      DefaultEnumerable.groupBy
      1. org.apache.calcite.linq4j.EnumerableDefaults.groupBy_(EnumerableDefaults.java:737)
      2. org.apache.calcite.linq4j.EnumerableDefaults.groupBy(EnumerableDefaults.java:677)
      3. org.apache.calcite.linq4j.DefaultEnumerable.groupBy(DefaultEnumerable.java:301)
      3 frames
    5. Unknown
      Baz.bind
      1. Baz.bind(Unknown Source)
      1 frame
    6. org.apache.calcite
      AvaticaStatement.executeQuery
      1. org.apache.calcite.jdbc.CalcitePrepare$CalciteSignature.enumerable(CalcitePrepare.java:281)
      2. org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(CalciteConnectionImpl.java:235)
      3. org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(CalciteMetaImpl.java:533)
      4. org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:184)
      5. org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:63)
      6. org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:42)
      7. org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:473)
      8. org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:566)
      9. org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477)
      10. org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109)
      11. org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:130)
      11 frames
    7. org.apache.kylin
      QueryService$$FastClassByCGLIB$$4957273f.invoke
      1. org.apache.kylin.rest.service.QueryService.execute(QueryService.java:354)
      2. org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:268)
      3. org.apache.kylin.rest.service.QueryService.query(QueryService.java:114)
      4. org.apache.kylin.rest.service.QueryService$$FastClassByCGLIB$$4957273f.invoke(<generated>)
      4 frames
    8. IDEA
      MethodProxy.invoke
      1. net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
      1 frame
    9. Spring AOP
      Cglib2AopProxy$DynamicAdvisedInterceptor.intercept
      1. org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618)
      1 frame
    10. org.apache.kylin
      QueryController.query
      1. org.apache.kylin.rest.service.QueryService$$EnhancerByCGLIB$$e4e1e494.query(<generated>)
      2. org.apache.kylin.rest.controller.QueryController.doQueryWithCache(QueryController.java:178)
      3. org.apache.kylin.rest.controller.QueryController.query(QueryController.java:85)
      3 frames
    11. 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:606)
      4 frames
    12. 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
    13. 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
    14. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      2 frames
    15. 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
    16. Tomcat WS
      WsFilter.doFilter
      1. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
      1 frame
    17. 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
    18. 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
    19. 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
    20. 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
    21. org.apache.kylin
      KylinApiFilter.doFilterInternal
      1. org.apache.kylin.rest.filter.KylinApiFilter.doFilterInternal(KylinApiFilter.java:66)
      1 frame
    22. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
      1 frame
    23. 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
    24. CORS Filter
      CORSFilter.doFilter
      1. com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:195)
      2. com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:266)
      2 frames
    25. 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
    26. 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
    27. Java RT
      ThreadPoolExecutor$Worker.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      2 frames
    28. Tomcat Util
      TaskThread$WrappingRunnable.run
      1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      1 frame
    29. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame