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
3 REPLIES
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