Often, some requests for reports seem simple and straightforward. But it is challenging to find a better solution to be applied. Cloudera’s Impala provides several
Category: Cloudera Impala
Split equivalent in Impala
Split function splits the data based on the delimiter provided and it is mostly used function in Apache Hive. This function is not available in Impala.
Joins in HiveQL
As we discussed earlier, HiveQL handles structured data only, much like SQL. This doesn’t mean that Hive just manages structured data, it also processes and
Creating a table and a view with the select statement.
In this article, you’ll learn how to create a view and table based on a select statement. -~ To create a viewCREATE VIEW Emp_View ASSELECT Ename,
An alternative to ISNULL() and NVL() functions in Hive
The NVL() function enables you to substitute null for a more relevant alternative in the query results. This function accepts two arguments. If the first
Big Data: Apache Hive & Impala Data Types Quick Reference
This article offers an overview of the various data types that are available both in Apache Hive & Impala. TINYINT – 1 byte Range: -128 to 127 SMALLINT – 2 bytes Range: -32,768 to 32,767
Big Data & SQL 