Why Teradata Presto ODBC Driver different version generated different query in Tableau

Presto
Visitor

Why Teradata Presto ODBC Driver different version generated different query in Tableau

Hi All,

 

 

I'm using Tableau version 10.2 with Teradata Presto ODBC driver 1.1.8 connected to Presto version 0.161-tx.
According to 7.3. ODBC Drivers — Teradata Distribution of Presto 0.167-t.0.2 Documentation  driver version 1.1.8 should support Presto version 0.157.1-t.x, 0.167-t.x .

Now I'm facing problem Presto Query Error due to tableau generated SQL that not support with presto (this problem happend when I used some function e.g. Fixed, Include, Exclude).

So I try figure out this problem then I found that changing Driver back to 1.1.4 can fix this problem, because tableau will generated different SQL Query.

 

I'm getting confused that how can I know that which driver version is more compatible with my Tableau version and Presto version because now old driver seems to work better than recommend version.

Thanks for your help.

 

 

-----------------------Fixed function working with driver version 1.1.4------------------------------

"SELECT ""t0"".""mkt_type"" AS ""mkt_type"",

""t1"".""x_measure__0"" AS ""sum_calculation_27""

FROM (

SELECT ""total_promotion_tw"".""mkt_type"" AS ""mkt_type""

FROM ""datamart"".""total_promotion_two_stores"" ""total_promotion""

GROUP BY 1

) ""t0""

CROSS JOIN (

SELECT SUM(""total_promotion"".""all_sales_2015"") AS ""x_measure__0"",

COUNT(1) AS ""x__alias__0""

FROM ""datamart"".""total_promotion_two_stores"" ""total_promotion""

HAVING (COUNT(1) > 0)

) ""t1"""

 

 

------------------------Fixed function doesn't work with driver version 1.1.8 -------------------------------------------

 

SELECT "t0"."mkt_type" AS "mkt_type",

"t1"."x_measure__0" AS "sum_calculation_51"

FROM (

SELECT "total_promotion_tw"."mkt_type" AS "mkt_type"

FROM "datamart"."total_promotion_two_stores" "total_promotion"

GROUP BY 1

) "t0"

JOIN (

SELECT SUM("total_promotion"."all_sales_2015") AS "x_measure__0",

COUNT(1) AS "x__alias__0"

FROM "datamart"."total_promotion_two_stores" "total_promotion"

HAVING (COUNT(1) > 0)

) "t1"



 

  • Presto
  • query
  • Tableu
1 REPLY
Teradata Employee

Re: Why Teradata Presto ODBC Driver different version generated different query in Tableau

Hi 
We do not have any 0.161-tx version released by Teradata. If you are trying to use open source version 0.161 then it will not work with Teradata ODBC drivers for Presto.

Here is a list of documentation for older releases http://teradata.github.io/presto/docs/current/versions.html
Newest release is called 0.167t and before that we had 0.157t 
Let us know if using the correct version of Presto works, you can download Teradata supported release and drivers from www.teradata.com/presto

thanks

Akshat