python 连接hive的包是什么

pip install sasl

pip install thrift

pip install thrift-sasl

pip install PyHive

from pyhive import hive   # or import hive

conn = hive.Connection(host='****', port=****, username='****', database='****')

cursor.execute(''SELECT * FROM my_awesome_data LIMIT 10'')

for i in range(****):

    sql = "INSERT INTO **** VALUES ({},'username{}')".format(value, str(username))

    cursor.execute(sql)

# 下面是官网代码：

from pyhive import presto  # or import hive

cursor = presto.connect('localhost').cursor()

cursor.execute('SELECT * FROM my_awesome_data LIMIT 10')

print(cursor.fetchone())

print(cursor.fetchall())

pip install six

pip install bit-array

pip install thriftpy

pip install sasl

pip install thrift-sasl

from impala.dbapi import connect

conn = connect(host ='****'，port = ****）

cursor = conn.cursor()

cursor.execute('SELECT * FROM mytable LIMIT 100')

print cursor.description   # 打印结果集的schema

results = cursor.fetchall()