KNOWLEDGE BASE

Unexpected Error Query While Extracting Data From TRINO Using Other JDBC connector


Published: 14 Dec 2021
Last Modified Date: 15 Dec 2021

Issue

When connecting Tableau Desktop 2021.3 to TRINO datasource via a JDBC connector, this error appears while extracting the data:

"Unexpected Error
Query failed (#): line 2:27: Invalid EXTRACT field: EPOCH
Error Code: FAB9A2C5"


or

"Unexpected Error
Query failed (#): line 6:3: mismatched input '{'. Expecting: '#', <expression>
Error Code: FAB9A2C5"

Environment

  • Tableau Desktop 2021.3
  • Mac OSX (Other)

Resolution

  1. Use Presto connector
  2. Place the JDBC property files in /Users/<username>/Documents/My Tableau Repository/Datasources folder if there is any
  3. Name it as presto.properties

Note: The Trino driver only works in Tableau versions 2021.3, 2021.2.2, 2021.1.5, 2020.4.8, 2020.3.12, and above. If you are connecting to Trino, download the appropriate driver from the Trino page.
Did this article resolve the issue?