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 Threaded View
Hive >> mail # user >> User accounts to execute hive queries


Copy link to this message
-
Re: User accounts to execute hive queries
You will need to tell few more things.
Do you want it secured?
Do you distinguish users in different categories on what one particular
user can do or not?
What kind of security do you have on hdfs?
It is definitely possible for users to run queries on their own username
but then you have to take few measures as well.
which user can do what action. Which user can access what location on hdfs
etc

For user management on hive side you can read at
https://cwiki.apache.org/Hive/languagemanual-authorization.html

if you do not want to go through the secure way,
then add all the users to one group and then grant permissions to that
group on your warehouse directory.

other way if the table data is not shared then,
create individual directory for each user on hdfs and give only that user
access to that directory.
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