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...
我尝试通过hive查询hbase数据（我正在使用cloudera）。我做了一个指向hbase的fiew hive外部表，但事情是Cloudera的Impala无法访问所有这些表。所有hive外部表都出现在Metastore管理器中，但是当我在Impala中执行一个简单的“show tables”时，我看到缺少3个表。这会是特权问题吗？我看到在Metastore管理器中，每个人都可以读取丢失的3个表，所以......
2 个解决方案
#1
45
Run the query 'invalidate metadata' in Impala and your tables will show-up.
在Impala中运行查询“invalidate metadata”，您的表格将会显示。
#2
1
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:
下面是？在线帮助说明：缺少一些表格？要更新Impala看到的表/元数据列表，请执行以下查询之一：
"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.
#1
45
Run the query 'invalidate metadata' in Impala and your tables will show-up.
在Impala中运行查询“invalidate metadata”，您的表格将会显示。
#2
1
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:
下面是？在线帮助说明：缺少一些表格？要更新Impala看到的表/元数据列表，请执行以下查询之一：
"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.