[jira] [Commented] (KYLIN-5224) kylin 4.0.1 不支持分页查询
[ https://issues.apache.org/jira/browse/KYLIN-5224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17579441#comment-17579441 ] liyang commented on KYLIN-5224: --- then the request changes to support spark 3.4 :) > kylin 4.0.1 不支持分页查询 > --- > > Key: KYLIN-5224 > URL: https://issues.apache.org/jira/browse/KYLIN-5224 > Project: Kylin > Issue Type: Bug >Affects Versions: v4.0.1 >Reporter: liulei >Priority: Major > > { > "code": "999", > "data": null, > "msg": " mismatched input 'offset' expecting \{, ';'}(line 1, pos > 55) == SQL == select * from MES_PROD.inspec_doc_report_data limit 10 offset > 5 ---^^^ ", > "stacktrace": "org.apache.kylin.rest.exception.InternalErrorException: > mismatched input 'offset' expecting \{, ';'}(line 1, pos 55) == SQL == > select * from MES_PROD.inspec_doc_report_data limit 10 offset 5 > ---^^^ \n\tat > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:497)\n\tat > > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:416)\n\tat > > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93)\n\tat > sun.reflect.GeneratedMethodAccessor184.invoke(Unknown Source)\n\tat > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat > java.lang.reflect.Method.invoke(Method.java:498)\n\tat > org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\n\tat > > org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)\n\tat > > org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)\n\tat > > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854)\n\tat > > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765)\n\tat > > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\n\tat > > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)\n\tat > > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)\n\tat > > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)\n\tat > > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)\n\tat > javax.servlet.http.HttpServlet.service(HttpServlet.java:647)\n\tat > org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)\n\tat > javax.servlet.http.HttpServlet.service(HttpServlet.java:728)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)\n\tat > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat > org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)\n\tat > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)\n\tat > > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)\n\tat > > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)\n\tat > > org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)\n\tat > > org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)\n\tat > > org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)\n\tat > > org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)\n\tat > > org.sprin
[jira] [Commented] (KYLIN-5224) kylin 4.0.1 不支持分页查询
[ https://issues.apache.org/jira/browse/KYLIN-5224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17579335#comment-17579335 ] zhaoliu commented on KYLIN-5224: spark 3.4.0 支持了"limit ... offset ..." https://issues.apache.org/jira/browse/SPARK-28330 > kylin 4.0.1 不支持分页查询 > --- > > Key: KYLIN-5224 > URL: https://issues.apache.org/jira/browse/KYLIN-5224 > Project: Kylin > Issue Type: Bug >Affects Versions: v4.0.1 >Reporter: liulei >Priority: Major > > { > "code": "999", > "data": null, > "msg": " mismatched input 'offset' expecting \{, ';'}(line 1, pos > 55) == SQL == select * from MES_PROD.inspec_doc_report_data limit 10 offset > 5 ---^^^ ", > "stacktrace": "org.apache.kylin.rest.exception.InternalErrorException: > mismatched input 'offset' expecting \{, ';'}(line 1, pos 55) == SQL == > select * from MES_PROD.inspec_doc_report_data limit 10 offset 5 > ---^^^ \n\tat > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:497)\n\tat > > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:416)\n\tat > > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93)\n\tat > sun.reflect.GeneratedMethodAccessor184.invoke(Unknown Source)\n\tat > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat > java.lang.reflect.Method.invoke(Method.java:498)\n\tat > org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\n\tat > > org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)\n\tat > > org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)\n\tat > > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854)\n\tat > > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765)\n\tat > > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\n\tat > > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)\n\tat > > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)\n\tat > > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)\n\tat > > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)\n\tat > javax.servlet.http.HttpServlet.service(HttpServlet.java:647)\n\tat > org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)\n\tat > javax.servlet.http.HttpServlet.service(HttpServlet.java:728)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)\n\tat > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat > org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)\n\tat > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)\n\tat > > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)\n\tat > > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)\n\tat > > org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)\n\tat > > org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)\n\tat > > org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)\n\tat > > org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareReq
[jira] [Commented] (KYLIN-5224) kylin 4.0.1 不支持分页查询
[ https://issues.apache.org/jira/browse/KYLIN-5224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17576605#comment-17576605 ] mukvin commented on KYLIN-5224: --- Hi [~flycoder], Currently, Kylin is using spark SQL as the pushdown of the engine, and spark does not support the "limit ... offset ..." syntax. So it does not work for your scene. > kylin 4.0.1 不支持分页查询 > --- > > Key: KYLIN-5224 > URL: https://issues.apache.org/jira/browse/KYLIN-5224 > Project: Kylin > Issue Type: Bug >Affects Versions: v4.0.1 >Reporter: liulei >Priority: Major > > { > "code": "999", > "data": null, > "msg": " mismatched input 'offset' expecting \{, ';'}(line 1, pos > 55) == SQL == select * from MES_PROD.inspec_doc_report_data limit 10 offset > 5 ---^^^ ", > "stacktrace": "org.apache.kylin.rest.exception.InternalErrorException: > mismatched input 'offset' expecting \{, ';'}(line 1, pos 55) == SQL == > select * from MES_PROD.inspec_doc_report_data limit 10 offset 5 > ---^^^ \n\tat > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:497)\n\tat > > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:416)\n\tat > > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93)\n\tat > sun.reflect.GeneratedMethodAccessor184.invoke(Unknown Source)\n\tat > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat > java.lang.reflect.Method.invoke(Method.java:498)\n\tat > org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\n\tat > > org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)\n\tat > > org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)\n\tat > > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854)\n\tat > > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765)\n\tat > > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\n\tat > > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)\n\tat > > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)\n\tat > > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)\n\tat > > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)\n\tat > javax.servlet.http.HttpServlet.service(HttpServlet.java:647)\n\tat > org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)\n\tat > javax.servlet.http.HttpServlet.service(HttpServlet.java:728)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)\n\tat > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat > org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)\n\tat > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)\n\tat > > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)\n\tat > > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)\n\tat > > org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)\n\tat > > org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)\n\tat > > org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)\n\tat > > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)\n\tat > > org.springframework.security.w