Apache Hive Cookbook

Chapter 3. Understanding the Hive Data Model

In this chapter, we will cover the following recipes:

• Using numeric data types
• Using string data types
• Using Date/Time data types
• Using miscellaneous data types
• Using complex data types
• Using operators
• Partitioning
• Partitioning a managed table
• Partitioning an external table
• Bucketing

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 ...