Read hive table with a python script

[#1]

Hello, Please I want to read a hive table from a python script. Can you help me please? My cordial thanks

[#2]

Here is a good doc to explain how to access hive through python.

https://cwiki.apache.org/confluence/display/Hive/HiveClient#HiveClient-Python

[#3]

Hi @alain TSAFACK can you please share what other way you found? It will help all members also in future.

[#4]

How about trying this: https://cwiki.apache.org/confluence/display/Hive/Setting+Up+HiveServer2#SettingUpHiveServer2-PythonC...

[#5]

How do we connect. when kerberos is enabled?

[#6]

Hi @vasanath rajendran check out this article https://community.hortonworks.com/questions/58096/is-there-a-working-python-hive-library-that-connec...

[#7 · Accepted solution]

Hello !

Thank you very much for your suggestions. These methods have worked and I found another very suitable method is that of using the dataframe .

Cordially

[#8]

We use kerberos authentication process. How to connect to hive server2 from python? Any help is highly appreciated.