301.3.7-Joins
Hive Joins Supports only equality joins a.key=b.key Doesnât support a.key<b.key type of joins as of now Joins with Non-equality …
Read More301.1.4-Handling Big Data
Bigdata Tool Analysis on this Bigdata can give us awesome insights. But, by definition, the bigdata can’t be handled using …
Read More301.3.6-Basic commands using HQL
Basic commands using HQL Count(*)in Hive A simpe count Query select count(*) from stack_overflow_tags; Group by in Hive …
Read More301.3.5-Hive Basic Vocabulary and Hive Query Language
Hive Basic Vocabulary Databases, Tables and more Databases: Contains tables, views, partitions etc., Tables: Data records with same schema. …
Read More301.3.4-Hive Architecture
Hive Architecture Metastore The component that store the system catalog and meta data about tables, columns, partitions etc. Stored …
Read More301.3.3-Hive vs RDBMS
Hive is different from RDBMS You may think hive as Bigdata version of a Relational database management system(RDBMS). There …
Read More