You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Temple Zhou (Jira)" <ji...@apache.org> on 2019/11/07 02:22: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=16968868#comment-16968868 ]
Temple Zhou commented on KYLIN-3736:
------------------------------------
Hi [~akottisa] , I want to know how you suppress these errors ? Any code have you changed ?
BTW: I am trying to reproduce this issue but failed.:(
> 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
(v8.3.4#803005)