hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yogendra reddy <yogendra...@gmail.com>
Subject hive 0.13 msck repair table only lists partitions not in metastore
Date Wed, 05 Nov 2014 12:46:51 GMT
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

Mime
View raw message