Reply
New Contributor
Posts: 10
Registered: ‎06-10-2017

Oracle SQL Developer connects to HIVE

Hello,

 

I would like to connect Oracle SQL developer tool to apache HIVE. so i have downloaded JDBC drives from cloudera and added in SQLdevloper tool. Now i able to see HIVE tab in tool.

 

Here i can pass Hostname and database name (default) and i am looking for Port number. How can i find the Apache HIVE port (not cloudera HIVE).

 

I have added following in entry hive-site.xml file.

 

/*

<property>
   <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:derby:;databaseName=/home/student/hive/apache-hive-1.2.2-bin/warehouse/metastore_db;create=true</value>
</property>

*/

Hive_db.jpg

Refer above scree shot, where i have added HIVE tab in oracle sqldeveloper.

Highlighted
Posts: 11
Topics: 0
Kudos: 1
Solutions: 0
Registered: ‎06-14-2017

Re: Oracle SQL Developer connects to HIVE

HOST and PORT should target an active "HiveServer2" rôle.

The default port is likely to be 10000.

As for the host, well it depends on your cluster.

Announcements