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
Category: Apache Impala
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
Apache Impala – Executing SQL file in non-Interactive Mode
The purpose of this article is to explore non-interactive mode of execution of the local file to retrieve records from Impala through the command line
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
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
Big Data & SQL 