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.
