title: Adding Minutes to Timestamp Hive
body: <p>I am trying to add/subtract 14 minutes to a time interval I have but keep receiving errors or null</p>
  
  <p>I am doing</p>
  
  <pre><code>select f.act_arrv_dtmz, from_unixtime(unix_timestamp('f.ACT_ARRV_DTMZ')+840)
  </code></pre>
  
  <p>but I keep receiving an error. I am also trying it using CAST</p>
  
  <pre><code>select act_dprt_dtmz, CAST(act_dprt_dtmz as timestamp) - cast(from_unixtime(unix_timestamp(act_dprt_dtmz)+840) as timestamp) from heart_beat_data_temp; 
  </code></pre>
  
  <p><strong>this doesnt give the right time and when i put the variable in quotes</strong></p>
  
  <pre><code>select act_dprt_dtmz, CAST(act_dprt_dtmz as timestamp) - cast(from_unixtime(unix_timestamp('act_dprt_dtmz')+840) as timestamp) from heart_beat_data_temp; 
  </code></pre>
  
  <p><strong>it gives me null</strong></p>
  
  <p>I would expect whatever the act_dprt_dtmz timestamp is plus 14 minutes</p>