Trying to Create Hive Archive Fails on Hive External Tables
(Doc ID 1668252.1)
Last updated on NOVEMBER 08, 2022
Applies to:
Big Data Appliance Integrated Software - Version 2.0 and laterLinux 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
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
Changes
NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |