KNOWLEDGE BASE

Error "Unknown type: TEXT" When Running a Flow


Published: 03 Jun 2022
Last Modified Date: 03 Jun 2022

Issue

When running a flow, the following error may occur:

System error: AqlProcessor evaluation failed: Query failed (#<...>): line x:x: Unknown type: TEXT)

Environment

  • Tableau Server
  • Tableau Prep Builder 
  • JDBC
  • Trino server

Resolution

Use the named Presto connector, not the generic Other Databases (JDBC) connector, to connect to your Trino server. For more information about using the Presto connector, see this document.

Cause

The Other Databases (JDBC) connector is not optimized for any particular data source type.
Did this article resolve the issue?