THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
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.
...