Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


+
Oliver 2014-03-24, 15:18
+
Abdelrahman Shettia 2014-03-24, 15:46
+
Oliver 2014-03-24, 16:59
+
Abdelrahman Shettia 2014-03-25, 15:21
+
Rishabh Bhardwaj 2014-03-24, 15:56
Copy link to this message
-
Re: Permission denied creating external table
Hi Rishabh,

Not sure if this entirly right. I did a quick test and I can create an external table without the write permission.

hive> CREATE EXTERNAL TABLE mytest (name string) location '/test/mytest';
OK
Time taken: 1.675 seconds
hive> dfs -ls /test ;
Found 1 items
drwxr-xr-x   - hive hdfs          0 2014-03-24 09:03 /test/mytest
hive> exit;    
[hive@sandbox ~]$ hadoop dfs -ls /test
Found 1 items
drwxr-xr-x   - hive hdfs          0 2014-03-24 09:03 /test/mytest
[hive@sandbox ~]$ hadoop dfs -ls / | grep test
drwxr-xr-x   - hdfs   hdfs            0 2014-03-24 09:03 /test

So, It depends on the configurations in my previous email and the proxy settings for Hive users in core-site.xml.:
<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>

Thanks,
Rahman

On Mar 24, 2014, at 8:55 AM, Rishabh Bhardwaj <[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.

 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB