Trino Supported Connectors

The following connectors are currently supported:

MySQL
MariaDB
PostgreSQL
Hive

If Hive is enabled in the ODP cluster, it will be automatically configured by the Trino Mpack.

For all other connectors, you need to manually enable and configure them during service installation by providing the necessary connection details.

MySQL

MariaDB

PostgreSQL

If PostgreSQL is enabled, the specific database to connect to must be specified in the postgresql_database configuration.

Hive

Hive 4.x ACID - Trino Support from ODP 3.3.6.3-101 onwards

Trino does not natively support read and write operations on Hive ACID tables. Custom fix has been applied to handle it for Hive4.x with Trino as the query engine.

This behavior was additionally validated using a non-transactional table, where data written from Trino was readable from Hive as expected.

To enable this functionality with Hive 4.0.1, an additional patch was required on Trino.

Trino Hive ACID Table Operations Example

Examples of INSERT, UPDATE, DELETE, and MERGE on transactional Hive tables in Trino.

Create ACID Table

SQL:

#MANDATORY: Requires setting session to delegate transactional managed table location as provided to metastore for avoiding Illegal location for managed table, it has to be within database's managed location exceptions: SET SESSION hive.delegate_transactional_managed_table_location_to_metastore = true; CREATE TABLE hive.myaciddb.request_logs13 ( request_time TIMESTAMP ) WITH (transactional=true);

Last updated on Feb 4, 2026

Was this page helpful?