title: Getting error while retrieving columns on HIVE "TIMESTAMP" column
body: <p>In Hive, I am trying create table on log file, I have data in the following format.</p>
  
  <ul>
  <li><p>1000000000012311 1373346000 21.4 XX</p></li>
  <li><p>1000000020017331 1358488800 16.9 YY</p></li>
  </ul>
  
  <p>In this second field is Unix timestamp. I am writing following HIVE QUERY:</p>
  
  <pre><code>CREATE EXTERNAL TABLE log(user STRING, tdate TIMESTAMP, spend DOUBLE, state STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' LINES TERMINATED BY '\n' LOCATION '/user/XXX/YYY/ZZZ';
  </code></pre>
  
  <p>Table is created. but when I am trying to get the data from table <code>Select * form log limit 10';</code>
  I am getting following error.</p>
  
  <blockquote>
    <p>Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: Error evaluating tdate</p>
  </blockquote>
  
  <p>I have checked the HIVE manual and also google it, but didn't get any solution.</p>