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


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


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

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