Anyone know if Hortonworks Hive JDBC driver is supported in SQL Developer?

user6428880 Jan 22, 2015 6:32 PM

I add the jar files to the external JDBC driver path but the hive tab does not appear in the connection wizard.

Cloudera JDBC works but how sure if it is compatible with Hortonworks Hive.

Anyone has such experience? thanks

1. Re: Anyone know if Hortonworks Hive JDBC driver is supported in SQL Developer?

thatJeffSmith-Oracle Jan 22, 2015 6:54 PM (in response to user6428880)

We've only tested/certified the Cloudera ones.

Generally speaking, if you grab a JDBC driver that we don't 'know' about, it won't work.
Like Show 0 Likes(0)

Actions
2. Re: Anyone know if Hortonworks Hive JDBC driver is supported in SQL Developer?

Philip Stoyanov-Oracle Jan 26, 2015 9:30 AM (in response to user6428880)

Hi,

you should test it with your installation of Hortonworks - I'm able to connect to Hive in Hortonworks Sandbox 2.0 with JDBC drivers from Cloudera - related SQL Dev and Data Modeler functionality work in such scenario. But then you need to check what is your EULA with Cloudera about such usage.
As Jeff pointed SQL Developer doesn't allow other drivers to be installed. You can download standalone version of Data Modeler and there are no limitations on third party JDBC drivers.

Philip
Like Show 0 Likes(0)

Actions