[jira] [Commented] (KYLIN-4047) Use push-down query when division dynamic column cube query is not supported
[ https://issues.apache.org/jira/browse/KYLIN-4047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16908078#comment-16908078 ] ASF subversion and git services commented on KYLIN-4047: Commit 9650c8d597a57472677a283d51956f1a69a1e735 in kylin's branch refs/heads/2.6.x from wangxiaojing123 [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=9650c8d ] KYLIN-4047 Use push-down query when division dynamic column cube query is not supported (#689) * KYLIN-4047 Use push-down query when division dynamic column cube query is not supported * Minor, Code format > Use push-down query when division dynamic column cube query is not supported > > > Key: KYLIN-4047 > URL: https://issues.apache.org/jira/browse/KYLIN-4047 > Project: Kylin > Issue Type: Improvement > Components: Query Engine >Affects Versions: Future, v2.6.2, v3.0.0-alpha >Reporter: wangxiaojing >Priority: Minor > Fix For: v2.6.4 > > > Hello all , > At present, if a table has created cube, the query with division > dynamic column will throw an exception without pushdown query results, but if > switching an project, pushdown query will be carried out, which will give > users inconsistent experience. Can we also use pushdown query when query > division, multiplication dynamic column throw exceptions ? > Scene: > SQL:select round (car_dismatch_cnt*100/answer_order_cnt, 4) from db.table1. > 1、Executes the SQL on project where has create a cube has db.table1,it will > throws the right side of the BinaryTuple Expressions columns is not supported > for / exception and is not queried through pushdown; > 2、When change a project where not create the table cube , the same query can > be executed to push down and get the right result. > 3. Expect that no matter whether a table cube is created or not, when the > cube query is not success, the result can still be obtained by pushdown > query, which will give users a consistent experience. > {code:java} > // exception > 2019-06-06 19:04:55,902 ERROR [http-bio-8081-exec-1] > controller.BasicController:63 : > org.apache.kylin.rest.exception.InternalErrorException: That the right side > of the BinaryTupleExpression owns columns is not supported for / > while executing SQL: "select DT,ORD_AMT/ORD_AMT from db.table1 LIMIT 5" > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:452) > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:373) > at > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87) > 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.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > at > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) > at > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > at > org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) > 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 >
[jira] [Commented] (KYLIN-4047) Use push-down query when division dynamic column cube query is not supported
[ https://issues.apache.org/jira/browse/KYLIN-4047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16888672#comment-16888672 ] ASF subversion and git services commented on KYLIN-4047: Commit 8b3a2685369ce24366c2caca2039c3a450723c58 in kylin's branch refs/heads/master-hadoop3.1 from XiaoxiangYu [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=8b3a268 ] Minor fix KYLIN-4084 KYLIN-4047 > Use push-down query when division dynamic column cube query is not supported > > > Key: KYLIN-4047 > URL: https://issues.apache.org/jira/browse/KYLIN-4047 > Project: Kylin > Issue Type: Improvement > Components: Query Engine >Affects Versions: Future, v2.6.2, v3.0.0-alpha >Reporter: wangxiaojing >Priority: Minor > > Hello all , > At present, if a table has created cube, the query with division > dynamic column will throw an exception without pushdown query results, but if > switching an project, pushdown query will be carried out, which will give > users inconsistent experience. Can we also use pushdown query when query > division, multiplication dynamic column throw exceptions ? > Scene: > SQL:select round (car_dismatch_cnt*100/answer_order_cnt, 4) from db.table1. > 1、Executes the SQL on project where has create a cube has db.table1,it will > throws the right side of the BinaryTuple Expressions columns is not supported > for / exception and is not queried through pushdown; > 2、When change a project where not create the table cube , the same query can > be executed to push down and get the right result. > 3. Expect that no matter whether a table cube is created or not, when the > cube query is not success, the result can still be obtained by pushdown > query, which will give users a consistent experience. > {code:java} > // exception > 2019-06-06 19:04:55,902 ERROR [http-bio-8081-exec-1] > controller.BasicController:63 : > org.apache.kylin.rest.exception.InternalErrorException: That the right side > of the BinaryTupleExpression owns columns is not supported for / > while executing SQL: "select DT,ORD_AMT/ORD_AMT from db.table1 LIMIT 5" > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:452) > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:373) > at > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87) > 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.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > at > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) > at > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > at > org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) > 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:317) > at >
[jira] [Commented] (KYLIN-4047) Use push-down query when division dynamic column cube query is not supported
[ https://issues.apache.org/jira/browse/KYLIN-4047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16887689#comment-16887689 ] ASF subversion and git services commented on KYLIN-4047: Commit 8b3a2685369ce24366c2caca2039c3a450723c58 in kylin's branch refs/heads/master from XiaoxiangYu [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=8b3a268 ] Minor fix KYLIN-4084 KYLIN-4047 > Use push-down query when division dynamic column cube query is not supported > > > Key: KYLIN-4047 > URL: https://issues.apache.org/jira/browse/KYLIN-4047 > Project: Kylin > Issue Type: Improvement > Components: Query Engine >Affects Versions: Future, v2.6.2, v3.0.0-alpha >Reporter: wangxiaojing >Priority: Minor > > Hello all , > At present, if a table has created cube, the query with division > dynamic column will throw an exception without pushdown query results, but if > switching an project, pushdown query will be carried out, which will give > users inconsistent experience. Can we also use pushdown query when query > division, multiplication dynamic column throw exceptions ? > Scene: > SQL:select round (car_dismatch_cnt*100/answer_order_cnt, 4) from db.table1. > 1、Executes the SQL on project where has create a cube has db.table1,it will > throws the right side of the BinaryTuple Expressions columns is not supported > for / exception and is not queried through pushdown; > 2、When change a project where not create the table cube , the same query can > be executed to push down and get the right result. > 3. Expect that no matter whether a table cube is created or not, when the > cube query is not success, the result can still be obtained by pushdown > query, which will give users a consistent experience. > {code:java} > // exception > 2019-06-06 19:04:55,902 ERROR [http-bio-8081-exec-1] > controller.BasicController:63 : > org.apache.kylin.rest.exception.InternalErrorException: That the right side > of the BinaryTupleExpression owns columns is not supported for / > while executing SQL: "select DT,ORD_AMT/ORD_AMT from db.table1 LIMIT 5" > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:452) > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:373) > at > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87) > 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.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > at > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) > at > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > at > org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) > 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:317) > at >
[jira] [Commented] (KYLIN-4047) Use push-down query when division dynamic column cube query is not supported
[ https://issues.apache.org/jira/browse/KYLIN-4047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16884629#comment-16884629 ] ASF subversion and git services commented on KYLIN-4047: Commit e7f548c85358bb3ad9a3aed697a4311c92bb364c in kylin's branch refs/heads/master from wangxiaojing123 [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=e7f548c ] KYLIN-4047 Use push-down query when division dynamic column cube query is not supported (#689) * KYLIN-4047 Use push-down query when division dynamic column cube query is not supported * Minor, Code format > Use push-down query when division dynamic column cube query is not supported > > > Key: KYLIN-4047 > URL: https://issues.apache.org/jira/browse/KYLIN-4047 > Project: Kylin > Issue Type: Improvement > Components: Query Engine >Affects Versions: Future, v2.6.2, v3.0.0-alpha >Reporter: wangxiaojing >Priority: Minor > > Hello all , > At present, if a table has created cube, the query with division > dynamic column will throw an exception without pushdown query results, but if > switching an project, pushdown query will be carried out, which will give > users inconsistent experience. Can we also use pushdown query when query > division, multiplication dynamic column throw exceptions ? > Scene: > SQL:select round (car_dismatch_cnt*100/answer_order_cnt, 4) from db.table1. > 1、Executes the SQL on project where has create a cube has db.table1,it will > throws the right side of the BinaryTuple Expressions columns is not supported > for / exception and is not queried through pushdown; > 2、When change a project where not create the table cube , the same query can > be executed to push down and get the right result. > 3. Expect that no matter whether a table cube is created or not, when the > cube query is not success, the result can still be obtained by pushdown > query, which will give users a consistent experience. > {code:java} > // exception > 2019-06-06 19:04:55,902 ERROR [http-bio-8081-exec-1] > controller.BasicController:63 : > org.apache.kylin.rest.exception.InternalErrorException: That the right side > of the BinaryTupleExpression owns columns is not supported for / > while executing SQL: "select DT,ORD_AMT/ORD_AMT from db.table1 LIMIT 5" > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:452) > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:373) > at > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87) > 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.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > at > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) > at > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > at > org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) > 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 >
[jira] [Commented] (KYLIN-4047) Use push-down query when division dynamic column cube query is not supported
[ https://issues.apache.org/jira/browse/KYLIN-4047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16884630#comment-16884630 ] ASF subversion and git services commented on KYLIN-4047: Commit e7f548c85358bb3ad9a3aed697a4311c92bb364c in kylin's branch refs/heads/master from wangxiaojing123 [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=e7f548c ] KYLIN-4047 Use push-down query when division dynamic column cube query is not supported (#689) * KYLIN-4047 Use push-down query when division dynamic column cube query is not supported * Minor, Code format > Use push-down query when division dynamic column cube query is not supported > > > Key: KYLIN-4047 > URL: https://issues.apache.org/jira/browse/KYLIN-4047 > Project: Kylin > Issue Type: Improvement > Components: Query Engine >Affects Versions: Future, v2.6.2, v3.0.0-alpha >Reporter: wangxiaojing >Priority: Minor > > Hello all , > At present, if a table has created cube, the query with division > dynamic column will throw an exception without pushdown query results, but if > switching an project, pushdown query will be carried out, which will give > users inconsistent experience. Can we also use pushdown query when query > division, multiplication dynamic column throw exceptions ? > Scene: > SQL:select round (car_dismatch_cnt*100/answer_order_cnt, 4) from db.table1. > 1、Executes the SQL on project where has create a cube has db.table1,it will > throws the right side of the BinaryTuple Expressions columns is not supported > for / exception and is not queried through pushdown; > 2、When change a project where not create the table cube , the same query can > be executed to push down and get the right result. > 3. Expect that no matter whether a table cube is created or not, when the > cube query is not success, the result can still be obtained by pushdown > query, which will give users a consistent experience. > {code:java} > // exception > 2019-06-06 19:04:55,902 ERROR [http-bio-8081-exec-1] > controller.BasicController:63 : > org.apache.kylin.rest.exception.InternalErrorException: That the right side > of the BinaryTupleExpression owns columns is not supported for / > while executing SQL: "select DT,ORD_AMT/ORD_AMT from db.table1 LIMIT 5" > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:452) > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:373) > at > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87) > 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.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > at > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) > at > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > at > org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) > 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 >
[jira] [Commented] (KYLIN-4047) Use push-down query when division dynamic column cube query is not supported
[ https://issues.apache.org/jira/browse/KYLIN-4047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16865443#comment-16865443 ] ASF GitHub Bot commented on KYLIN-4047: --- wangxiaojing123 commented on pull request #689: KYLIN-4047 Use push-down query when division dynamic column cube query is not supported URL: https://github.com/apache/kylin/pull/689 Scene: SQL:select round (car_dismatch_cnt*100/answer_order_cnt, 4) from db.table1. - 1、Executes the SQL on a project where its cube has db.table1,it will throws the right side of the BinaryTuple Expressions columns is not supported for / exception and is not queried through pushdown; - 2、When change a project where not create the table cube , the same query can be executed to push down and get the right result. - 3、 Expect that no matter whether a table cube is created or not, when the cube query is not success, the result can still be obtained by pushdown query, which will give users a consistent experience. This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Use push-down query when division dynamic column cube query is not supported > > > Key: KYLIN-4047 > URL: https://issues.apache.org/jira/browse/KYLIN-4047 > Project: Kylin > Issue Type: Improvement > Components: Query Engine >Affects Versions: Future, v2.6.2, v3.0.0-alpha >Reporter: wangxiaojing >Priority: Minor > > Hello all , > At present, if a table has created cube, the query with division > dynamic column will throw an exception without pushdown query results, but if > switching an project, pushdown query will be carried out, which will give > users inconsistent experience. Can we also use pushdown query when query > division, multiplication dynamic column throw exceptions ? > Scene: > SQL:select round (car_dismatch_cnt*100/answer_order_cnt, 4) from db.table1. > 1、Executes the SQL on project where has create a cube has db.table1,it will > throws the right side of the BinaryTuple Expressions columns is not supported > for / exception and is not queried through pushdown; > 2、When change a project where not create the table cube , the same query can > be executed to push down and get the right result. > 3. Expect that no matter whether a table cube is created or not, when the > cube query is not success, the result can still be obtained by pushdown > query, which will give users a consistent experience. > {code:java} > // exception > 2019-06-06 19:04:55,902 ERROR [http-bio-8081-exec-1] > controller.BasicController:63 : > org.apache.kylin.rest.exception.InternalErrorException: That the right side > of the BinaryTupleExpression owns columns is not supported for / > while executing SQL: "select DT,ORD_AMT/ORD_AMT from db.table1 LIMIT 5" > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:452) > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:373) > at > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87) > 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.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > at > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) > at >