This article will help you understanding how to get the version number of Apache Pig you are using. Apache Pig version can be get from
NEXT_DAY Function in Apache Hive & Impala
During data processing or data transformation, we often look for a suitable function to perform a particular task. If we can’t find a solution, we
Convert Multiple Date Formats into A single Format
Representation of the date and time varies between countries, various applications or application logs. When stored in a table form, we always use a single
Does ‘Anti Join’ perform better than ‘Left Join’?
The answer is – YES..!!! Anti-join is a very efficient SQL construct offered by Apache Impala. Anti-join between two tables returns rows from the first
Modifying HDFS Default Configuration
This post discusses how to change the current HDFS configuration, such as the default block replication, the data node directory, the default block size, etc.
Hive SerDe – RegEx – Example9
The Relational Database Architecture is the simplest model, since it does not need any complex structuring and does not entail complicated architectural processes. The simplicity
Big Data & SQL 