Since Apache Pig does not have SELECT statements like SQL, there is no straightforward solution for loading, filtering, and retrieving particular columns in a single
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.
Limiting Rows in Result – Apache Pig
Data sampling is the best practice to understand the data patterns and trends of large datasets by looking at the smaller portion of the data.
​Quoted Identifiers in Column Names – Apache Hive
In SQL, an identifier is a string of alphanumeric and underscore (_) characters surrounded by backtick (`). In Hive, quoted IDs are case-insensitive. For example,
Apache Pig Utility Commands
This post aims to let you know the shell and utility commands that help in various situations. Shell Commands (1) fs: Any FsShell command can
Sorting in Apache Pig
Rearranging the rows returned from a query result set in ascending or descending order is the most commonly utilized function by analysts. Sorting can be
Big Data & SQL 