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)
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Filtering Data in Apache Pig
The goal of this post is to show you how to retrieve filtered data from a relation (table) in Apache Pig. Apache Pig has a
Executing Shell Commands in Apache Hive
One does not need to exit Hive or start a new shell to verify the files and directories of HDFS, copy files from the local
Removing Redundant Tuples in Apache Pig
To avoid erroneous data values, it’s common to look for and eliminate duplicate entries during data analysis. This article will teach you how to remove
Executing Hive Queries in Silent Mode From HDFS Terminal
The goal of this tutorial is to show you how to run hive queries in silent mode. It’s used to get data from tables without
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
Big Data & SQL 