@ranger 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 package Here 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 gcc sudo apt-get install gcc Install Thrift pip install thrift+ Install SASL pip install sasl Install thrift sasl pip install thrift_sasl After the above steps have run successfully, you can go ahead and install Pyhive using pip: pip install pyhive should you encounter Pyhive sasl fatal error install the below dependencies. sudo apt-get install libsasl2-dev Now you can re-test your hive database connection Please let me know
... View more
