Connecting to Cloudera via HIVE JDBC

Teradata Studio
Highlighted
Enthusiast

Connecting to Cloudera via HIVE JDBC

 

Hi.

 

I want to use TD Studio to connect/query our Cloudera via Hive JDBC.

But connection via Hive is disabled in TD Studio v16.10.

Is there a way to enable this?

There are other open-source query tools, i.e. DBeaver, with which I was able to do this.

My colleagues are already used to TD Studio.

 

Rommel


Accepted Solutions
Teradata Employee

Re: Connecting to Cloudera via HIVE JDBC

Studio has added Cloudera Hive support in its upcoming 16.20 release. Currently only Cloudera Impala and Presto are supported for JDBC connections.

1 ACCEPTED SOLUTION
7 REPLIES 7
Teradata Employee

Re: Connecting to Cloudera via HIVE JDBC

Studio has added Cloudera Hive support in its upcoming 16.20 release. Currently only Cloudera Impala and Presto are supported for JDBC connections.

Enthusiast

Re: Connecting to Cloudera via HIVE JDBC

 

Thanks Francine!

 

On related note, can I change the Hive JDBC version currently available for HDP?

Ours is 1.2.1.

Enthusiast

Re: Connecting to Cloudera via HIVE JDBC

 

Upgraded to TD Studio v16.20.  Can now connect to Hive Cloudera.

Though a couple of sql editors are missing such as EXECUTE highlighted SQL only and block comments are not accepted.

 

Rommel

Re: Connecting to Cloudera via HIVE JDBC

can anyone please share the steps to setup Connecting to Cloudera via HIVE JDBC on Teradata Studio Version: 16.20.05

Re: Connecting to Cloudera via HIVE JDBC

so I just noticed i have Teradata Studio Express 16.20 which is a slim version of TD Studio 16 ...

and Studio Express does not support ClouderaHive ...would have to wait for future release i guess ...

any thoughts ? ? ?

Teradata Employee

Re: Connecting to Cloudera via HIVE JDBC

Even with Studio Express if I open the "New Connection Profile" dialog, select Hadoop, and click Next, I have the option for Cloudera via Hive.

Re: Connecting to Cloudera via HIVE JDBC

Yes Fred it’s there but isn’t working
Getting an invalid status 21 error