Connecting Hive with Python

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.

Working with Python in Mac

How to install and work with Python in mac?

Step 1:

Step 2: How to install missing module?
On bottom left side of PyCharm, click on computer icon and choose terminal.
select package in import statement. Press Alt+Enter, choose install package.
>sudo easy_install pip
Search for package here
>sudo pip install package_name