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 <cazen....@gmail.com> wrote: > 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 >>> >> >> >
