Apache Pig provides few functions that SQL developers are familiar with. The behavior in much of the functions is the same. Such functions help to
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.
Impact of Table Definition Changes on “Views”
Look at the below statement. CREATE VIEW vwTest AS SELECT * FROM TestTable; A simple statement to create a View, right? Assume that “TestTable” has
Fetching Current Date in Hive
In this article, we will see how to fetch current date or current date-time in lower and higher versions of Apache Hive. SELECT UNIX_TIMESTAMP(): SELECT
Apache Pig Complex Types – Tuple & Bag
In this post, we’ll talk about Apache Pig’s complex types, “Tuples & Bags”. Maps will be discussed in another post. Pig Latin statements work with
Silent Mode Execution in Hive
It might be unpleasant to watch the full progress that is displayed on the screen after executing a query in Apache Hive. We can simply
COGROUP in Apache Pig
COGROUP works in the same way as the group operator. The major distinction between the Group and Cogroup operators is that the Group operator is
Big Data & SQL 