Impala is Unable to Query JSON and ORC on BDA V4.4 and Higher

(Doc ID 2199150.1)

Last updated on NOVEMBER 03, 2016

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_name>' CAUSED BY: TableLoadingException:
Unsupported type 'struct<timestamp:string,latitude:string,longitude:string,clientip:string,deviceid:string,
macaddress:string,devicetype:string,deviceos:string,devicemodel:string,connection:string,carrier:string,
refererurl:string,xforwardedfor:string,sessionid:string,application:string,appversion:string,
serviceversion:string,useragent:string>' in column 'md' of table 'als_impression_raw'

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