Use a Spark-specific Hive configuration file to resolve the Hive-on-Tez issue for Spark Jobs on Hortonworks
Hortonworks ships a Spark-specific hive-site.xml file to resolve this Hive-on-Tez issue. You can use this file to define the connection to your Hortonworks cluster in Talend Studio.
This file is stored in the Spark configuration folder of your Hortonworks cluster: /etc/spark/conf.