In production environment we need to connect with multiple Hive Instances.
Option 1: Use ODBC for Python.
This is not proved product to use.
Option 2: Use Pyhs2 driver.
This helps to connect to only one instance of Hive.
Stay away from connecting to Hive with Python in BigData production environment.
Better to decouple technology. Let Python write data to flat files. Load those files to Hive.