python连接hive 、mysql样例

thriftpy2.protocol.exc.TProtocolException: No protocol version header 以上错误按照下方的代码例子可以解决$aut{h}_{m}echanism{=}^{\prime }PLAI{N}^{\prime }$

from impala.dbapi import connect conn=connect(host='hadoop03' ,port=10000 ,user='root' ,password='123456' ,database='test' ,auth_mechanism='PLAIN' ) cur=conn.cursor() cur.execute('show tables') data = cur.fetchall() for i in data: print(i) import pymysql db=pymysql.connect('localhost','root','123456','test',charset='utf8') cursor = db.cursor() cursor.execute('select * from a') data=cursor.fetchall() for i in data : print(i) db.close()