title: how to convert unix epoch time to date string in hive
body: <p>I have a log file which contains timestamp column. The timestamp is in unix epoch time format. </p>
  
  <p>I want to create a partition based on a timestamp with partitions year, month and day.</p>
  
  <p>So far I have done this but it is throwing an error.</p>
  
  <pre><code>PARSE ERROR cannot recognize input '(' in column type
  </code></pre>
  
  <p>Here is my code.</p>
  
  <pre><code>from (
        from raw_data
              MAP  ${PREFIX}raw_data.line
              USING 's3://scripts/clean.py'
              AS (timestamp STRING, name STRING)
        ) map_out
  INSERT OVERWRITE TABLE date_base_data_temp PARTITION(year(timestamp), month(timestamp)), day(timestamp))) 
      select map_out.name;
  </code></pre>