Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Oracle SQL Developer connects to HIVE

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.


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.

Don't have an account?
Coming from Hortonworks? Activate your account here