Forum Discussion
dpontes
3 years agoNew Member
(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 sudde...
dpontes
3 years agoNew Member
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
Super User
3 years agoHey 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.