Support Questions
Find answers, ask questions, and share your expertise

How to connect Impala/Hive with Informatica

Highlighted

How to connect Impala/Hive with Informatica

Contributor

Hi Folks,

 

Can you kindly help to connect Impala with Informatica.I have gone through multiple blogs of Cloudera and Informatica but dint found the exact procedures to follow.

 

Thanks in advance

 

Sidharth

6 REPLIES 6
Highlighted

Re: How to connect Impala/Hive with Informatica

Rising Star
Are you getting any error while connecting ?

what kind of security is enabled for LDAP ?
Highlighted

Re: How to connect Impala/Hive with Informatica

Contributor
I have enabled kerberos. I have installed informatica on Aix.Now, I am
trying to connect informatica with impala using jdbc connection but it's
not able to read the ticket from cache.
Highlighted

Re: How to connect Impala/Hive with Informatica

Rising Star
it could be kerberos configuration issue on informatica server side.

can you share more detail ?
Highlighted

Re: How to connect Impala/Hive with Informatica

Explorer
Old thread but here is a way to connect to Hive and kudu using impala through Informatica Bigdata management

https://network.informatica.com/community/informatica-network/products/big-data/big-data-management/...
Highlighted

Re: How to connect Impala/Hive with Informatica

Explorer
But with Informatica BDM you also have Blaze and Spark as alternative engines to Hive. The original post was quite vague and may not have been BDM related at all.
Highlighted

Re: How to connect Impala/Hive with Informatica

Explorer

I didnt quite understand your statement..why does it matter if BDM has other execution engines like Blaze and spark?

 

Impala itself is another execution engine like spark and blaze, we dont need to use impala jdbc connection in BDM using spark and Blaze you can just use it in native mode.

Don't have an account?