title: Insert into specific columns of table
body: <p>As per <a href="https://issues.apache.org/jira/browse/HIVE-9481" rel="nofollow">https://issues.apache.org/jira/browse/HIVE-9481</a>, inserting into specific columns of Hive is supported. The syntax as per this link is:
  Insert into target(colA, colB) select colX,colY from source;</p>
  
  <p>However, when I try executing the same in Hive, I get the error:</p>
  
  <p><strong>Semantic Exception: '[colA, colB] in insert schema specification are not found among regular columns of default.target nor dynamic partitions.</strong></p>
  
  <p>How can I insert values in Hive by specifying a column list ?
  Please help.</p>