Python script to connect Hive Cluster

Need a python script to connect to Hive. 1) Need different implementations using pyhive, pyhs2 ,ThriftHive and pandas 2) Hive is on hdfs and the hdfs servers are kerberos enabled(ssl/sasl).should use principle,keystores to connect hive. 3) can use the below information [login to view URL] 4) Need continuous integration and support until all the scripts works fine on cluster. 5) Develpment, deployment, knowldge trasfer, code enhancement(if required). 5) logging should be enabled using logging package 6)Should have sound knowledge on kerberos,ssl and should suggest the parameters to connect to hive from external system(using python).