How to list all presto workers?

by dalton_moen , in category: MySQL , 5 months ago

How to list all presto workers?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by lottie , 5 months ago

@dalton_moen 

To list all Presto workers, you can typically use the command line interface for Presto's coordinator node. Here is a general outline of how you can achieve this:

  1. SSH into the machine hosting the Presto coordinator.
  2. Navigate to the directory where Presto is installed.
  3. Run the following command:
1
./presto-cli --server <COORDINATOR-IP>:<PORT> --catalog <CATALOG-NAME> --schema <SCHEMA-NAME> --execute "SELECT * FROM system.runtime.nodes;"


Replace the <COORDINATOR-IP>, <PORT>, <CATALOG-NAME>, and <SCHEMA-NAME> with your specific configuration.


This command should query the system runtime nodes table to list all Presto workers in your cluster. You should see a list of worker nodes along with information such as node ID, host, number of tasks, etc.


Please note that the exact command may vary depending on your Presto setup and version, so it's recommended to consult the Presto documentation for more information on how to list all workers in your specific environment.

Related Threads:

How to group time column into 5 second intervals and count rows using presto?
How to get latest 3 months records in presto sql?
How to return a list field in fastapi?
How to extend list in mysql with another list?
How to populate a drop-down list with list<string> using knockout.js?
How to deduplicate in presto?