Impala Cannot See Some Tables Created In Hive (Doc ID 2281153.1)

Last updated on JULY 02, 2017

Applies to:

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

Symptoms

Impala cannot see some tables created in Hive and the table counts in Hive and Impala (both in HUE and on the command-line) are different.

Manually refreshing Impala metadata in Hue (all 3 options: clear cache/Incremental update/Invalidate all metadata and rebuild index) does not resolve the issue.  Running "invalidate metadata" from the command line gives errors as it also does in Hue.

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