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 2018/12/22 15:45:00 UTC

[jira] [Created] (KYLIN-3736) Disable Tableau Probing Queries

ANIL KUMAR created KYLIN-3736:
---------------------------------

             Summary: Disable Tableau Probing Queries
                 Key: KYLIN-3736
                 URL: https://issues.apache.org/jira/browse/KYLIN-3736
             Project: Kylin
          Issue Type: Bug
            Reporter: ANIL KUMAR


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

 

These are *TablueTestQueries* in *QueriesUtil.java* in Utility classes

 

Regards,

Anilkumar.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)