需求:通过Anaconda3.6.7连接hive查询
步鄹:
下载pyhive
conda install pyhive
查询脚本
from pyhive import hive
conn = hive.Connection(host="IP", port=10000, username="hive")
cursor= conn.cursor()
cursor.execute('select * from db.table limit 10')
for result in cursor.fetchall():
print(result)