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:15:00 UTC
[jira] [Commented] (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 commented on KYLIN-3736:
-----------------------------------
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)