Thanks @Neeraj Sabharwal ... View more

Thanks @Artem Ervits. I'm aware of Nagios/Ganglia deprecation in later versions of Ambari 🙂 I just gave the reference to get the better idea of question. Thanks again! Will check the documentation ... View more

@Vidya SK - Goto Ambari UI -> select Hive service -> you should see mysql server there -> just point your mouse arrow over the link and you should get the name of mysql server OR you will get it in hive-site.xml grep -A 2 mysql /etc/hive/conf/hive-site.xml ... View more

@Vidya SK Run below command to list the tables: sqoop list-tables --connect jdbc:mysql://<mysql-server>/database --username <username> --password <password> ... View more

Hey @Ashnee Sharma Please refer this - https://community.hortonworks.com/questions/4496/how-to-migrate-hive-data-over-to-new-cluster.html ... View more

@Suresh Bonam Unfortunately No! Either we need to pass it via command line or set "exectype=tez" in pig.properties via Ambari ... View more

@Sergey Orlov - As per error given in question FAILED:HiveException java.security.AccessControlException:Permission denied: user=tech_dmon, access=WRITE, inode="/user/p/data":tech_p:bgd_p:drwxr-xr-x Could you please confirm if inode name is /user/tech_p/data or its /user/p/data ? In any of the above case, you are running your oozie cordinator/workflow as tech_dmon user and its trying to write into some other user's user directory in HDFS instead of /user/tech_dmo/ hence you are getting permission denied error. Could you please check application logs of this job and let me know what is the value of below properties user.name mapreduce.job.user.name ... View more

@ Sergey Orlov - Could you please share your job.properties and workflow.xml ? I can see in error log inode is "" it should be something like "hdfs://<namenode-host>:8020/<hdfs-path>" ... View more