title: How to create multiple partitions using alter command in hive?
body: <p>I have 2 partitions on a table as below:</p>
  
  <pre><code>hive&gt; show partitions alt_part;
  OK
  yop=2011
  yop=2013
  </code></pre>
  
  <p>Now I want to add an inner partition to year 2013. But I'm getting the below error.</p>
  
  <blockquote>
    <p>hive> alter table alt_part add partition(yop=2013,mop=9); FAILED:
    SemanticException Partition spec {yop=2013,mop=9} contains
    non-partition columns</p>
  </blockquote>
  
  <p>Please correct me if I'm doing some mistake.</p>
  
  <p>I have also tried with location....</p>
  
  <blockquote>
    <p>hive>alter table alt_part add partition(yop=2013,mop=9) location '/user/revathi-prac/partitions/dec21/yop=2013/mop=9';</p>
  </blockquote>
  
  <p>but I still have the same issue...</p>