How to list all presto workers?

by dalton_moen , in category: MySQL , 2 months ago

How to list all presto workers?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by lottie , 2 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.