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

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