topic Re: Trying to Connect Impala using tHiveConnection in Talend Studio

Trying to Connect Impala using tHiveConnection

Anonymous — Sat, 16 Nov 2024 11:46:03 GMT

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

Anonymous — Fri, 31 Jan 2014 15:00:12 GMT

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

Anonymous — Mon, 03 Mar 2014 05:02:54 GMT

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

Re: Trying to Connect Impala using tHiveConnection

Anonymous — Mon, 03 Mar 2014 06:41:33 GMT

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

Re: Trying to Connect Impala using tHiveConnection

Anonymous — Mon, 03 Mar 2014 10:58:17 GMT

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