[ https://issues.apache.org/jira/browse/KYLIN-3736?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16892359#comment-16892359 ]
anil kumar commented on KYLIN-3736: ----------------------------------- because of these errors, tableau dashboard refresh lags some time around 2 to 3min ( only first time ). If we suppress these errors, the response time would be better when tableau connects to Kylin > 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.14#76016)