On Thu, Mar 7, 2019 at 4:54 PM <l...@china-inv.cn> wrote: > Hi, All, > > We use the 'alter table foo set location new-hdfs-folder' to force table > foo to use the latest data >
Is foo an external table? > > The command is executed successfully and the new data can be accessed > through table foo. > > But the metadata of the table 'foo' is not correct. e.g. rowNumber and > table size, > > I tried 'analyze table foo compute statistics' and 'msck repair table foo' > But both don't work. > Looking at the documentation at https://cwiki.apache.org/confluence/display/Hive/StatsDev#StatsDev-ExistingTables%E2%80%93ANALYZE, it looks like ANALYZE table foo compute statistics should correct the statistics. -- Best Wishes, Ashutosh Bapat