[jira] [Updated] (KYLIN-4497) PreparedStatement query do not support "limit ? offset ?"
[
https://issues.apache.org/jira/browse/KYLIN-4497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
xuekaiqi updated KYLIN-4497:
Sprint: (was: Sprint 53)
> PreparedStatement query do not support "limit ? offset ?"
> -
>
> Key: KYLIN-4497
> URL: https://issues.apache.org/jira/browse/KYLIN-4497
> Project: Kylin
> Issue Type: Bug
> Components: Driver - JDBC
>Reporter: Chao Long
>Assignee: Chao Long
>Priority: Major
> Fix For: Backlog
>
>
> Query
> {code:java}
> String sql = "select part_dt, sum(price) from KYLIN_SALES group by part_dt
> order by part_dt limit ? offset ?";
> conn = getConnection();
> statement = conn.prepareStatement(sql);
> statement.setInt(1, 10);
> statement.setInt(2, 0);
> {code}
> Error log
> {code:java}
> 2020-05-15 09:32:36,062 ERROR [Query b87327f4-7299-32f2-4a2e-c19795a42288-44]
> service.QueryService:542 : Exception while executing query
> java.sql.SQLException: Error while preparing statement [select part_dt,
> sum(price) from KYLIN_SALES group by part_dt order by part_dt limit ? offset
> ?]
> at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
> at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:210)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:192)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:89)
> at
> org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:175)
> at
> org.apache.kylin.rest.service.QueryService.createPreparedContext(QueryService.java:1262)
> at
> org.apache.kylin.rest.service.QueryService.access$600(QueryService.java:141)
> at
> org.apache.kylin.rest.service.QueryService$PreparedContextFactory.create(QueryService.java:1301)
> at
> org.apache.kylin.rest.service.QueryService$PreparedContextFactory.create(QueryService.java:1296)
> at
> org.apache.commons.pool2.BaseKeyedPooledObjectFactory.makeObject(BaseKeyedPooledObjectFactory.java:60)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.create(GenericKeyedObjectPool.java:1064)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:358)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:281)
> at
> org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:680)
> at
> org.apache.kylin.rest.service.QueryService.query(QueryService.java:219)
> at
> org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:480)
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:440)
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:378)
> at
> org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93)
> 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:498)
> at
> org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
> at
> org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
> at
> com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
>
[jira] [Updated] (KYLIN-4497) PreparedStatement query do not support "limit ? offset ?"
[
https://issues.apache.org/jira/browse/KYLIN-4497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
xuekaiqi updated KYLIN-4497:
Sprint: Sprint 53 (was: Sprint 52)
> PreparedStatement query do not support "limit ? offset ?"
> -
>
> Key: KYLIN-4497
> URL: https://issues.apache.org/jira/browse/KYLIN-4497
> Project: Kylin
> Issue Type: Bug
> Components: Driver - JDBC
>Reporter: Chao Long
>Assignee: Chao Long
>Priority: Major
> Fix For: Backlog
>
>
> Query
> {code:java}
> String sql = "select part_dt, sum(price) from KYLIN_SALES group by part_dt
> order by part_dt limit ? offset ?";
> conn = getConnection();
> statement = conn.prepareStatement(sql);
> statement.setInt(1, 10);
> statement.setInt(2, 0);
> {code}
> Error log
> {code:java}
> 2020-05-15 09:32:36,062 ERROR [Query b87327f4-7299-32f2-4a2e-c19795a42288-44]
> service.QueryService:542 : Exception while executing query
> java.sql.SQLException: Error while preparing statement [select part_dt,
> sum(price) from KYLIN_SALES group by part_dt order by part_dt limit ? offset
> ?]
> at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
> at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:210)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:192)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:89)
> at
> org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:175)
> at
> org.apache.kylin.rest.service.QueryService.createPreparedContext(QueryService.java:1262)
> at
> org.apache.kylin.rest.service.QueryService.access$600(QueryService.java:141)
> at
> org.apache.kylin.rest.service.QueryService$PreparedContextFactory.create(QueryService.java:1301)
> at
> org.apache.kylin.rest.service.QueryService$PreparedContextFactory.create(QueryService.java:1296)
> at
> org.apache.commons.pool2.BaseKeyedPooledObjectFactory.makeObject(BaseKeyedPooledObjectFactory.java:60)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.create(GenericKeyedObjectPool.java:1064)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:358)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:281)
> at
> org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:680)
> at
> org.apache.kylin.rest.service.QueryService.query(QueryService.java:219)
> at
> org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:480)
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:440)
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:378)
> at
> org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93)
> 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:498)
> at
> org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
> at
> org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
> at
> com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
> at
>
[jira] [Updated] (KYLIN-4497) PreparedStatement query do not support "limit ? offset ?"
[
https://issues.apache.org/jira/browse/KYLIN-4497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shao Feng Shi updated KYLIN-4497:
-
Fix Version/s: (was: v3.1.0)
Backlog
> PreparedStatement query do not support "limit ? offset ?"
> -
>
> Key: KYLIN-4497
> URL: https://issues.apache.org/jira/browse/KYLIN-4497
> Project: Kylin
> Issue Type: Bug
> Components: Driver - JDBC
>Reporter: Chao Long
>Assignee: Chao Long
>Priority: Major
> Fix For: Backlog
>
>
> Query
> {code:java}
> String sql = "select part_dt, sum(price) from KYLIN_SALES group by part_dt
> order by part_dt limit ? offset ?";
> conn = getConnection();
> statement = conn.prepareStatement(sql);
> statement.setInt(1, 10);
> statement.setInt(2, 0);
> {code}
> Error log
> {code:java}
> 2020-05-15 09:32:36,062 ERROR [Query b87327f4-7299-32f2-4a2e-c19795a42288-44]
> service.QueryService:542 : Exception while executing query
> java.sql.SQLException: Error while preparing statement [select part_dt,
> sum(price) from KYLIN_SALES group by part_dt order by part_dt limit ? offset
> ?]
> at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
> at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:210)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:192)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:89)
> at
> org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:175)
> at
> org.apache.kylin.rest.service.QueryService.createPreparedContext(QueryService.java:1262)
> at
> org.apache.kylin.rest.service.QueryService.access$600(QueryService.java:141)
> at
> org.apache.kylin.rest.service.QueryService$PreparedContextFactory.create(QueryService.java:1301)
> at
> org.apache.kylin.rest.service.QueryService$PreparedContextFactory.create(QueryService.java:1296)
> at
> org.apache.commons.pool2.BaseKeyedPooledObjectFactory.makeObject(BaseKeyedPooledObjectFactory.java:60)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.create(GenericKeyedObjectPool.java:1064)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:358)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:281)
> at
> org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:680)
> at
> org.apache.kylin.rest.service.QueryService.query(QueryService.java:219)
> at
> org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:480)
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:440)
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:378)
> at
> org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93)
> 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:498)
> at
> org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
> at
> org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
> at
> com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
> at
>
[jira] [Updated] (KYLIN-4497) PreparedStatement query do not support "limit ? offset ?"
[
https://issues.apache.org/jira/browse/KYLIN-4497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
nichunen updated KYLIN-4497:
Sprint: Sprint 52
> PreparedStatement query do not support "limit ? offset ?"
> -
>
> Key: KYLIN-4497
> URL: https://issues.apache.org/jira/browse/KYLIN-4497
> Project: Kylin
> Issue Type: Bug
> Components: Driver - JDBC
>Reporter: Chao Long
>Assignee: Chao Long
>Priority: Major
> Fix For: v3.1.0
>
>
> Query
> {code:java}
> String sql = "select part_dt, sum(price) from KYLIN_SALES group by part_dt
> order by part_dt limit ? offset ?";
> conn = getConnection();
> statement = conn.prepareStatement(sql);
> statement.setInt(1, 10);
> statement.setInt(2, 0);
> {code}
> Error log
> {code:java}
> 2020-05-15 09:32:36,062 ERROR [Query b87327f4-7299-32f2-4a2e-c19795a42288-44]
> service.QueryService:542 : Exception while executing query
> java.sql.SQLException: Error while preparing statement [select part_dt,
> sum(price) from KYLIN_SALES group by part_dt order by part_dt limit ? offset
> ?]
> at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
> at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:210)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:192)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:89)
> at
> org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:175)
> at
> org.apache.kylin.rest.service.QueryService.createPreparedContext(QueryService.java:1262)
> at
> org.apache.kylin.rest.service.QueryService.access$600(QueryService.java:141)
> at
> org.apache.kylin.rest.service.QueryService$PreparedContextFactory.create(QueryService.java:1301)
> at
> org.apache.kylin.rest.service.QueryService$PreparedContextFactory.create(QueryService.java:1296)
> at
> org.apache.commons.pool2.BaseKeyedPooledObjectFactory.makeObject(BaseKeyedPooledObjectFactory.java:60)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.create(GenericKeyedObjectPool.java:1064)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:358)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:281)
> at
> org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:680)
> at
> org.apache.kylin.rest.service.QueryService.query(QueryService.java:219)
> at
> org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:480)
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:440)
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:378)
> at
> org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93)
> 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:498)
> at
> org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
> at
> org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
> at
> com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
> at
