Its an external table, hence I am only creating the table on the already present data location.
On Tue, Sep 15, 2015 at 4:02 PM, Nitin Pawar <nitinpawar...@gmail.com> wrote: > 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 >
