kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ANIL KUMAR (JIRA)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-3736) Disable Tableau Probing Queries
Date Sat, 22 Dec 2018 15:45:00 GMT
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)

Mime
View raw message