Tag: Hive

Hive Indexes and View with Example

Hive Indexes and View with Example

What is a View? Views are similar to tables, which are generated based on the requirements. We can save any result set data as a view in Hive Usage is similar to as views used in SQL All type of DML operations can be performed on a view Creation of View: Syntax: Create VIEW < … Continue reading Hive Indexes and View with Example

Advertisements
What is Hive? Architecture & Modes

What is Hive? Architecture & Modes

What is Hive? Hive is an ETL and Data warehousing tool developed on top of Hadoop Distributed File System (HDFS). Hive makes job easy for performing operations like Data encapsulation Ad-hoc queries Analysis of huge datasets Important characteristics of Hive In Hive, tables and databases are created first and then data is loaded into these … Continue reading What is Hive? Architecture & Modes