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
P.S - Creating regular external table on amazon s3 without partition table is working fine.