The purpose of this article is to let you know how to list all the Apache Hive Metastore databases that can be found with the
Category: Cloudera Impala
Listing All The Tables In Apache Hive & Imapala
The purpose of this article is to let you know how to list all the tables that exists in the current database in Apache Hive
Working with Boolean in Apache Hive and Impala
George Boole described an algebraic logic system in the mid-19th century. The BOOLEAN data type is named after him. Boolean data type is a data
ZEROIFNULL Function in Apache Impala
If you’re working on a numeric/integer column and decided to substitute null values with zero, there’s a straight forward function that solves the issue. The
NVL vs NVL2 Functions in Apache Impala
Many of the functions that are present in Apache Hive and Impala are close to the functions of conventional frameworks such as Oracle SQL*Plus and
Apache Impala – Export Query Results To A File
Similar to traditional relational systems, it is possible to export the results of the query to a file in Apache Impala. This can be with
Big Data & SQL 