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

1 Expert Approved Answer
Step: 1 Unlock

Q1 Employee Analysis using pig latin script 1 load the data EmployeeAdvance... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

6365d6c3e22b2_240535.pdf

180 KBs PDF File

Word file Icon

6365d6c3e22b2_240535.docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!