目录
Anaconda 3.x 、Python3.x
链接presto 需要安装以下模块
conda install sasl
conda install thrift
conda install thrift-sasl
conda install PyHive
from sqlalchemy import *
from sqlalchemy.engine import create_engine
from sqlalchemy.schema import *
import pandas as pd
class Main():
def __init__(self):
pass
def test_presto_connect(self):
# Presto
# host是服务器ip,port是端口,hive指的是Presto的catalog,my_schema是hive的schema。
engine = create_engine('presto://ip:port/hive/parquet')
print(engine)
# 和一般pandas从数据库中读取数据无任何区别,分析师们应该非常熟悉了。
df = pd.read_sql("select * from table_name limit 10", engine)
print(df)
def test_presto_