AnsweredAssumed Answered

Hive - partition table

Question asked by amiryahav on Aug 30, 2016
Latest reply on Feb 8, 2017 by maprcommunity

I am using hive to create external table with partition on amazon S3 bucket.

when I running

"select * from t1p where year=2016 and month=08 and day=06 and hour=00"

 

I didn't get any result so I run this command:

hive> MSCK REPAIR TABLE t1p;

The command is running few minutes and exit with this error:

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

 

Please advise.

Thanks

Amir

 

P.S - Creating regular external table on amazon s3 without partition table is working fine.

Outcomes