Can you please clarify in which Talend version/edition you are?
Today I tried connecting Hive directly using Hiveconnector component in Talend. It got connected successfully.
I have used HiveRow component to execute the script in Hive and linked both activity in a job.
When I tried executing the Job, it got connected to cluster and created the hive script file. But it got failed in executing the hive script. I am exploring to find the root cause for the same.
Find attached document for reference.
Is your hdinsight cluster up and running well?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.