title: Inserting system timestamp into a timestamp field in hive table
body: <p>I m using Hive 0.8.0 version. I wanted to insert the system  timestamp into a timestamp field while loading data into a hive table.
  In Detail:
  I have a file with 2 fields like below:</p>
  
  <pre><code>id name
  1  John
  2  Merry
  3  Sam
  </code></pre>
  
  <p>Now i wanted to load this file on hive table along with the extra column "<strong><em>created_date</em></strong>". So i have created hive table with the extra filed like below:</p>
  
  <pre><code>CREATE table mytable(id int,name string, created_date timestamp) row format delimited fields terminated by ',' stored as textfile;
  </code></pre>
  
  <p>If i load the data file i used the below query:</p>
  
  <pre><code>LOAD DATA INPATH '/user/user/data/' INTO TABLE mytable;
  </code></pre>
  
  <p>If i run the above query the "<strong><em>created_date</em></strong>" field will be NULL. But i wanted that field should be inserted with the system timestamp instead of null while loading the data into hive table. Is it possible in hive. How can i do it? </p>