Re: Tables missing on the file system

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 wrote: > Hi, > I am getting this

Tables missing on the file system

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

Re: Tables missing on the file system

The location is present in the filesystem. Thanks, Ravi On Tue, Sep 15, 2015 at 12:16 PM, Chetna C 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

Re: Tables missing on the file system

HI Cazen, The location is present, just to simplify, I didnt paste the complete create command; The table is querable also. Thanks, Ravi On Tue, Sep 15, 2015 at 4:44 PM, Cazen Lee wrote: > External table can create without exact location or no location. > > So, I guess

Re: Tables missing on the file system

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 wrote: > The location is present in the filesystem. > > Thanks, > Ravi > > On Tue, Sep 15, 2015 at 12:16 PM, Chetna C

Re: Tables missing on the file system

External table can create without exact location or no location. So, I guess you didn't set the location or it doesn't exist the file system Did you set the location of table? CREATE EXTERNAL TABLE IF NOT EXIST test_table ( a STRING ) LOCATION '*hdfs://aa:port/location*'; If you set the

Re: Tables missing on the file system

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 wrote: > are you loading data in partitioned test_table after creating table and > before repairing using MSCK ? > > On Tue, Sep