CODEWITHSUNDEEP
hadoopclouderaimpaladatagrip
HappyCanine
HappyCanine

Reputation: 13

Connecting DataGrip to Hadoop (Cloudera 6) Impala through ODBC

could anyone help me set up a connection in DataGrip to Hadoop Impala? I know DataGrip doesn't directly support ODBC but perhaps a workaround or just something I've missed googling - JDBC?

Using DataGrip 2021.3.1

Here's my DSN-less connection string:

Driver=Cloudera ODBC Driver for Impala;Host=ap-cdpdn10p.oneadr.net;Port=21050;AuthMech=1;KrbRealm=ONEADR.NET;KrbFQDN=impala.cdpoe.prod.oneadr.net;KrbServiceName=impala;SSL=1;UseSystemTrustStore=1;ServicePrincipalCanonicalization=0;AllowSelfSignedServerCert=1

Upvotes: 0

Views: 1346

Answers (1)

Yuri Win
Yuri Win

Reputation: 1458

First, please read this article

In DataGrip there is Hive driver embedded, according to the article it should work. If it does not, you can try this one from Cloudera, for example.

Upvotes: 1

Related Questions