Support Questions

Find answers, ask questions, and share your expertise

Installing Impala ODBC Driver on a CML Project - Running as sudo in CML

avatar
Contributor

I want to establish an ODBC connection to my Impala data warehouse in a CML project. I'm running a CML session and have configured my odbc.ini and odbcinst.ini files, but I need to install the driver. Everything I see here https://www.cloudera.com/downloads/connectors/impala/odbc/2-7-2.html describes installing it via the installation wizard.

Since CML runs a linux pod, I tried downloading the .deb file for the ODBC driving and then executing `dpkg clouderaimpalaodbc_2.7.2.1011-2_amd64.deb` but it has to be as root. If I run `su` it asks for a password. I'm not sure how this password gets generated by the system. I tried my workload password and portal password but neither worked.

Is there a more principled way of connecting via ODBC in CML or is there a way to run as root in CML?

3 REPLIES 3

avatar
Community Manager

@Chella @ChethanYM @mszurap Hi! Do you have any insights here? Thanks


Regards,

Diana Torres,
Community Moderator


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community:

avatar

Hi @ipson , please see the CML docs:

https://docs.cloudera.com/machine-learning/1.5.4/import-data/topics/ml-access-cdw-from-cml.html 

which suggests to use Impyla:

https://github.com/cloudera/impyla 

This does not require the ODBC driver to be installed.

Cheers, Miklos

avatar
Contributor

Thanks, but the reason I'm trying to establish an ODBC connection is because I'm using R.