Chapter 4. Hive Data Definition Language

In this chapter, you will learn:

  • Creating a database schema
  • Dropping a database schema
  • Altering a database schema
  • Using a database schema
  • Showing database schemas
  • Describing a database schema
  • Creating tables
  • Dropping tables
  • Truncating tables
  • Renaming tables
  • Altering table properties
  • Creating views
  • Dropping views
  • Altering the view properties
  • Altering the view as select
  • Showing tables
  • Showing partitions
  • Show the table properties
  • Showing create table
  • HCatalog
  • WebHCat

Introduction

For your overall understanding of the Hive language, it is necessary to learn about the Data Definition Language (DDL) commands for the creation of a database, table, view, and so on. This chapter provides you with a detailed description of all the DDLs ...

Get Apache Hive Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.