Configure ODP Trino

This page helps you enable Trino JMX and configure the Pulse event listener so Pulse can collect metrics and display Trino query statistics.

• Pulse hook JARs are included in the installation package.

• To enable query statistics in Pulse, configure the Trino event listener.

• Trino’s event listener framework allows custom plugins to respond to query lifecycle events for advanced logging, debugging, and performance monitoring.

• The supported events are query creation and query completion.

• Each event provides session details, execution metrics, resource usage, and timelines.

Enable Trino JMX

In the Ambari UI:

1. Navigate to Trino > Configs > Advanced config-properties.

2. In Coordinator Node Config and Worker Node Config, add the following parameters at the end of the file:

Place Trino Hook JAR

1. In the Trino node, navigate to the Trino plugin folder.

In the folder:

2. Create the event listener directory.

Create the following directory:

3. Place the Trino Hook JAR in the directory.

Hook JAR:

In the directory:

4. Create the event-listener.properties file.

If not already present, create the file in the directory:

5. Add the following properties.

In the event-listener.properties file, add the properties:

Replace <your-cluster-name> and <Pulse-IP> with actual values from your environment.

6. Configure the plugin directory path.

If not already set, add the following line:

To the node.properties file:

7. Restart the Trino coordinator server.

All configurations must be applied to the Trino coordinator server.

Result

• Trino exposes JMX metrics on the configured port.

• Trino hook emits execution events to Pulse.