Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Using SQL Developer 4.1 to Query Impala with JDBC Driver

PostmodernLudditeMay 6 2015 — edited Jul 22 2015

I am trying to use the 3rd-party Cloudera JDBC driver to query Impala running on Cloudera CDH 5.4.

I am already able to query Hive using a 3rd party JDBC driver. I followed the instructions here: https://blogs.oracle.com/datawarehousing/entry/oracle_sql_developer_data_modeler. When I set this up, an additional tab appears in the "New/Select Database Connection" window in SQL Developer called "Hive."

For Impala, I have installed the JDBC drivers in SQL Developer.  I tried downloading and including the updated version of the JDBC driver as specified by Cloudera here (info about Impala and JDBC in general): Configuring Impala to Work with JDBC and also Download Impala JDBC Connector v2.5.21 . No luck, if I get the most recent version of the JDBC driver, there is no additional tab that appears in the connection option in SQL developer that says "Impala."

Looking at the page above by Cloudera titled "Configuring Impala to Work with JDBC", it seems that Impala should be queryable by the Hive driver. However, when I try this with the existing Hive driver that I was using it does not work either.

Impala would be nice because I could get snappy (1 or 2 second) response times from queries instead of having to wait a minute for each query to return.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2015
Added on May 6 2015
4 comments
2,858 views