58.Impyla客户端连接Hive和Impala——Python

58.1 演示环境介绍

• CDH集群环境正常运行，非安全集群环境
• Anaconda已安装并配置环境变量
• pip工具能够正常安装Python包
• Python版本2.6 or 3
• CM和CDH版本：5.11.2
• RedHat：7.2

58.2 操作演示

• Impyla依赖包安装，Impyla所依赖的Python包：
  • six
  • bit_array
  • thrift (on Python 2.x) orthriftpy (on Python 3.x)
  • thrift_sasl
  • sasl
• 首先安装Impyla依赖的Python包
  • thrift的版本必须使用0.9.3，默认安装的为0.10.0版本，需要卸载后重新安装0.9.3版本，卸载命令pip uninstall thrift

[root@ip-186-32-11-88 ~]# pip install bit_array
[root@ip-186-32-11-88 ~]# pip install thrift==0.9.3
[root@ip-186-32-11-88 ~]# pip install six
[root@ip-186-32-11-88 ~]# pip install thrift_sasl
[root@ip-186-32-11-88 ~]# pip install sasl

• 安装Impyla包
  • impyla版本，默认安装的是0.14.0，需要将卸载后安装0.13.8版本

 [root@ip-186-32-11-88 ec2-user]# pip install impyla==0.13.8
Collecting impyla
  Downloading impyla-0.14.0.tar.gz (151kB)
    100% |████████████████████████████████| 153kB 1.0MB/s 
Requirement already satisfied: six in /opt/cloudera/parcels/Anaconda-4.2.0/lib/python2.7/site-packages (from impyla)
Requirement already satisfied: bitarray in /opt/cloudera/parcels/Anaconda-4.2.0/lib/python2.7/site-packages (from impyla)
Requirement already satisfied: thrift in /opt/cloudera/parcels/Anaconda-4.2.0/lib/python