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?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks