Data Services Connectivity with HIVE in 4.2 SP14

Hi Experts,

I have requirement to load data in HIVE tables based on Azure.

Can you please help with connectivity steps and also how I can load the CDC data since the HIVE tables only supports merge option unlike other data bases which have insert and update.

Thanks.