How will you prevent data to be dropped or queried from a partition in Hive?

We can use ALTER TABLE table_name ENABLE NO_DROP to prevent a table partition from being dropped.

We can use ALTER TABLE table_name ENABLE OFFLINE to prevent a table partition from being queried. In offline mode, we can still access metadata of a table partition.

Read the full book at www.amazon.com
Posted in Hive, Hive Interview Questions

Leave a Reply

Your email address will not be published. Required fields are marked *

*