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 location, you can see the file in hadoop dfs -ls hdfs://aa:port/location ca...@korea.com cazen....@samsung.com http://www.Cazen.co.kr <http://www.cazen.co.kr/> 2015-09-15 20:03 GMT+09:00 ravi teja <raviort...@gmail.com>: > 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 >> > >
