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

Symptoms

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

 



Changes

 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>, ...);

 

Cause

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 hundreds of Community platforms