My Oracle Support Banner

Trying to Create Hive Archive Fails on Hive External Tables (Doc ID 1668252.1)

Last updated on MAY 07, 2014

Applies to:

Big Data Appliance Integrated Software - Version 2.0 and later
Linux x86-64


When trying to use Hive Archive you recieve the following error message.

FAILED: Error in metadata: ARCHIVE can only be performed on managed tables
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask



 You are trying to alter the table to use Hive Archive.

hive> set hive.archive.enabled=true;
hive> set hive.archive.har.parentdir.settable=true;
hive> set har.partfile.size=1099511627776;

ALTER TABLE <table_name> ARCHIVE PARTITION (<partition_col = partition_column_value>, <partition_col = partition_column_value>, ...);



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.