You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "anil kumar (JIRA)" <ji...@apache.org> on 2019/07/25 02:22:00 UTC
[jira] [Comment Edited] (KYLIN-3736) Disable Tableau Probing
Queries
[ 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:21 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 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)
was (Author: akottisa):
Any
> 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)