In the following post, we will cover Hive Introduction and key principles of Hive. Hive Introduction – Benefits and Limitations Hive is a data warehouse tool developed on top of Hadoop to process structured data. This is basically a wrapper written …
The below diagram represents Hadoop Hive Architecture and typical query that flows through the HIVE system. The UI calls the execute query interface to the driver. The driver creates a session handle for the query and sends the query to …
In this post, we will discuss Hive data types and file formats. Hive Data Types Hive supports most of the primitive data types that we find in relational databases. It also supports three collection data types that are rarely supported …
Some of the key Hive components that we are going to learn in this post are UI, Driver, Compiler, Metastore, and Execution engine. Let us understand these Hive components one by one in detail below. Apache Hive components Hive User …
In this section, we will discuss data definition language parts of HIVE Query Language(HQL), which are used for creating, altering and dropping databases, tables, views, functions, and indexes. We will also look into SHOW and DESCRIBE commands for listing and …