question Re: Installing Impala ODBC Driver on a CML Project - Running as sudo in CML in Support Questions

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

ipson — Thu, 26 Sep 2024 15:26:14 GMT

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?

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

DianaTorres — Thu, 26 Sep 2024 21:01:54 GMT

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

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

mszurap — Mon, 30 Sep 2024 07:58:58 GMT

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

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

ipson — Tue, 01 Oct 2024 11:46:10 GMT

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