Connecting Hive with Python

In production environment we need to connect with multiple Hive Instances.

Option 1: Use ODBC for Python.
https://github.com/mkleehammer/pyodbc
This is not proved product to use.

Option 2: Use Pyhs2 driver.
https://cwiki.apache.org/confluence/display/Hive/Setting+Up+HiveServer2#SettingUpHiveServer2-PythonClientDriver
This helps to connect to only one instance of Hive.

Conclusion:
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:
https://www.jetbrains.com/pycharm/download/#section=mac

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 https://pypi.python.org/pypi
>sudo pip install package_name