There are various cases where CROSS joining the relations / tables is required. It returns all the rows in all the tables/relations provided in a
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.
Max vs Greatest in Apache Hive
In this post, we will discuss the similarities and differences between two Apache Hive functions, MAX and GREATEST. Using both functions, we get the largest
Outer Joins in Apache Pig
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)
Merging Multiple Relations Data – Apache Pig
This post aims to let you know how to merge the relations in Apache Pig. The UNION operator aids in the merger of two or
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
Self Join in Apache Pig
Although Apache Pig shares some similarities with SQL, it differs in functionality and behavior. Most SQL features, including as sorting, grouping, and joining, may be
Big Data & SQL 