Jan 26, 2016

Apache Pig Exercises: 21. List Employees those are having five characters in their names

Posted by  on 
In this post the sample Apache Pig script will List employees wthose are having five characters in their names. The examples and exercise scripts are created using Apache Pig current version r0.14.0. @ Test file data structure: Please refer to Apache Pig learning series intro... post for the file...

Jan 19, 2016

List of Apache Pig v0.15 Built-in functions

Posted by  on 
In this post I am providing a list of Apache Pig v0.15 Built-in functions. This post is for a quick review of Apache Pig built in functions. Please note that these functions are from the actual Apache Pig project online documentation and can be reviewed on the Apache site listed below. @ Link: http://pig.apache.org/docs/r0.15.0/func.html Built...

Apache Pig Exercises: 20. List Employees whose annul salary is ranging from 22000 and 45000

Posted by  on 
In this post the sample Apache Pig script will display employees whose annul salary ranging from 22000 and 45000. The examples and exercise scripts are created using Apache Pig current version r0.14.0. @ Test data structure: Please refer to Apache Pig learning series intro... post...

Apache Pig Exercises: 19. List Employees who are joined in the month of Dec 1981

Posted by  on 
In this post the sample Apache Pig script will display employees  who are joined in the month of Dec 1981. The examples and exercise scripts are created using Apache Pig current version r0.14.0. @ Test data structure: Please refer to Apache Pig learning series intro... post...

Apache Pig Exercises: 18. List Employees who are joined in the year 1981

Posted by  on 
In this post the sample Apache Pig script will display employees who are joined in the year 1981. The examples and exercise scripts are created using Apache Pig current version r0.14.0. @ Test data structure: Please refer to Apache Pig learning series intro... post for the file...

Apache Pig Exercises: 17. List Employees who are working for the deptno 10 or 20

Posted by  on 
In this post the sample Apache Pig script will display employees who are working for the deptno 10 or 20. The examples and exercise scripts are created using Apache Pig current version r0.14.0. @ Test data structure: Please refer to Apache Pig learning series intro... post for...

Apache Pig Exercises: 16. List Employees who joined on 1-May-81, 31-Dec-81, 17-Dec-81, 19-Jan-80 in asc order of seniority

Posted by  on 
In this post the sample Apache Pig script will display employees who joined on 1-May-81, 31-Dec-81, 17-Dec-81, 19-Jan-80 in asc order of seniority. The examples and exercise scripts are created using Apache Pig current version r0.14.0. @ Test data structure: Please refer to Apache...

Apache Pig Exercises: 15. List Employees who are either ‘CLERK’ or ‘ANALYST’ in descending order

Posted by  on 
In this post the sample Apache Pig script will display employees who are either ‘CLERK’ or ‘ANALYST’ in the desc order. The examples and exercise scripts are created using Apache Pig current version r0.14.0. @ Test data structure: Please refer to Apache Pig learning series intro... post...

Apache Pig Exercises: 14. List Employees along with their experience & daily salary is more than $100

Posted by  on 
In this post the sample Apache Pig script will display the employees along with their experience and daily salary is more than $100. The examples and exercise scripts are created using Apache Pig current version r0.14.0. @ Test data structure: Please refer to Apache Pig learning series...