Beginners can choose from older versions of CDH (from Cloudera) and HDP (from Horton Works) fully functional virtual machines to study and practice big data
Category: Cloudera Impala
Alter View In Apache Hive & Impala
Earlier versions of Hive did not enable us to ALTER the view once it was generated, but this limitation has been removed in the later
LIMIT with OFFSET in Hive & Impala
When the query output zooms over the top of the screen before we see it, we can use LIMIT with OFFSET to display it one
Display Built-in Functions in Impala
As noted in a previous post, SHOW FUNCTIONS by default displays user-defined functions (UDFs) and SHOW AGGREGATE FUNCTIONS displays user-defined aggregate functions (UDAFs) connected with
Complex Data Types – ARRAY in MAP
In this blog, we’ll look at how to manage a complex datatype ARRAY within another complex datatype MAP. The dataset under discussion in this blog
Sub-Queries in Apache Hive
A subquery is a SQL query that runs within another query. They are nested inquiries that offer data to the query that comes before it.
Big Data & SQL 