在python3.6上访问impala数据库
- 安装impyla包
cmd: python3 -m pip install impyla
在安装的过程中可能会报出Microsoft Visual C++ 14.0 is required
按照提示的链接下载2015版,然后再重新安装就OK - 代码demo
from impala.dbapi import connect
from impala.util import as_pandas
conn = 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))
- 可能遇到的问题
ThriftPy does not support generating module with path in protocol ‘d’
解决办法:http://blog.csdn.net/dechengtju/article/details/61197641
http://blog.csdn.net/faith_mo_blog/article/details/46985287
https://stackoverflow.com/questions/32338006/write-pandas-table-to-impala