[
https://issues.apache.org/jira/browse/KYLIN-3736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
anil kumar updated KYLIN-3736:
------------------------------
Description:
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.
was:
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.
> 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.3#76005)
