question Re: Not able to connect to hiveserver2 to access hivetables with python in Support Questions

question Re: Not able to connect to hiveserver2 to access hivetables with python in Support Questions https://community.cloudera.com/t5/Support-Questions/Not-able-to-connect-to-hiveserver2-to-access-hivetables-with/m-p/277226#M207496 <a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/69219">@ranger</a> Can you try something like this it explains how to connect Hive running on a remote host  (HiveSever2)  using commonly used Python package, Pyhive? There are a lot of other Python packages available to connect to remote Hive, but Pyhive package is one of the easy and well-maintained and supported packageHere I am assuming you installed already the Pyhive package if not please do that first! from phive import hive import re,os, time host_name = "localhost" port = 10001 user = "hive" password ="hive" database = "employeeDB" def hiveconnection(host_name, port, user,password, database):           conn = hive.Connection(host=host_name, port=port, username=user, password=password,           database=database, auth='CUSTOM')           cur = conn.cursor()           cur.execute('select * from employees returns limit 5')           result = cur.fetchall()          return result# Call above function output = hiveconnection(host_name, port, user,password, database) print(output) Before you attempt to connect using Pyhive you should execute the below steps to install the Pyhive package below are the step on an ubuntu machine as Pyhive is dependent on these Modules:Installing gccsudo apt-get install gccInstall Thriftpip install thrift+Install SASLpip install saslInstall thrift saslpip install thrift_sasl After the above steps have run successfully, you can go ahead and install Pyhive using pip:pip install pyhiveshould you encounter Pyhive sasl fatal error install the below dependencies.sudo apt-get install libsasl2-dev Now you can re-test your hive database connectionPlease let me know     Sat, 14 Sep 2019 12:37:30 GMT Shelton 2019-09-14T12:37:30Z