E-MapReduce (EMR) Presto includes a set of built-in connectors for querying data across Hive, Iceberg, Kudu, MySQL, and other sources. You can modify the configuration of any built-in connector, or add a custom connector using one of the five pre-configured placeholder connectors.
Built-in connectors
The following connectors are available out of the box in EMR Presto.
| Connector | Supported operations | Notes |
|---|---|---|
| hive | Query data in Hive data warehouses | |
| kudu | Query, insert, and delete data in Kudu | |
| mysql | Query data in tables in an external MySQL instance; create tables | |
| iceberg | Query data files in the Iceberg format | |
| hudi | Query data in Copy-on-Write (CoW) and Merge-on-Read (MoR) tables | |
| delta | Query data in Delta Lake tables | |
| jmx | System monitoring and debugging | |
| system | Query basic information and metrics of Presto clusters | No configuration needed. All information about the connector can be obtained from the system directory. |
Modify a built-in connector
Each built-in connector maps to a configuration file on the Configure tab of the Presto service page. Modify the properties in that file, then restart the Presto service to apply the changes.
| Connector | Configuration file |
|---|---|
| hive-hadoop2 | hive.properties |
| kudu | kudu.properties |
| mysql | mysql.properties |
| iceberg | iceberg.properties |
| hudi | hudi.properties |
| delta | delta.properties |
| jmx | jmx.properties |
Example: Modify the Hive connector
-
On the Presto service page in the EMR console, go to the Configure tab and click hive.properties.
-
Update the configuration items to match your requirements. For details on editing configuration items, see Manage configuration items.
-
After saving, choose More > Restart in the upper-right corner of the Services tab to restart Presto.
The connector becomes available after the restart completes.
Add a custom connector
EMR Presto includes five placeholder connectors — connector1 through connector5 — each backed by its own configuration file (connector1.properties through connector5.properties). Placeholder connectors are configured in the same way as built-in connectors.
To add a custom connector, pick an unoccupied placeholder and set its connector.name to the connector you want to use.
Example: Add a MongoDB connector
-
On the Presto service page in the EMR console, go to the Configure tab and click connector1.properties.
-
Set connector.name to mongodb.
-
Add custom configuration items based on your business requirements. For details on adding configuration items, see Modify configuration items.
-
After saving, choose More > Restart in the upper-right corner of the Services tab to restart Presto.