Skip to Main Content
Apache Hive Essentials - Second Edition
book

Apache Hive Essentials - Second Edition

by Dayong Du
June 2018
Beginner to intermediate content levelBeginner to intermediate
210 pages
5h 12m
English
Packt Publishing
Content preview from Apache Hive Essentials - Second Edition

Table alteration

Once a table is created, we can still modify its metadata, such as adding new columns and changing the column's data type. In HQL, we use the ALTER command to modify the table's metadata. However, alter table is not able to update the data accordingly. We should make sure the actual data conforms to the metadata definition manually, otherwise the query will return nothing in expectation.

The following are examples for altering tables in HQL:

  1. Rename a table with the ALTER statement. This is quite often used as data backup:
      > ALTER TABLE cte_employee RENAME TO cte_employee_backup;      No rows affected (0.237 seconds)
  1. Change the table properties with TBLPROPERTIES:
      > ALTER TABLE c_employee SET TBLPROPERTIES  ('comment'='New ...
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

Apache Hive Essentials

Apache Hive Essentials

Dayong Du
Apache Hive Cookbook

Apache Hive Cookbook

Hanish Bansal, Saurabh Chauhan, Shrey Mehrotra
Apache Spark Quick Start Guide

Apache Spark Quick Start Guide

Shrey Mehrotra, Akash Grade

Publisher Resources

ISBN: 9781788995092Supplemental Content