Tag: Defining columns in Apache Pig

The below example will let you know how to load the comma separated values in Apache Pig. Let’s consider the popular Emp data. OracleEmpData.csv7839 KING

The below example will let you know how to load the comma separated values in Apache Pig. Let’s consider the popular Emp data.OracleEmpData.csv7839,KING,PRESIDENT,0,1981-11-17,5000,0,107698,BLAKE,MANAGER,7839,1981-05-01,2850,0,307782,CLARK,MANAGER,7839,1981-09-06,2450,0,107566,JONES,MANAGER,7839,1981-02-04,2975,0,207788,SCOTT,ANALYST,7566,1987-07-13,3000,0,207902,FORD,ANALYST,7566,1981-12-03,3000,0,207369,SMITH,CLERK,7902,1980-12-17,800,0,207499,ALLEN,SALESMAN,7698,1981-02-20,1600,300,307521,WARD,SALESMAN,7698,1981-02-22,1250,500,307654,MARTIN,SALESMAN,7698,1981-09-28,1250,1400,307844,TURNER,SALESMAN,7698,1981-08-09,1500,0,307876,ADAMS,CLERK,7788,1987-07-13,1100,0,207900,JAMES,CLERK,7698,1981-12-03,950,0,307934,MILLER,CLERK,7782,1982-01-23,1300,0,10 You can