My Oracle Support Banner

Impala is Unable to Query JSON and ORC on BDA V4.4 and Higher (Doc ID 2199150.1)

Last updated on JANUARY 10, 2020

Applies to:

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

Symptoms

Impala is unable to query JSON and ORC files on BDA V4.4 and higher.

For example trying to query JSON files in Impala fails with:

Your query has the following error(s):

AnalysisException: Failed to load metadata for table: '<TABLE>' CAUSED BY: TableLoadingException:
Unsupported type

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


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