[jira] [Updated] (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:all-tabpanel
]
nichunen updated KYLIN-4047:
Fix Version/s: (was: v3.0.0-beta)
v3.0.0-alpha2
> 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: v3.0.0-alpha2, 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
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
> at
[jira] [Updated] (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:all-tabpanel
]
nichunen updated KYLIN-4047:
Fix Version/s: v3.0.0-beta
> 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: v3.0.0-beta, 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
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
> at
>
[jira] [Updated] (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:all-tabpanel
]
nichunen updated KYLIN-4047:
Fix Version/s: v2.6.4
> 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
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
> at
>
