Connect to Hive using Pyhive

Question

I have installed HDP 2.5 Sandbox on my windows system. I want to access Hive running on Sandbox using Python (to be specific "pyhive" library).

I am able to login to the HDP. The IP address is 127.0.0.1. I have installed pyhive library. However, I am unable to connect from system to Sandbox from python.

Can you suggest what to do?

Answer 1

Here's how we can connect to Hive using pyhive

from pyhive import hive
import pandas as pd

#Create Hive connection 
conn = hive.Connection(host="127.0.0.1", port=10000, username="username")

# Read Hive table and Create pandas dataframe
df = pd.read_sql("SELECT * FROM db_Name.table_Name limit 10", conn)
print(df.head())