connections issues of presto to tableau

Connectivity
Fan

connections issues of presto to tableau

I am using Presto (0.152.1-T.0.3)  , Tableau (10.0) and Teradata Presto ODBC Driver (1.1.8).

While running extract query from Tableau to Presto views, Tableau is getting different resultset count. ( I am extracting yesterday data, so the data shouldn't change)

When I run the same query on presto-cli, I returns correct resultset count everytime.

Also, this issue is not consistent. Tableau displays different resultsets and sometimes correct resultset also.

Can somebody help me on this?

3 REPLIES
Teradata Employee

Re: connections issues of presto to tableau

Hello,

 

Thank you for the report. We never saw such issue before.

If you don't mind to provide a query that causes the issue, that might be helpful.

Btw. please use the Presto forum (http://community.teradata.com/t5/Presto/bd-p/Presto) for any Presto-related posts (including any follow-up on this issue). Thank you!

 

Best regards,

Kamil

 

 

 

Fan

Re: connections issues of presto to tableau

Query
SELECT "custom_sql_query"."Action" AS "action",
  "custom_sql_query"."ConvertedTimeOfEvent" AS "convertedtimeofeve",
  1 AS "number_of_records",
  "custom_sql_query"."xxxxx" AS "xxxxxx",
  "custom_sql_query"."xxxx" AS "xxxxx",
  "custom_sql_query"."day" AS "day",
  "custom_sql_query"."hour" AS "hour",
  "custom_sql_query"."minute" AS "minute",
  "custom_sql_query"."month" AS "month",
  "custom_sql_query"."year" AS "year"
FROM (
  SELECT CAST(SUBSTR(TimeOfEvent, 1, 19) AS TIMESTAMP) AS ConvertedTimeOfEvent, * FROM xxxxx_presto.xxxxxxx_windows
   WHERE
   ( eventid = 'xxxx' and year = cast(YEAR(DATE_ADD('day', -1, CURRENT_DATE)) as varchar) AND month = cast(MONTH(DATE_ADD('day', -1, CURRENT_DATE)) as varchar) AND day = cast(DAY(DATE_ADD('day', -1, CURRENT_DATE)) as varchar))
) "custom_sql_query"

Custer size: 3 node
Data : 1 day approximately 200 records

Table Definition
timeofevent                | varchar    
 eventid                    | varchar     |
 xxxxxxx                 | varchar     |
xxxxxxxx               | varchar(20) |
year                       | varchar     |
 month                      | varchar     |
 day                        | varchar     |
 hour                       | varchar     |
 minute                     | varchar     |

 

 

 

Teradata Employee

Re: connections issues of presto to tableau

Please see my response at http://community.teradata.com/t5/Presto/FW-connections-issues-of-presto-to-tableau/m-p/71273 and continue the discussion there. Thank you!