Joining in Apache Pig is identical to joining in SQL, in that it is used to combine tuples (rows) from two or more relations (tables)
Tag: Apache Pig Creating Table
Arithmetic Operations in Apache Pig
Addition, subtraction, multiplication, and division are the four fundamental arithmetic operations. The arithmetic operators such as “+” (Plus), “–” (Minus), “*” (Subtraction), “/” (Division), and
Grouping in Apache Pig
We’ll look at how to group the relation (table) data with Apache Pig in this post. In data analysis, sorting or grouping the data is
WORD COUNT IN Apache Pig
Pig is a high-level scripting language used in Apache Hadoop. Pig allows to write dynamic data transformations without the awareness of Java. Pig’s basic SQL-like
LOADING Tab Delimited DATA using 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
Loading comma separated data using 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,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
Big Data & SQL 