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
Category: Apache Hive
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
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
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 