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

Oracle SQL Developer connects to HIVE



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.






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

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.