Hi Ravi, Please make sure the location mentioned while create table exists at the time of *'MSCK REPAIR'*. This error occurs, if location does not exists on fs.
Thanks, Chetna Chaudhari On 15 September 2015 at 12:03, ravi teja <raviort...@gmail.com> wrote: > Hi, > I am getting this exception when I repair a table. > Not sure what this means, didnt get any info while searching also. > > Can someone guide , what this means? > > > CREATE EXTERNAL TABLE IF NOT EXISTS test_table .... > OK > Time taken: 0.124 seconds > > MSCK REPAIR TABLE test_table > OK > Tables missing on filesystem: test_table > > Time taken: 0.691 seconds, Fetched: 1 row(s) > > > Thanks, > Ravi > >