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