Collab and Presto

collab_presto.py

# First run this in top cell:  pip install pyhive
from pandas import read_sql
from pyhive import presto

presto_conn = presto.Connection(host="collab-cluster-hostname-m", schema="your_presto_schema", catalog="presto_catalog", port=8060, username ="presto")
presto_cursor = presto_conn.cursor()

# Query presto node
query = "select * FROM system.runtime.nodes"
query_result = read_sql(query, presto_conn) 
query_result)

# Query a table in the catalog
query = "select count(*) from mytable"
query_result = read_sql(query, presto_conn)   
query_result