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

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now