@Suresh Bonam I am not exactly sure what you meant by checking Hadoop environment in AWS. It would be same as any environment. You can log into Ambari Server UI and see if all services are up and running. Then, you can perform service check for all services from UI. Go to Ambari Server UI --> Services --> Service check. To perform additional checks for environment, you can perform smoke tests for each of the services. ... View more

@Suresh Bonam There are two ways to do it which I can think of at this moment. 1. You can write a couple of Pig statements to accomplish this. 2. You can try Hive query like below: (I won't recommended it normally for performance issues as Hive will first do a full cartesian product in this query, then filter, but since one side of the join only has one row, that's not an issue here.) select emp1.ename, emp1.hiredate from emp emp1 join (select hiredate from emp where emp.ename='KING') emp2 where emp1.hiredate > emp2.hiredate; ... View more