python 访问 impala 示例

from impala.dbapi import connectfrom impala.util import as_pandasconn = connect(host='10.161.20.11', port=21050)cur = conn.cursor()cur.execute('SHOW TABLES')cur.execute('SELECT * FROM businfo')data = as_pandas(cur)print (data)print (type(data))

第一次执行报错了

按照这个方法解决了

http://blog.csdn.net/dechengtju/article/details/61197641

下面的链接是impala常用代码

http://blog.csdn.net/faith_mo_blog/article/details/46998941