[
https://issues.apache.org/jira/browse/KYLIN-3736?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16892357#comment-16892357
]
anil kumar edited comment on KYLIN-3736 at 7/25/19 2:26 AM:
------------------------------------------------------------
Any update on above issue to supress the probing queries. We are still facing
the issues in 2.6.3.
Because of these probing queries, when tableau connects kylin first time it is
taking time with below errors.
Sample error as below
==========================[QUERY]===============================
SQL: CREATE LOCAL TEMPORARY TABLE
"XT01_10E45A58_0180_4BED_BEAF_DD08E982DEA5_1_Connect" ( "COL" INTEGER ) ON
COMMIT PRESERVE ROWS
==========================[QUERY]===============================
2019-07-24 21:02:23,985 ERROR [Query 7f01d690-7b0f-a5e2-ac31ce2b04b5-83]
conv.SqlConverter:60 : Failed to default convert sql, will use the input:
CREATE LOCAL TEMPORARY TABLE
"XT01_10E45A58_0180_4BED_BEAF_DD08E982DEA5_1_Connect" ( "COL" INTEGER ) ON
COMMIT PRESERVE ROWS
org.apache.calcite.sql.parser.SqlParseException: Encountered "CREATE" at line
1, column 1.
Was expecting one of:
"SET" ...
"RESET" ...
"ALTER" ...
"WITH" ...
"+" ...
"-" ...
"NOT" ...
"EXISTS" ...
<UNSIGNED_INTEGER_LITERAL> ...
<DECIMAL_NUMERIC_LITERAL> ...
<APPROX_NUMERIC_LITERAL> ...
<BINARY_STRING_LITERAL> ...
<PREFIXED_STRING_LITERAL> ...
<QUOTED_STRING> ...
<UNICODE_STRING_LITERAL> ...
"TRUE" ...
"FALSE" ...
"UNKNOWN" ...
"NULL" ...
<LBRACE_D> ...
<LBRACE_T> ...
<LBRACE_TS> ...
"DATE" ...
"TIME" ...
"TIMESTAMP" ...
"INTERVAL" ...
"?" ...
"CAST" ...
"EXTRACT" ...
"POSITION" ...
"CONVERT" ...
"TRANSLATE" ...
"OVERLAY" ...
"FLOOR" ...
"CEIL" ...
"CEILING" ...
"SUBSTRING" ...
"TRIM" ...
"CLASSIFIER" ...
"MATCH_NUMBER" ...
"RUNNING" ...
"PREV" ...
"NEXT" ...
<LBRACE_FN> ...
"MULTISET" ...
"ARRAY" ...
"PERIOD" ...
"SPECIFIC" ...
<IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ...
<BRACKET_QUOTED_IDENTIFIER> ...
<UNICODE_QUOTED_IDENTIFIER> ...
"ABS" ...
"AVG" ...
"CARDINALITY" ...
"CHAR_LENGTH" ...
"CHARACTER_LENGTH" ...
"COALESCE" ...
"COLLECT" ...
"COVAR_POP" ...
"COVAR_SAMP" ...
"CUME_DIST" ...
"COUNT" ...
"CURRENT_DATE" ...
"CURRENT_TIME" ...
"CURRENT_TIMESTAMP" ...
"DENSE_RANK" ...
"ELEMENT" ...
"EXP" ...
"FIRST_VALUE" ...
"FUSION" ...
"GROUPING" ...
"HOUR" ...
"LAG" ...
"LEAD" ...
"LAST_VALUE" ...
"LN" ...
"LOCALTIME" ...
"LOCALTIMESTAMP" ...
"LOWER" ...
"MAX" ...
"MIN" ...
"MINUTE" ...
"MOD" ...
"MONTH" ...
"NTILE" ...
"NULLIF" ...
"OCTET_LENGTH" ...
"PERCENT_RANK" ...
"POWER" ...
"RANK" ...
"REGR_SXX" ...
"REGR_SYY" ...
"ROW_NUMBER" ...
at
org.apache.kylin.sdk.datasource.framework.JdbcConnector.convertSql(JdbcConnector.java:87)
at
org.apache.kylin.query.pushdown.PushdownRunnerSDKImpl.convertSql(PushdownRunnerSDKImpl.java:92)
at
org.apache.kylin.query.util.PushDownUtil.tryPushDownQuery(PushDownUtil.java:116)
at
org.apache.kylin.query.util.PushDownUtil.tryPushDownNonSelectQuery(PushDownUtil.java:74)
at org.apache.kylin.rest.service.QueryService.update(QueryService.java:224)
at
org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:470)
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:429)
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:367)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93)
at sun.reflect.GeneratedMethodAccessor215.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
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
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
was (Author: akottisa):
Any update on above issue to supress the probing queries. We are still facing
the issues in 2.6.3.
Because of these probing queries, when tableau connects kylin first time it is
failing with below errors.
Sample error as below
==========================[QUERY]===============================
SQL: CREATE LOCAL TEMPORARY TABLE
"XT01_10E45A58_0180_4BED_BEAF_DD08E982DEA5_1_Connect" ( "COL" INTEGER ) ON
COMMIT PRESERVE ROWS
==========================[QUERY]===============================
2019-07-24 21:02:23,985 ERROR [Query 7f01d690-7b0f-a5e2-ac31ce2b04b5-83]
conv.SqlConverter:60 : Failed to default convert sql, will use the input:
CREATE LOCAL TEMPORARY TABLE
"XT01_10E45A58_0180_4BED_BEAF_DD08E982DEA5_1_Connect" ( "COL" INTEGER ) ON
COMMIT PRESERVE ROWS
org.apache.calcite.sql.parser.SqlParseException: Encountered "CREATE" at line
1, column 1.
Was expecting one of:
"SET" ...
"RESET" ...
"ALTER" ...
"WITH" ...
"+" ...
"-" ...
"NOT" ...
"EXISTS" ...
<UNSIGNED_INTEGER_LITERAL> ...
<DECIMAL_NUMERIC_LITERAL> ...
<APPROX_NUMERIC_LITERAL> ...
<BINARY_STRING_LITERAL> ...
<PREFIXED_STRING_LITERAL> ...
<QUOTED_STRING> ...
<UNICODE_STRING_LITERAL> ...
"TRUE" ...
"FALSE" ...
"UNKNOWN" ...
"NULL" ...
<LBRACE_D> ...
<LBRACE_T> ...
<LBRACE_TS> ...
"DATE" ...
"TIME" ...
"TIMESTAMP" ...
"INTERVAL" ...
"?" ...
"CAST" ...
"EXTRACT" ...
"POSITION" ...
"CONVERT" ...
"TRANSLATE" ...
"OVERLAY" ...
"FLOOR" ...
"CEIL" ...
"CEILING" ...
"SUBSTRING" ...
"TRIM" ...
"CLASSIFIER" ...
"MATCH_NUMBER" ...
"RUNNING" ...
"PREV" ...
"NEXT" ...
<LBRACE_FN> ...
"MULTISET" ...
"ARRAY" ...
"PERIOD" ...
"SPECIFIC" ...
<IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ...
<BRACKET_QUOTED_IDENTIFIER> ...
<UNICODE_QUOTED_IDENTIFIER> ...
"ABS" ...
"AVG" ...
"CARDINALITY" ...
"CHAR_LENGTH" ...
"CHARACTER_LENGTH" ...
"COALESCE" ...
"COLLECT" ...
"COVAR_POP" ...
"COVAR_SAMP" ...
"CUME_DIST" ...
"COUNT" ...
"CURRENT_DATE" ...
"CURRENT_TIME" ...
"CURRENT_TIMESTAMP" ...
"DENSE_RANK" ...
"ELEMENT" ...
"EXP" ...
"FIRST_VALUE" ...
"FUSION" ...
"GROUPING" ...
"HOUR" ...
"LAG" ...
"LEAD" ...
"LAST_VALUE" ...
"LN" ...
"LOCALTIME" ...
"LOCALTIMESTAMP" ...
"LOWER" ...
"MAX" ...
"MIN" ...
"MINUTE" ...
"MOD" ...
"MONTH" ...
"NTILE" ...
"NULLIF" ...
"OCTET_LENGTH" ...
"PERCENT_RANK" ...
"POWER" ...
"RANK" ...
"REGR_SXX" ...
"REGR_SYY" ...
"ROW_NUMBER" ...
at
org.apache.kylin.sdk.datasource.framework.JdbcConnector.convertSql(JdbcConnector.java:87)
at
org.apache.kylin.query.pushdown.PushdownRunnerSDKImpl.convertSql(PushdownRunnerSDKImpl.java:92)
at
org.apache.kylin.query.util.PushDownUtil.tryPushDownQuery(PushDownUtil.java:116)
at
org.apache.kylin.query.util.PushDownUtil.tryPushDownNonSelectQuery(PushDownUtil.java:74)
at org.apache.kylin.rest.service.QueryService.update(QueryService.java:224)
at
org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:470)
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:429)
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:367)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93)
at sun.reflect.GeneratedMethodAccessor215.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
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
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> Disable Tableau Probing Queries
> -------------------------------
>
> Key: KYLIN-3736
> URL: https://issues.apache.org/jira/browse/KYLIN-3736
> Project: Kylin
> Issue Type: Bug
> Reporter: anil kumar
> Priority: Major
>
> Hi Team,
>
> Is there a configuration property to disable Tableau Probing queries.
> Sometimes it is not necessary to probe SQL statements when Tableau publish
> the reports. These queries leads confusion and some sort of syntactical
> errors / exceptions.
>
> *sample query :*
> CREATE LOCAL TEMPORARY TABLE
> "XT01_11B3408A_5074_4E96_B7A9_2D4543569E63_1_Connect" ( "COL" INTEGER ) ON
> COMMIT PRESERVE ROWS
> DROP TABLE "XT01_11B3408A_5074_4E96_B7A9_2D4543569E63_1_Connect"
> SELECT 1 AS "COL"
> SELECT TOP 1 "COL" FROM ( SELECT 1 AS "COL" ) AS "CHECKTOP"
> SELECT "COL" FROM (SELECT 1 AS "COL") AS "CHECKTOP" LIMIT 1
> SELECT "SUBCOL" AS "COL" FROM ( SELECT 1 AS "SUBCOL" ) "SUBQUERY" GROUP BY 1
> *For example below query returns error like below*
> SELECT "SUBCOL" AS "COL" FROM ( SELECT 1 AS "SUBCOL" ) "SUBQUERY" GROUP BY 1
> ERROR [http-bio-XXXX-exec-7] controller.BasicController:62
> org.apache.kylin.rest.exception.InternalErrorException: group by 1????
>
> These are *TablueTestQueries* in *QueriesUtil.java* in Utility classes
>
> Regards,
> Anilkumar.
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
