Community Articles

Find and share helpful community-sourced technical articles.

Rising Star

PROBLEM: Hive metastore isn’t updating for tables after insert into the table. This issue is observed with improper ‘numRows’ value with the describle formatted <tb_name>

RESOLUTION: Hive stats are autogathered properly till an 'analyze table [tablename] compute statistics for columns' is run. Then it does not auto-update the stats till the command is run again. This is due to a known issue

https://issues.apache.org/jira/browse/HIVE-12661 and has been fixed in HDP-2.5.0

1,701 Views