title: HIVE. Dynamic partitioning and Insert into specific column
body: <p>There is a HIVE table with around 100 columns, partitioned by columns ClientNumber and Date.
  I am trying to insert data from another HIVE table into only 30 columns as well as create <code>Date</code> partitions dynamically.</p>
  
  <p>The issue is that all data gets loaded into "ClientNumber=123/date=__HIVE_DEFAULT_PARTITION__" partition which is not quite expected.</p>
  
  <p>The script looks like this:</p>
  
  <pre><code>set hive.exec.dynamic.partition=true;
  set hive.exec.dynamic.partition.mode=nonstrict;
  
  FROM DBName.Table2
  INSERT INTO TABLE DBName.Table1
  PARTITION(ClientNumber=123, `Date`)   
  (col1, col2, ..., col29, `Date`) 
  SELECT 
  col1, col2, ..., col29, eventDate as `Date`
  </code></pre>
  
  <p><code>Date</code> values retrieved by the query are all correct, no NULL or other uncharacteristic values. 
  Removing or adding Dynamic partitioning parameters makes no difference.
  Providing specific <code>Date</code> value (instead of dynamic query-populated value) results in creation of correct partitions.</p>
  
  <p>Is there any trick I am missing or some issue with populating specific number of columns in partitioned tables?</p>
  
  <p>P.S. Is listing all other columns (col31 - col100) in import script as NULL worth considering?</p>