Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connecting to Hive/Hadoop using SQL Developer.

rjsosiJul 12 2019 — edited Aug 1 2019

Hi,

I just downloaded SQL Developer v19.1.0.094 and I'm trying to connect to Hive on a Hadoop server.

For the Hadoop connection I was able to load a driver but it looks like it needs another section for a port entry.

Dataiku_logon.PNG

I downloaded the HiveJDBC41.jar file and loaded it onto SQL developer in the 3rd part drivers section.

I got the following screen.

pastedImage_2.png

As you can see there's only one place for adding a port number whereas on the previous product
I was using they had two sections for adding a port number.

This version of Hive is connecting to a Hadoop file system using Hive to manages the data on it.

Do I need to add any additional drivers to take Hadoop into consideration?

Thanks,
Comments
Post Details
Added on Jul 12 2019
#sql-developer
5 comments
2,830 views