You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@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)