Search code examples
hadoophiveclouderahueimpala

Impala can't access all hive table


I try to query hbase data through hive (I'm using cloudera). I did a fiew hive external table pointing to hbase but the thing is Cloudera's Impala doesn't have an access to all those tables. All hive external tables appear in the metastore manager but when I do a simple "show tables" in Impala, I see that 3 tables are missing. Would it be a privileges problem ? I see that in the metastore manager that the 3 tables missing are readable by everybody so...


Solution

  • Run the query 'invalidate metadata' in Impala and your tables will show-up.