title: Partition Hive table by existing field?
body: <p>Can I partition a Hive table upon insert by an existing field?</p>
  
  <p>I have a 10 GB file with a date field and an hour of day field. Can I load this file into a table, then insert-overwrite into another partitioned table that uses those fields as a partition? Would something like the following work?</p>
  
  
  
  <pre><code>INSERT OVERWRITE TABLE tealeaf_event  PARTITION(dt=evt.datestring,hour=evt.hour) 
  SELECT * FROM staging_event evt;
  </code></pre>
  
  <p>Thanks!</p>
  
  <p>Travis</p>