Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Permission denied creating external table


Copy link to this message
-
Re: Permission denied creating external table
Hi Oliver,

Try to set these properties in core-site.xml: Using * will allow everyone
to impersonate Hive and the cluster needs to be restarted.

<property>
  <name>hadoop.proxyuser.hive.groups</name>
  <value>users</value>
  <description>Allow the superuser hive to impersonate any members of
the group users. Required only when installing Hive.
  </description>
</property>

where *$HIVE_USER* is the user owning Hive Services. For example, hive.

<property>
  <name>hadoop.proxyuser.hive.hosts</name>
  <value>$Hive_Hostname_FQDN</value>
  <description>Hostname from where superuser hive can connect.
Required only when installing Hive.
  </description>
</property>

Also, Enable the following configuration in Hive-site.xml:

hive.metastore.execute.setugi

In addition, Please use the directory path only while you are creating the
table and it would be better to have 'hadoop' as the supergroup.

Hope this helps.

Thanks

On Mon, Mar 24, 2014 at 9:59 AM, Oliver <[EMAIL PROTECTED]> wrote:
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.