Apr 4, 2016

Apache Pig Exercises: 34. List all employees who joined in Before or After 1981

Posted by  on 
In this post the sample Apache Pig script will List employees who joined in Before or After 1981 Using Apache Pig version r0.15.0. @ Test data structure:Please refer to APACHE PIG ~ ALL SAMPLE TABLES and STRUCTURES post for the file structures, visit the reference section shown at the...

Apache Pig Exercises: 33 List all employees except ‘President’ & ‘Manager’ in asc order of salaries

Posted by  on 
In this post the sample Apache Pig script will List all employees except ‘President’ & ‘Manager’ in asc order of salariesUsing Apache Pig version r0.15.0. @ Test data structure:Please refer to APACHE PIG ~ ALL SAMPLE TABLES and STRUCTURES post for the file structures, visit...

Apache Pig Exercises: 32 List employees who does not belong to deptno 20

Posted by  on 
In this post the sample Apache Pig script will List employees who does not belong to deptno 20 Using Apache Pig version r0.15.0. @ Test data structure:Please refer to APACHE PIG ~ ALL SAMPLE TABLES and STRUCTURES post for the file structures, visit the reference section shown...

Apache Pig Exercises: 31 List employees whose names have a ‘LL’ characters together

Posted by  on 
In this post the sample Apache Pig script will List employees whose names have a ‘LL’ characters togetherUsing Apache Pig version r0.15.0. @ Test data structure:Please refer to APACHE PIG ~ ALL SAMPLE TABLES and STRUCTURES post for the file structures, visit the reference section...

Apache Pig Exercises: 30 List employees whose salary is 4 digit number ending with zero

Posted by  on 
In this post the sample Apache Pig script will List employees whose salary is 4 digit number ending with zero Using Apache Pig version r0.15.0. @ Test data structure:Please refer to APACHE PIG ~ ALL SAMPLE TABLES and STRUCTURES post for the file structures, visit the reference...

Apache Pig Exercises: 29 List employees who joined in a month of which second character is ‘a’

Posted by  on 
In this post the sample Apache Pig script will List employees who joined in a month of which second character is ‘a’Using Apache Pig version r0.15.0. @ Test data structure:Please refer to APACHE PIG ~ ALL SAMPLE TABLES and STRUCTURES post for the file structures, visit the reference...