The purpose of this article is to explore interactive and non-interactive modes of execution of the SQL file to retrieve records from the Hive metastore
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.
Apache Hive – ISNULL vs NVL
Unlike in relational database systems like SQL Server, the ISNULL function works in a different way in Apache Hive. In SQL Server, ISNULL(col1, 0) returns
Executing Hive Query From Terminal
The aim of this post is to let you know how to execute a Hive query from command line (terminal) to fetch the records from
Apache Hive – Store & Access Nested Values – Complex Data Types- Part-1
This is going to be a series of articles to discuss about complex data types that are available in Apache Hive. There will be too
WORD COUNT IN Apache Pig
Pig is a high-level scripting language used in Apache Hadoop. Pig allows to write dynamic data transformations without the awareness of Java. Pig’s basic SQL-like
LOADING Tab Delimited DATA using APACHE PIG
The below example will let you know how to load the comma separated values in Apache Pig. Let’s consider the popular Emp data. OracleEmpData.csv7839 KING
Big Data & SQL 