Impala can't access all hive table
Though the INVALIDATE METADATA
command in impala works it is documented to be expensive, in recent versions it is now possible to invalidate the metadata of just 1 table, which will have less impact:
INVALIDATE METADATA mynewtable
Alternately, if you use HUE, there is also a less expensive option available. Which may be convenient if you have added multiple new tables:
Beneath is the ? online help explanation:Missing some tables? In order to update the list of tables/metadata seen by Impala, execute one of these queries:
"invalidate metadata" invalidates the entire catalog metadata. All table metadata will be reloaded on the next access."invalidate metadata <table>" invalidates the metadata, load on the next access"refresh <table>" refreshes the metadata immediately. It is a faster, incremental refresh.