Author: K Z

In this section we will explains the built-in functions available in Hive. The functions look quite similar to SQL functions, except for their usage. Built-In Functions Hive supports the following…

In this section we will explains the built-in operators of Hive. There are four types of operators in Hive: Relational OperatorsArithmetic OperatorsLogical OperatorsComplex Operators Relational Operators These operators are used…

Hive organizes tables into partitions. It is a way of dividing a table into related parts based on the values of partitioned columns such as date, city, and department. Using…

In this section we describes how to drop a table in Hive. When you drop a table from Hive Metastore, it removes the table/column data and their metadata. It can…

In this section we will explains how to alter the attributes of a table such as changing its table name, changing column names, adding columns, and deleting or replacing columns.…

In this section we will explains how to create a table and how to insert data into it. The conventions of creating a table in HIVE is quite similar to…

In this section we describes how to drop a database in Hive. The usage of SCHEMA and DATABASE are same. Drop Database Statement Drop Database is a statement that drops…

Hive is a database technology that can define databases and tables to analyze structured data. The theme for structured data analysis is to store the data in a tabular manner,…

In this section we know the different data types in Hive, which are involved in the table creation. All the data types in Hive are classified into four types, given…

All Hadoop sub-projects such as Hive, Pig, and HBase support Linux operating system. Therefore, you need to install any Linux flavored OS. The following simple steps are executed for Hive…