![]() ![]() Step6) Open SQL developer and right click on connections toĪdd a connection. Restart the SQL developer to reflect this change. Select Database and then “Third Party JDBC Drivers” and useĪdd entry option to add the jar files mentioned in steps above. Unzip that file as well and move all the jars to There will beĪnother zip file you will find called “Cloudera_HiveJDBC4_2.zip”. Step4) Unzip the downloaded file from step3. Install Oracle SQL Developer To decide which version of the installer you should download, check if you have the Java SE Development Kit 8 (Java Version 1.8.x). Cloudera has one available and here it he link forįor Hive JDBC Driver for Oracle SQL Developer Step3) Need to download JDBC driver for Hive that can work Once you have this fix then you should be able to open the So I had to follow this instruction to fix it For me it showed up in the tray, blinked for a while and then Now when you try to open up Oracle SQL developer on mac, Move the SQL Developer file to your application, so that it Step2) Download the latest version of Oracle SQL developer ![]() JAVA_HOME path so that it points to JDK 1.8. Need JDK 1.8 so you would need to install that on your mac and also change the To install SQLcl: Select the ZIP file and extract the files. Step1) For the latest version of SQL developer you would To download the latest version using a direct link, go to You can use this address to automate the download as part of an automated process. I found this original article on oracle’s website and made some additionsīased upon the issues that I ran into. So extending the functionality of SQL developer to connect to hive is very useful for Oracle users. Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. Oracle SQL Developer is one of the most common SQL client tool that is used by Developers, Data Analyst, Data Architects etc for interacting with Oracle and other relational systems.
0 Comments
Leave a Reply. |