天天看點

impyla查詢結果傳回字典dict

from impala.dbapi import connect
conn = connect(host='*.*.*.*', user='**', password='**', port=21050, database='**')
#conn.cursor預設傳回元組,而将dictify設定為True可傳回字典
cur = conn.cursor(dictify=True)
cur.execute('select * from table2')
data_list = cur.fetchall()
for data in data_list:
    print(data)
           

如果這個回答解決了您的問題,請點個贊吧~