While testing the connection if you get an error such as: on Hive from SQL Developer.įollowing additional steps are needed for Kerberos secured Cloudera clusters Test the connection if successful then Connect and you will see the Hive tables and will be able to run the SQL queries, import, export etc.Give a connection name, username in Hive or Hue such as hive, Hostname of the hiverserver2, Port default is 10000, Database: default.Tools -> Preferences -> Database -> Third party JDBC drivers again.
If the ‘Hive’ tab does not display next to the ‘Oracle’ tab it is likely that the Hive JDBC drivers did not install correctly. Click on the New Connection in SQL Developer.jar driver files and load into the tool not just the path. jar files are not recognized by SQL Developer and the Hive connection is not enabled then try with the ClouderaHiveJDBC4 jars). jar files from the JDBC driver download file ClouderaHiveJDBC-2.\ClouderaHiveJDBC41-2. In the Tools->Preferences->Database->Third party JDBC drivers add the.Note when configuring Cloudera-Hive JDBC drivers use the below website to download the 64bit JDBC driver for windows.Read this blog for a good idea about connecting Oracle SQL Developer to Hadoop Hive:.First download and install the popular free tool Oracle SQL Developer for Windows from Oracle website.Oracle SQL Developer Version 18.1.0.095 on Windows 64bit and Check out the instructions in the link below: It is easier to get working with Hive/Impala. Note: DBeaver free SQL editor is a far better tool than Oracle SQL developer and it connects to 80+ different databases.