I would like to connect to Hive via Knox using JDBC connection in python. Please note that my cluster is secured and SSL is enabled and we use LDAP to Login to Hive via Knox.I am able to establish the connection to Hive using DbViz and JDBC driver of Hive. I had gone through a lot of links and haven't found any good examples as well as recommendations to connect hive using python.
Thank you in Advance,
Hey @J Koppole,
Steps to connect has been mentioned on JayDeBeApi link:
I am pasting sample code snippet below
import jaydebeapi; conn = jaydebeapi.connect("org.apache.hive.jdbc.HiveDriver","<hive_jdbc_url>",["<username>", "<password>"],"/path/to/hive-jdbc-uber-<version>.jar") curs = conn.cursor(); curs.execute("select * from some_table"); curs.close()