Skip to main content
akapratwar
Bronze ⭐️⭐️⭐️
September 29, 2017

After inserting into table Hive Metastore is showing invalid results

  • October 5, 2026 at 9:17 AM
  • 0 replies
  • 1700 views
  • Translate All

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