prestodb_python_client_connection_and_basic_sql_query.py

1import prestodb
2
3conn = prestodb.dbapi.connect(
4    host='localhost',
5    port=8080,
6    user='the-user',
7    catalog='the-catalog',
8    schema='the-schema',
9)
10cur = conn.cursor()
11cur.execute('SELECT * FROM system.runtime.nodes')
12rows = cur.fetchall()
13
14for row in rows:
15    print(row)