4/30/2024 0 Comments Actual odbc manager setup fileBut, you can also just specify a DSN name that PyODBC then maps to an entry in your $HOME/.odbc.ini file. For example, you could build up a DSN string in code in a Python program that you use to connect to Hive using PyODBC. Sudo yum install hive-odbc-native-2.-1.el7.x86_64.rpm 3) Create $HOME/.odbc.ini I can tell you that a college used this procedure on RHEL 6.4 and used the CentOS 6 driver and it worked fine. ![]() Also note that the below URL will likely change as new versions of the driver are released so it is a good idea to check the Hortonworks download page for the latest version when you run this procedure. If you are running an older version of the OS, then visit and use the CentOS 6 driver. Note that the following URL is for the CentOS 7 version of the driver. I developed this guide using the below version of the driver. Installation Steps 1) Install the UnixODBC Dependencies sudo yum install unixODBC 2) Download and Install Hortonworks ODBC Linux Driver While there seems to be some "reasonable" documentation other there on setting up this access from Windows, it took quite some time to figure out how to do this from Linux.įor this example, I am installing the Hortonworks Linux ODBC driver on CentOS Linux release then verifying it works using both the isql ODBC command line tool and PyODBC. ![]() This article outlines the steps needed to setup ODBC access to Hive via Apache Knox from a Linux workstation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |