Member since
12-14-2022
1
Post
0
Kudos Received
0
Solutions
02-23-2024
06:23 AM
Hi @Kropiciel To connect ODBC driver with multiple HiveServers, you can configure High Availability for Hive using LB, refer below doc for same. The use the LB hostname and port in the connection string https://docs.cloudera.com/cdp-private-cloud-base/7.1.9/configuring-apache-hive/topics/hive-ha-loadbalancer.html Let us know if this helps. As for the python connection use below code and check how it goes. CODE: --------- from sqlalchemy import create_engine #Input Information host = hive_hostname port = 10000 schema = schema_name table = table_name #Execution engine = create_engine(f'hive://{host}:{port}/{schema}') engine.execute(QUERY)
... View more