The tHiveRow component won’t execute with specified user within component in Hive connection

Overview

Regardless of the user you’ve specified in the Hive connection, the tHiveRow component is choosing the default Hive user to execute queries.

 

Environment

Hive has been set up on the cluster end to run all Hive queries as Hive. In Talend Big Data Studio versions 5.6.1, 5.6.2, 6.0.1, and 6.1.1, in any Hadoop distribution, the Hive server executes everything according to the settings you’ve specified in the Hadoop cluster.

 

Symptoms/Description

You’ve selected a particular user for a Hive job, but the job is not reflecting that selection.

 

Resolution

  1. Go to the Hadoop management interface.
  2. Go to Hive/Configs/General.
    • Locate the property hive.server2.enable.doAs. Set the value to True.
    • Locate the property hive hive.security.authorization.enabled. Set the value to True.
  3. Go to HDFS/Configs/Custom core-site.xml. Check the property hadoop.proxyuser.hive.groups to see if it’s set up to allow Hive to pretend to be any user for any incoming request (or for hosts allowed to request specific users). The expected default is “*”.
  4. Check the property hadoop.proxyuser.hive.hosts to see if the hosts are set up so Hive can pretend to be any user belonging to any group (or list of groups to which the impersonated user belongs). The expected default is “*”.
Version History
Revision #:
5 of 5
Last update:
‎04-18-2017 02:30 AM
Updated by:
 
Labels (1)
Tags (1)