E-MapReduce (EMR) Trino ships with preconfigured built-in connectors and supports adding custom connectors through placeholder connector slots. This topic describes the available built-in connectors, how to modify their configuration, and how to add a custom connector.
Built-in connectors
EMR Trino includes the following built-in connectors:
| Connector | Description | Reference |
|---|---|---|
| Hive | Query data in Hive data warehouses. | Hive connector |
| Kudu | Query, insert, and delete data in Kudu. | Kudu connector |
| MySQL | Query tables in an external MySQL instance and create tables. | MySQL connector |
| Iceberg | Query data files in Iceberg format. | Iceberg connector |
| Hudi | Query data in Copy on Write (COW) and Merge on Read (MOR) tables. | Hudi connector |
| Delta | Query data in Delta Lake tables. | Delta connector |
| JMX | Perform system monitoring and debugging. | JMX connector |
| system | Query basic cluster information and metrics. No configuration required — all data is accessible from the system directory. |
— |
Modify a built-in connector
Each built-in connector has a dedicated configuration file in the Trino service. The following table maps connectors to their configuration files:
| Connector | Configuration file |
|---|---|
| Hive | hive.properties |
| Kudu | kudu.properties |
| MySQL | mysql.properties |
| Iceberg | iceberg.properties |
| Hudi | hudi.properties |
| Delta | delta.properties |
| JMX | jmx.properties |
| system | system.properties |
The following example shows how to modify the Hive connector configuration.
-
Go to the Trino service page in the EMR console, click the Configure tab, and then click the hive.properties tab.
-
Modify the configuration items based on your requirements. For details on editing configuration items, see Manage configuration items.
-
Save the configuration, then choose More > Restart in the upper-right corner of the Services tab.
The connector becomes available after the service restarts.
Add a custom connector
EMR Trino provides five placeholder connector slots — connector1 through connector5 — for adding custom connectors. Each slot has a corresponding configuration file (connector1.properties through connector5.properties). Configuring a placeholder connector follows the same steps as modifying a built-in connector.
Prerequisites
Before you begin, ensure that you have:
-
EMR V3.27.0, EMR V4.3.0, EMR V5.2.0, or a later minor version
Add a custom connector
To add a custom connector, configure any unoccupied placeholder connector slot.
The following example adds a MongoDB connector using the connector1 slot.
-
Go to the Trino service page in the EMR console, click the Configure tab, and then click the connector1.properties tab.
-
Set connector.name to mongodb.
-
Add custom configuration items based on your business requirements. For instructions on adding configuration items, see Modify configuration items.
-
Save the configuration, then choose More > Restart in the upper-right corner of the Services tab.
The connector becomes available after the service restarts.