@Raja Sekhar Chintalapati Ranger works with beeline. You will expect different behavior when you run hive cli thats why the best practice is to avoid hive and stick with beeline ... View more

@Raja Sekhar Chintalapati Please see these details https://issues.apache.org/jira/browse/HIVE-6415 https://cwiki.apache.org/confluence/display/Hive/L... ... View more

@rbalam please see this https://community.hortonworks.com/questions/4496/how-to-migrate-hive-data-over-to-new-cluster.html This can be a productive workaround. You can get list of tables and then using vi or any editor create a script to export all tables as seperate command. mysql -u hive -p -e " select concat( 'show create table ' , TBL_NAME,';') from TBLS" hive > file.sql remove header in file.sql hive -f /tmp/file.sql ... View more

@Mike Li Did it help to resolve the issue? Thanks for confirming and updating the thread. ... View more

Thanks @sivasaravanakumar k . ... View more

@Rahul Pathak You are looking for something like this ... View more

@Ancil McBarnett If cluster is going to be heavily used for spark then definitely good idea to allocate dedicated resources to spark components. Also, make sure that spark client has enough memory too. ... View more

@Rahul Pathak That will be RM UI, You can see all the jobs running and using different queues. Click Yarn in ambari --> Quick links ... View more