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!

Using SQL Developer to Query Impala with JDBC Driver

BuntoroApr 11 2017 — edited Jun 9 2017

Hi,

I have seen same question but has not been answered yet and the thread has been archived.

I would like to ask the same question because I don't want to wake old thread.

Using SQL Developer 4.1 to Query Impala with JDBC Driver

As Jeff mention there, the support will be specifically based on Oracle's Big Data Appliance.

This blog shows how to connect to Hive but not Impala

https://blogs.oracle.com/datawarehousing/entry/oracle_sql_developer_data_modeler

I have been trying to search about Oracle's Big Data

Quote from this whitepaper on Big Data Appliances from page 3.

http://www.oracle.com/technetwork/database/bigdata-appliance/overview/bigdataappliance-datasheet-1883358.pdf

Oracle Big Data Connectors

In addition to providing Oracle Big Data SQL and the full Cloudera software platform, Big Data Appliance utilizes Oracle Big Data Connectors to simplify data integration and analytics.

Big Data Appliance leverages Apache Sentry (an open-source project of which Oracle developers are founding members) to authorize SQL access via tools like Hive and Impala. By delivering and developing Sentry, Oracle delivers Big Data Appliance with the highest data security levels currently available for Hadoop.

Therefore, will SQL Dev also support Impala as Hive is supported?

And where can I find the correct documentation on how to access Impala via SQL Dev.

Thanks,

Buntoro

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2017
Added on Apr 11 2017
1 comment
985 views