pyhive-presto-sample.py

from pyhive import presto
import requests
from requests.auth import HTTPBasicAuth
import pandas as pd
requests.packages.urllib3.disable_warnings()

req_kw = {
    'auth': HTTPBasicAuth('the-user', 'the-password'),
    'verify': '/path/to/cert.pem',
}

conn = presto.connect(
    host='your-presto-host.net',
    port=8080,
    protocol='https',
    catalog='the-catalog',
    schema='the-schema',
    username='the-user',
    requests_kwargs=req_kw,
)

query = """
select
  user_id as id,
  user_name as name
from
  users
where
  user_id <= 100"""

col = ['id', 'name']
cursor  = conn.cursor()
cursor.execute(query)
df = pd.DataFrame(cursor.fetchall(), columns=col)
print(df)
cursor.close()