Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Access Impala from Oracle SQL Developer or similar tool

avatar

Hi guys,

 has anybody experience how to setup an access from SQL Developer to Impala via JDBC/ODBC?

I have read a discussion forum (outdated) where it states that Oracle does not support Impala, better said Oracle has a whitelist of connectors, 

Impala is not there.

 

If SQL Developer cannot be used, do you have any suggestion what tool should use a Oracle developer who needs to access Imapal (and

dont want to use Hue, neither impala-shell)?

 

Thanks

T.

 

1 ACCEPTED SOLUTION

avatar
Explorer
10 REPLIES 10

avatar
Contributor

@Tomas79 wrote:

Update: try Toad for Hadoop. It supports Impala and Hive with Kerberos, unfortunately the combination LDAP+Kerberos is not supported (yet).


Not supported, but where is a trick how to connect to Impala under Kerberos + LDAP in TOAD for Hadoop.

1) First, select in TOAD Impala + LDAP only (without Kerberos) and check connection. It fails, well.

2) Enable Kerberos in TOAD (LDAP auth options will become unalivable), but still actual. Check connection again.

3) Success!