Hive shell Issues

dnyanesh_kulkar · ‎09-20-2017

hello,

I am getting below warning messages while trying to launch hive from the command window.

How to supress these warning messages?

mqureshi · ‎09-20-2017

It says hive impersonation is not enabled which means your queries will run as user which is running hive process (its usually username "hive") instead of the user who submitted the query. So if you run hive shell as "dnyanesh" your query will still be run as "hive" which is a security flaw in case you want to trace down who ran what queries.

To get rid of the warning, you should enable Kerberos and then enable impersonation (impersonation will work without Kerberos also).<property>. set following property to true in hive-site.xml

  <name>hive.server2.enable.impersonation</name>
  <description>Enable user impersonation for HiveServer2</description>
  <value>true</value>
</property>

and then set following in core-site.xml

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

remember, this will get rid of your warning but it does not improve security unless Kerberos is enabled.

dnyanesh_kulkar · ‎09-21-2017

@mqureshi : I have checked above config files, its been set as it is as you mentioned. But still getting warning messages.