Support Questions
Find answers, ask questions, and share your expertise

Oracle SQL Developer connects to HIVE

Explorer

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.

1 REPLY 1

Explorer

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.