Hi,

I'm trying to use Hive(0.13) msck repair table command to recover
partitions and it only lists the partitions not added to metastore instead
of adding them to metastore as well.

here's the ouput of the command

partitions not in metastore externalexample:CreatedAt=26 04%3A50%3A56 UTC
2014/profileLocation="Chicago"

here's how I'm creating the external table

CREATE EXTERNAL TABLE IF NOT EXISTS ExternalExample( tweetId BIGINT,
username STRING, txt STRING, CreatedAt STRING, profileLocation STRING, favc
BIGINT,retweet STRING,retcount BIGINT,followerscount BIGINT) COMMENT 'This
is the Twitter streaming data' ROW FORMAT DELIMITED FIELDS TERMINATED BY
'\t' STORED AS TEXTFILE location '/user/hue/exttable/';

Am I missing something here?

Thanks,

Yogendra

Reply via email to