are you loading data in partitioned test_table after creating table and before repairing using MSCK ?
On Tue, Sep 15, 2015 at 3:51 PM, ravi teja <raviort...@gmail.com> wrote: > The location is present in the filesystem. > > Thanks, > Ravi > > On Tue, Sep 15, 2015 at 12:16 PM, Chetna C <chetna....@gmail.com> wrote: > >> 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 >>> >>> >> > -- Nitin Pawar