How to get data from Hive to Python

You can get data from Hive to Python using the pyhive library. For example,

from pyhive import hive
import pandas as pd


conn=hive.Connection(host="your_host", port=10000, username="username", password="password", auth='LDAP',database='your_db')
df = pd.read_sql("select * from your_db.your_table limit 100", conn)