[HIVE-6800] HiveServer2 is not passing proxy user setting through hive-site

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.13.0
• Fix Version/s: 0.13.0
• Component/s: HiveServer2
• Assignee: Vaibhav Gumashta
• Reporter: Vaibhav Gumashta
• Created: 31/Mar/14 23:28
• Updated: 06/Apr/14 00:48
• Resolved: 06/Apr/14 00:09

Description

Setting the following in core-site.xml works fine in a secure cluster with hive.server2.allow.user.substitution set to true:

<property>
  <name>hadoop.proxyuser.user1.groups</name>
  <value>users</value>
</property>
    
<property>
  <name>hadoop.proxyuser.user1.hosts</name>
  <value>*</value>
</property>

where user1 will be proxying for user2:

!connect jdbc:hive2:/myhostname:10000/;principal=hive/[e-mail];hive.server2.proxy.user=user2 user1 fakepwd org.apache.hive.jdbc.HiveDriver

However, setting this in hive-site.xml throws "Failed to validate proxy privilage" exception.

Issue Links

• is related to: HIVE-6851 HS2 proxy user - should refresh proxy user list only once