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
Category: Apache Impala
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
TOP, LIMIT, ROWNUM vs DENSE_RANK
What would you do if you were asked to identify top-ten products based on their prices? In SQL Server, using a TOP clause with a
Clearing Screen – HDFS Terminal, Hive, Impala
Sometimes we may need to clear the screen or console window of commands or any output generated from the previous task. The following commands are
Aggregate Functions in Analytic Context
The functions SUM, AVG, COUNT, MIN, and MAX are well-known aggregate functions that we use every day. They are to compute/summarize the multiple rows by
Computing Running & Cumulative Average
This article helps you understand how to calculate the running average and cumulative average on a given data set. As discussed earlier, windowing functions
Big Data & SQL 