This article offers a summary of the situations in which you would need to create internal (managed) tables and external tables in Apache Hive. Create “External” tables when: the data is being used outside the Hive. The data files are read and
Category: Apache Hive
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
Moving a table from one Hive database to another
This article is to let you know how to move a table from one database to another in Hive. CREATE TABLE TestDB.emp AS SELECT *
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
Big Data & SQL 