My Oracle Support Banner

Hive External Table with HAR Files Gives 'ERROR: AnalysisException: Failed to load metadata for table' when Queried in Impala-shell (Doc ID 1616756.1)

Last updated on FEBRUARY 17, 2014

Applies to:

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

Symptoms

An error similar to the following may be seen where 'hive_text_ext' is an example of an external HAR table that works in Hive but errors out when queried in Impala:

Query: select count(*) from hive_text_ext;
ERROR: AnalysisException: Failed to load metadata for table: hive_text_ext
CAUSED BY: TableLoadingException: Failed to load metadata for table: hive_text_ext
CAUSED BY: IllegalArgumentException: Wrong FS: har:/user/oracle/..., expected: hdfs://<ip>:8020

OR when a har file with lzo is used:

Query: select count(*) from hive_text_ext;
ERROR: AnalysisException: Failed to load metadata for table: default.hive_text_ext
CAUSED BY: TableLoadingException: Failed to load metadata for table: hive_text_ext
CAUSED BY: RuntimeException: Expected file with .lzo suffix: hdfs://<cluster>-ns/user/oracle/htest-dest/loglzo.har/part-0

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
Cause
Solution
References


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