Hi, Couple of questions: 1. why you need to use impyla to connect to Hive? Impyla is designed for Impala, not Hive. 2. is port 9443 the correct port for Hive? 3. have you checked on the HiveServer2 log to see what is reported there? Cheers Eric ... View more

Thanks, it works! ... View more

[cloudera-cdh5] # Packages for Cloudera's Distribution for Hadoop, Version 5, on RedHat or CentOS 7 x86_64 name=Cloudera's Distribution for Hadoop, Version 5 baseurl=https://archive.cloudera.com/cdh5/redhat/7/x86_64/cdh/5/ gpgkey =https://archive.cloudera.com/cdh5/redhat/7/x86_64/cdh/RPM-GPG-KEY-cloudera gpgcheck = 1 [cloudera-impala] name=Impala baseurl=http://archive.cloudera.com/impala/redhat/6/x86_64/impala/1/ gpgkey = http://archive.cloudera.com/impala/redhat/6/x86_64/impala/RPM-GPG-KEY-cloudera gpgcheck = 1 we used this on our Centos 7 but it was for Centos 6 only Refer this link  https://www.cloudera.com/documentation/enterprise/latest/topics/cdh_ig_cdh5_install.html#topic_4_4_1__p_32 Hi above link for Centos 7     $ sudo yum install impala $ sudo yum install impala-server $ sudo yum install impala-state-store $ sudo yum install impala-catalog ... View more