202107291809 - 连接hive使用python

# -*- coding=utf-8 -*-
from impala.dbapi import connect as impylaConnect

master_host='192.168.1.17'
master_port=10000
master_authMechanism='PLAIN'
master_user=''
master_pass=''
master_database='app_abc'
conn = impylaConnect(host= master_host,port= master_port, auth_mechanism=master_authMechanism,user=master_user, password=master_pass,database=master_database)

cursor = conn.cursor()
cursor.execute('select * from tmp_001 limit 10')
for result in cursor.fetchall():
    print(result)
cursor.close()
conn.close()