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
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
Sqoop Complete Tutorial Part-7
This is the continuation part of “Sqoop Complete Tutorial”. If you want to read – Part-1, please click here. Part-2, please click here. Part-3, please
Sqoop Complete Tutorial Part-6
This is the continuation part of “Sqoop Complete Tutorial”. If you want to read – Part-1, please click here. Part-2, please click here. Part-3, please
Get Table Row Count And Used Size
The following query will help you in checking the total number of rows and the size of the table(s). SELECTs.Name AS SchemaName,t.Name AS TableName,p.rows AS
Big Data & SQL 