title: Restoring Hive ORC table after changing source location?
body: <p>Assume you have two external Hive ORC tables. Both of them have the same schema with same datatypes, same partitions and same buckets.</p>
  
  <p>I'm trying to drop table A and set the location of table B to table A's source location. I've tried both:</p>
  
  <pre><code>alter tableB set location "hdfs://.../tableA"
  </code></pre>
  
  <p>and</p>
  
  <pre><code>msck repair table B
  </code></pre>
  
  <p>without luck.</p>