Does the new location have old partitions as well? OR some partitions lie in old location and some in new location?
On Sun, Mar 10, 2019 at 10:01 PM Ashutosh Bapat < ashutosh.bapat....@gmail.com> wrote: > > > 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 >
