title: Insert timestamp into Hive
body: <p>Hi i'm new to Hive and I want to insert the current timestamp into my table along with a row of data. </p>
  
  <p>Here is an example of my <strong>team</strong> table :</p>
  
  <pre><code>team_id int
  fname   string
  lname   string
  time    timestamp
  </code></pre>
  
  <p>I have looked at some other examples, <a href="https://stackoverflow.com/questions/26511664/how-to-insert-timestamp-into-a-hive-table">How to insert timestamp into a Hive table?</a>, <a href="https://stackoverflow.com/questions/26505586/how-can-i-add-a-timestamp-column-in-hive/26508873#26508873">How can I add a timestamp column in hive</a> and can't seem to get it to work.
  This is what I am trying:</p>
  
  <pre><code>insert into team values('101','jim','joe',from_unixtime(unix_timestamp()));
  </code></pre>
  
  <p>The error I get is:</p>
  
  <pre><code>FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values
  </code></pre>
  
  <p>If anyone could help, that would be great, many thanks frostie</p>