Impala is Unable to Query JSON and ORC on BDA V4.4 and Higher
Last updated on NOVEMBER 03, 2016
Applies to:Big Data Appliance Integrated Software - Version 4.4.0 and later
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,
serviceversion:string,useragent:string>' in column 'md' of table 'als_impression_raw'
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