Question: Employee Analysis using pig latin script 1. load the data Employee_Advance.csv and create relation 2. Count the number of employee in each gender 3. count
Employee Analysis using pig latin script
1. load the data Employee_Advance.csv and create relation
2. Count the number of employee in each gender
3. count the number of employees in each department
4. AVG salary in each department
5. analyse the AVG salary of employee's from the united states
6. using DISTINCT command to remove duplicate entry from a relation
7. Show DISTINCT country names
8. Show DISTINCT City names
9. count of all distinct/unique city
Step by Step Solution
3.49 Rating (156 Votes )
There are 3 Steps involved in it
Q1 Employee Analysis using pig latin script 1 load the data EmployeeAdvance... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
6365d6c3e22b2_240535.pdf
180 KBs PDF File
6365d6c3e22b2_240535.docx
120 KBs Word File
