@frbelotto , a sample code to test connectivity from Python to Hive. from pyhive import hive
import logging
import os
logging.basicConfig(level=logging.DEBUG)
conn = hive.Connection(host="hs_host",port=10000,database='default')
cursor = conn.cursor()
cursor.execute("show databases")
res = cursor.fetchall()
print (res)
#connect = hive.Connection(host=db_host, port=db_port, username=db_user, password=db_password, database=db_name,auth='KERBEROS',kerberos_service_name='hive') make sure to install the below dependencies before running the code: pip3.8 install pyhive
pip3.8 install thrift
pip3.8 install thrift_sasl I hope this helps! Cheers!
... View more
