[native] Add a Presto connector to query Prestissimo metrics with SQL queries.

prestodb / presto

The official home of the Presto distributed SQL query engine for big data

http://prestodb.io

Apache License 2.0

15.89k stars 5.32k forks source link

[native] Add a Presto connector to query Prestissimo metrics with SQL queries. #21649

Open aditi-pandit opened 8 months ago

aditi-pandit commented 8 months ago

Presto java has a JMX connector to query Presto node metrics in SQL queries. This is very useful in monitoring system health. https://prestodb.io/docs/0.284/connector/jmx.html?highlight=jmx%20connector

Native engine doesn't have JMX metrics. But there are other efforts for metrics collection in Native engine. Exposing these via catalog tables would really help as well.

aditi-pandit commented 8 months ago

@karteekmurthys

tdcmeehan commented 8 months ago

It would be nice to somehow generalize the JMX connector to a metrics connector. That way you could additionally query coordinator metrics, which include aggregate cluster-wide metrics, without having to add a separate catalog.