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>
Refer above scree shot, where i have added HIVE tab in oracle sqldeveloper.
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.