Something like below command should work as long as both databases are in same Hive instance. create table databaseB.testtable as select * from databaseA.testtable ... View more

If looks like an output on 'hdfs dfs -ls ' which tries to get the user home directory (which points to /user/ritjain) in your case. This is missing here. Use hdfs user to create home directory for the user and change owner to 'ritjain'. Then if you execute it, you should be able to get there. Regarding namenode status, post a screenshot of what you are looking at on browser. Error from command shows that NN seems to be running fine. ... View more

As you can see, adding this config in ambari will add it in mapred-site.xml which will be default value. As it is not a final value, if you set it from hiveconf, that will take precedence. I think this is a case of mismatched configs. If you see you are using mapred.job.queuename and not mapreduce.job.queuename. Try changing it to mapreduce.job.queuename and you should see if going to the right queue ... View more

Yes. That is the issue. This has been resolved based on that, but I haven't updated the question with this answer. Thanks for answering this. ... View more

Try hdfs groups for that user to see if group mapping is working. If its then, your configuration should be like below. <property> <name>yarn.scheduler.capacity.queue-mappings</name> <value>u:user1:queue1,g:group1:queue2,u:%user:%user,u:user2:%primary_group</value> <description> Here, <user1> is mapped to <queue1>, <group1> is mapped to <queue2>, maps users to queues with the same name as user, <user2> is mapped to queue name same as <primary group> respectively. The mappings will be evaluated from left to right, and the first valid mapping will be used. </description> </property> ... View more