Jan 17, 2016

Apache Pig learning exercises series intro...

Posted by  on 


In this Apache Pig learning series I am planning on exercising the Pig script with the following classical Employee and Department table structures and data that we have all seen with popular RDBMes from Oracle, IBM DB2, MS SQL Server, MySQL and others. 





Please make sure to follow the subsequent Posts that describe how Apache Pig can allow us to find out the results for our extract criteria. With this Apache Pig exercise series I am hoping to complete the below criteria:

  1. Display all the information of the emp table.
  2. Display unique jobs from EMP table.
  3. List the details of the emps in asc order of their salaries.  
  4. List the details of the emps in asc order of the Deptnos and desc of Jobs.
  5. Display all the unique job groups in the descending order
  6. Display all the details of all ‘Mgrs’
  7. List the emps who joined before 1981.
  8. List the Empno, Ename, Sal, Daily Sal of all Employees in the ASC order of AnnSal.
  9. Display the empno , ename, job, hiredate, exp of all Mgrs
  10. List the empno, ename, sal, exp of all emps working for Mgr 7839.
  11. Display the details of the emps whose Comm. Is more than their sal.
  12. List the emps in the asc order of Designations 
  13. List the emps along with their exp and daily sal is more than Rs.100
  14. List the emps who are either ‘CLERK’ or ‘ANALYST’ in the desc order
  15. List the emps who joined on 1May81,31Dec81, 17Dec81, 19Jan80 in asc order of seniority.
  16. List the emps who are working for the deptno 10 or 20
  17. List the emps who are joined in the year 1981
  18. List the emps who are joined in the month of Aug 1980
  19. List the emps whose annul sal ranging from 22000 and 45000
  20. List the emps those are having five characters in their names.
  21. List the enames those are starting with ‘s’ and with fire characters
  22. List the emps those are having four chars and third char must be ‘r’
  23. List the 5 character names starting with ‘s’ and ending with ‘h’
  24. List the emps who joined in January
  25. List the emps who joined in the month of which second character is ‘a’
  26. List the emps whose sal is 4 digit number ending with zero
  27. List the emps whose names having a character set ‘ll’ together
  28. List the emps those who joined in 80’s
              Thanks!

              1 comment: