(Solved) : Write Mapreduce Program Find Maximum Salary Employee Department Along Employee Id Data Emp Q44141750 . . .
Write a MapReduce program to find the maximum salary of anemployee for each department along with the employee Id.
Data is :
EMPNO,EMPNAME,JOB,MANAGERID,HIREDATE,SAL,COMMISSION,DEPTNO7369,SMITH,CLERK,7902,13-06-13,800,0,207499,ALLEN,SALESMAN,7698,15-08-14,1600,300,307521,WARD,SALESMAN,7698,26-03-14,1250,500,307566,JONES,MANAGER,7839,31-10-14,2975,,207698,BLAKE,MANAGER,7839,11-06-14,2850,,307782,CLARK,MANAGER,7839,14-05-14,2450,,107788,SCOTT,ANALYST,7566,05-03-14,3000,,207839,KING,PRESIDENT,,09-06-14,5000,0,107844,TURNER,SALESMAN,7698,04-06-14,1500,0,307876,ADAMS,CLERK,7788,04-06-14,1100,,207900,JAMES,CLERK,7698,23-06-14,950,,307934,MILLER,CLERK,7782,21-01-14,1300,,107902,FORD,ANALYST,7566,05-12-14,3000,,207654,MARTIN,SALESMAN,7698,05-12-14,1250,1400,30
Dataset Description:
COLUMN NAMENULL? TYPEEMPNONOT NULLNUMBER(4)EMPNAMENOT NULLSTRINGJOBNOT NULLSTRINGMANAGERIDINT HIREDATEDATE SALDOUBLECOMMISSIONDOUBLEDEPTNONOT NULLINT
Output: It should include the columns – Dept,max(salary), EmpNo
Constraints:
- Use a single MapReduce job to complete the task
- Also, skip the header row while reading the file
Expected Solution: You need to paste the MRcode, Hadoop commands & path of the final jar that is used toachieve this output.
Expert Answer
Answer to Write a MapReduce program to find the maximum salary of an employee for each department along with the employee Id. Dat…
OR