Forum Discussion
(1070) Unknown Presto data type: timestamp(6)
Hi everyone! I have been using an ODBC connector to access my data in Trino. Suddenly, it stopped working with the attached error message.
I don't know why this error message appeared suddenly on a working connection already established and daily refreshed. I can change the date type of my columns that use timestamp(6) to date, or timestamp(0), but is impracticable on this moment.
Any suggestion of what could I do?
3 Replies
- collinq
Super User
Hi ,
This appears to me that this is coming from the Presto database itself. In this Presto list (Data Types — Presto 0.278.1 Documentation (prestodb.io)) I am wondering if you are using the Timestamp with TimeZone where it is using the "words" of the time zone instead of the number (ie. '2001-08-22 03:04:05.321 America/Los_Angeles' instead of just "'2001-08-22 03:04:05.321")
I know that Power BI won't accept text in a Date or Date/Time field. Perhaps the output data changed as well since you say that this is more current?
Hi!
The column "date" has a datetype "timestamp(6)" for a long time, and this not has been changed. No changes on data in Trino were made. My driver (treasure data presto odbc) is updated.- collinq
Hey dpontes ,
This is a tough one - is it possible that you ahve some NON-date data in one of the fields (an extra space, an odd character, etc). These are really tough to find but I have had that experience before in a SQL query.... Or, you could ask the Presto folks if they are seeing this issue or having other reports of a problem.
