title: HDINSIGHT hive, MSCK REPAIR TABLE table_name throwing error
body: <p>i have an external partitioned table named employee with partition(year,month,day), everyday a new file come and seat at the particular day location call for today's date it will be at 2016/10/13.</p>
  
  <pre><code>TABLE SCHEMA:
  create External table employee(EMPID Int,FirstName String,.....)
  partitioned by (year string,month string,day string)
  ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' LOCATION '/.../emp';
  </code></pre>
  
  <p>so everyday we need to run command which is working fine as </p>
  
  <pre><code>ALTER TABLE employee ADD IF NOT EXISTS PARTITION (year=2016,month=10,day=14) LOCATION '/.../emp/2016/10/14';
  </code></pre>
  
  <p>but once we are trying with below command because we don't want to execute the above alter table command manually, it throws below Error</p>
  
  <pre><code>hive&gt; MSCK REPAIR TABLE employee;
  FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
  </code></pre>
  
  <p>Note: </p>
  
  <pre><code>hive&gt; MSCK TABLE employee; //this show me that a partition has not added in the table
  OK
  Partitions not in metastore: employee:2016/10/14
  Time taken: 1.066 seconds, Fetched: 1 row(s)
  </code></pre>
  
  <p>please help me as i stuck with this. do we have any workaround for this type of situation?</p>