Skip to Content
Apache Hive Cookbook
book

Apache Hive Cookbook

by Hanish Bansal, Saurabh Chauhan, Shrey Mehrotra
April 2016
Beginner content levelBeginner
268 pages
5h 32m
English
Packt Publishing
Content preview from Apache Hive Cookbook

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Introduction to Apache Hive

Introduction to Apache Hive

Tom Hanlon

Publisher Resources

ISBN: 9781782161080Supplemental Content