Setup High Availability Zoopkeeper Hive Connection

seperiya — Thu, 04 Jun 2020 22:01:24 GMT

I am using attunitu replicate 6.4. My sourcec is Oracle and target in hortonworks hadoop distribution 2.6.5. I need to setup hive availability , instead of connecting to single hive node. I dont see any option in UI. is there any hidden variable or some other way to configure hive connection with zookeeper.

Attached the screenshot.

Re: Setup High Availability Zoopkeeper Hive Connection

john_wang — Fri, 05 Jun 2020 03:12:14 GMT

Hi Seperiya,

You can tweak the Hadoop endpoint configuration to make it work.

--------------------------------------------------

Configure the Hadoop endpoint as follows:

1. Hive Host – put here a list of ZooKeeper nodes and ports in the format "ZK_Host1:ZK_Port1,ZK_Host2:ZK_Port2,…"

2. Hive Port – can be ignored

3. Internal Parameter – add this to Advanced -> Internal Parameters:

o Parameter: additionalConnectionProperties

o Value: ServiceDiscoveryMode=1;ZKNamespace=hiveserver2;

Note: The ZKNamespace may have a different value on different environments. Check the Hive configuration.

If you have further issues still or it does not work for you, I'd like suggest you create support case in Salesforce instead of trace this issue here.

Regards,

John WANG.

topic Setup High Availability Zoopkeeper Hive Connection in Qlik Replicate

Setup High Availability Zoopkeeper Hive Connection

Re: Setup High Availability Zoopkeeper Hive Connection