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?
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!
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"
SELECT CAST(SUBSTR(TimeOfEvent, 1, 19) AS TIMESTAMP) AS ConvertedTimeOfEvent, * FROM xxxxx_presto.xxxxxxx_windows
( 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))
Custer size: 3 node
Data : 1 day approximately 200 records
timeofevent | varchar
eventid | varchar |
xxxxxxx | varchar |
xxxxxxxx | varchar(20) |
year | varchar |
month | varchar |
day | varchar |
hour | varchar |
minute | varchar |
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!