@na You can use a command like this to get the start and end time and then store it where you wish to: oozie jobs -oozie http://localhost:11000/oozie -localtime -len 2 -fliter status=RUNNING Job Id Workflow Name Status Run User Group Created Started Ended .---------------------------------------------------------------------------------------------------------------------------------------------------------------- 4-20090527151008-oozie-joe hadoopel-wf RUNNING 0 joe other 2009-05-27 15:34 +0530 2009-05-27 15:34 +0530 - 0-20090527151008-oozie-joe hadoopel-wf RUNNING 0 joe other 2009-05-27 15:15 +0530 2009-05-27 15:15 +0530 - .---------------------------------------------------------------------------------------------------------------------------------------------------------------- For detailed information see this: https://oozie.apache.org/docs/3.3.2/DG_CommandLineTool.html#Jobs_Operations ... View more

@Dhiraj Unfortunately, there is no current functionality in Ambari to do it. However, the functionality is coming in Ambari 3.0.0. Please refer below Jira: https://issues.apache.org/jira/browse/AMBARI-18378 If you have a test/POC cluster try applying the patch attached to this Jira and see if it works. I have personally not done it, so apply the patch at your own discretion if you choose to. Thanks ... View more

@Anurag Mishra Hi You can use the following properties: Note: These settings can be accessed from Ambari > YARN > Configs > Scheduler or in conf/capacity-scheduler.xml. --1. For adding users who can submit jobs <property> <name>yarn.scheduler.capacity.root.test.acl_submit_applications</name> <value>user1 group1, user2, user3 group 2</value> <description> The ACL of who can submit jobs to the test queue. </description> </property> --2. For administering a queue <property> <name>yarn.scheduler.capacity.root.test.acl_administer_queue</name> <value>user5 group5</value> <description> The ACL of who can administer jobs on the test queue.</description> </property> ... View more

@Harjinder Brar Mysql statement construction is not correct where should be before group by like this: --query 'select d.driverid, d.name, SUM(t.hours_logged) as hours from driver d JOIN timesheet t on (d.driverid = t.driverid) Where $CONDITIONS group by d.driverid,d.name' This should fix the issue. Thanks ... View more