Introduction

In previous chapters, you learned the installation of different Hive components such as Hive metastore, HiveServer2, and working with different services in Hive.

In this chapter, we will cover the following sub topics:

• Using data types
• Using operators
• Partitioning
• Bucketing

Introducing data types

Hive supports various data types that are primarily divided into two parts:

• Primitive data types
• Complex data types

Hive supports many primitive data types that are similar to relational databases, such as INT, SMALLINT, TINYINT, BIGINT, BOOLEAN, FLOAT, and DOUBLE. In addition to primitive data type, Hive also supports few complex data types, such as ARRAY, MAP, STRUCT, and UNION.

Primitive data types

Hive supports large number of primitive data types, which are divided into the four following different categories:

• Numeric data types
• String data types
• Date/Time data type
• Miscellaneous data types

All these primitive data types are similar to RDBMS primitive data types.

Complex data types

The following...