Forum Discussion

dpontes's avatar
dpontes
New Member
3 years ago

(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...
Need Help
collinq's avatar
collinq
Icon for Super User rankSuper User
3 years ago

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?

 

dpontes