Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Protection on data can be set at either the table or partition level. Enabling NO_DROP prevents a table or partition from being dropped. Enabling OFFLINE prevents the data in a table or partition from being queried, but the metadata can still be accessed. Note, if any partition in a table has NO_DROP enabled, the table cannot be dropped either.

Alter Table Rename Partition

Code Block

ALTER TABLE table_name PARTITION partition_spec RENAME TO PARTITION partition_spec;

This statement lets you change the value of a partition column.

Create/Drop View

Note: View support is only available starting in Hive 0.6.

...