Trying to Connect Impala using tHiveConnection

Trying to Connect Impala using tHiveConnection

Hi,
I want to connect to Cloudera-Impala using tHiveConnection.
I was able to connect Impala with tJDBCConnection using the below configuration:
JDBC URL: "jdbc:hive2://localhost:21050/;auth=noSasl"
Driver Class: "org.apache.hive.jdbc.HiveDriver"
Loaded JAR Files : impala-jdbc-0.5-2.zip
UserName/Password: Empty
Database : default
Need to know can we connect it using tHiveConnection or if there is a separate component available for impala to download.
The Impala Shell Version is v1.2.3

Regards,
Diwakar

Re: Trying to Connect Impala using tHiveConnection

Hi,
Below configuration worked for tHiveConnection, But i think it Connects the Hive instead of Impala since i can see the Map Reduce tasks being run.
Distribution: Cloudera
Hive Version: Cloudera (YARN Mode)
Connection Mode: Embedded
Hive Server: Hive2
Host: <hostname>
Port: 9083
Database: <dbname>

Regards,
Diwakar

Re: Trying to Connect Impala using tHiveConnection

Please let me know if we have an Impala Connector Available for Talend Open Studio for Big Data.
Currently the only ways to connect is using tJDBC or tSSH.
Regards,
Diwakar
Moderator

Re: Trying to Connect Impala using tHiveConnection

Hi,
You can open a new feature jira issue of Big data project on Talend Bug Tracker.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Re: Trying to Connect Impala using tHiveConnection

Hi,
You can open a new feature jira issue of Big data project on Talend Bug Tracker.
Best regards
Sabrina

New Feature request logged
Below is the link:
https://jira.talendforge.org/browse/TDI-28854