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);