hadoop - 配置单元 SQL CalcitePlanner : CBO failed due to missing column stats

Question

以下错误对 hive 的影响是什么以及如何避免:

17/09/14 16:24:25 [main]: ERROR calcite.RelOptHiveTable: No Stats for user@table, Columns: xyz column 17/09/14 16:24:25 [main]: ERROR parse.CalcitePlanner: CBO failed due to missing column stats (see previous errors), skipping CBO

SQL查询-

create table extractdataset
as select id,value, sum(rtne) as rtne_sum
from ( inner query )

Answer 1

请运行:

 analyze table extractdataset compute statistics;
 analyze table extractdataset compute statistics for columns;