prestodb_connect_and_execute_basic_query.py

1import prestodb
2
3# Establish a connection to the Presto server
4conn = prestodb.dbapi.connect(
5    host='localhost',
6    port=8080,
7    user='the-user',
8    catalog='the-catalog',
9    schema='the-schema',
10)
11
12# Create a cursor object to execute queries
13cur = conn.cursor()
14
15# Execute a SQL query
16cur.execute('SELECT * FROM system.runtime.nodes')
17
18# Fetch and print the results
19rows = cur.fetchall()
20for row in rows:
21    print(row)