我正在开发hdp3.0kerberized集群,并尝试运行配置单元计数查询。在运行count查询时,我发现它并没有显示托管表的结果,而是显示了对外部表起作用的相同查询
CREATE TABLE rule_config_value (
config_column STRING,
config_value STRING
) STORED AS ORC;
INSERT INTO TABLE rule_config_value VALUES ("empid","5");
INSERT INTO TABLE rule_config_value VALUES ("state","NJ");
INSERT INTO TABLE rule_config_value VALUES ("country","United States");
select count(*) from rule_config_value;
输出获取:
+------+
| _c0 |
+------+
+------+
步骤尝试过但没有成功:
analyze table rule_config_value compute statistics;
analyze table rule_config_value compute statistics for columns config_column,config_value;
1条答案
按热度按时间tsm1rwdh1#
尝试: