O'Reilly logo

Apache Hive Essentials by Dayong Du

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Data Definition and Description

This chapter introduces the basic data types, data definition language, and schema in Hive to describe data. It also covers the best practices to describe data correctly and effectively by using internal or external tables, partitions, buckets, and views.

In this chapter, we will cover the following topics:

  • Hive primitive and complex data types
  • Data type conversions
  • Hive tables
  • Hive partitions
  • Hive buckets
  • Hive views

Understanding Hive data types

Hive data types are categorized into two types: primitive and complex data types. String and integer are the most useful primitive types, which are supported by most Hive functions.

Tip

Downloading the example code

You can download the example code files from your account ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required