配置单元托管表记录计数结果未显示

jjhzyzn0  于 2021-06-27  发布在  Hive
关注(0)|答案(1)|浏览(374)

我正在开发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;
tsm1rwdh

tsm1rwdh1#

尝试:

select `_c0` from rule_config_value;

相关问题