Python - Error connecting to Hive using JayDeBeApi

Question

I am trying to connect Hive in Hortonworks using JayDeBeApi inside the Python script. I've installed Python 64 bit and setup with PyCharm IDE. I've installed JayDeBeApi as well. I am getting the following error and not sure what I am missing.

    C:\Python27\python.exe C:/Projects_Work/primex/tableau/TDEConnect.py
    Opening connection.....
    Traceback (most recent call last):
    File "C:/Projects_Work/primex/tableau/TDEConnect.py", line 47, in <module>
main()
    File "C:/Projects_Work/primex/tableau/TDEConnect.py", line 19, in main
with connect() as conn:
    File "C:/Projects_Work/primex/tableau/TDEConnect.py", line 30, in __enter__
{'user': sslUser, 'password': sslPassword}, driverPath, )
    File "C:\Python27\lib\site-packages\jaydebeapi\__init__.py", line 381, in connect
    jconn = _jdbc_connect(jclassname, url, driver_args, jars, libs)
    File "C:\Python27\lib\site-packages\jaydebeapi\__init__.py", line 159, in _jdbc_connect_jpype
    import jpype
    File "C:\Python27\lib\site-packages\jpype\__init__.py", line 17, in <module>
from ._jpackage import *
    File "C:\Python27\lib\site-packages\jpype\_jpackage.py", line 18, in <module>
    import _jpype

    ImportError: DLL load failed: %1 is not a valid Win32 application.

    Process finished with exit code 1

Any input would be great. Thanks.

Answer 1

JayDebeApi contain JPype for run Java Class from Python. Is necesary to have installed C++ Compiler for Python before installing JayDebeApi

Windows

• Visual Studio 2008 for Python 2.7. See: https://docs.python.org/2.7/using/windows.html#compiling-python-on-windows

• Visual Studio 2010 for Python 3.4. See: https://docs.python.org/3.4/using/windows.html#compiling-python-on-windows

Answer 2

Alternatively, you can get the Jpype wheel directly (if for auth reasons you can't get C++ dev suit installed)

jpype wheel files