5

I want to get a list of all connected workers so that I can detect which worker is not working.

I tried select * from sys.node; but it doesn't work.

I'm using Presto 0.128.

soulmachine
  • 3,917
  • 4
  • 46
  • 56

1 Answers1

13

For 0.128 version, the sql should be this:

select * from system.runtime.nodes
Piotr Findeisen
  • 19,480
  • 2
  • 52
  • 82
袁安峰
  • 652
  • 6
  • 5