title: converting to timestamp with time zone failed on Athena
body: <p>I'm trying to create to following view:</p>
  
  <pre><code>CREATE OR REPLACE VIEW view_events AS 
  (
     SELECT
       "rank"() OVER (PARTITION BY "tb1"."innerid" ORDER BY "tb1"."date" ASC) "r"
     , "tb2"."opcode"
     , "tb1"."innerid"
     , "tb1"."date"
     , From_iso8601_timestamp(tb1.date) as "real_date"
     , "tb2"."eventtype"
     , "tb1"."fuelused"
     , "tb1"."mileage"
     , "tb1"."latitude"
     , "tb1"."longitude"
     FROM
       rt_message_header tb1
     , rt_messages tb2
     WHERE ((("tb1"."uuid" = "tb2"."header_uuid") AND ("tb2"."opcode" = '39')) AND ("tb2"."type" = 'event'))
     ORDER BY "tb1"."innerid" ASC, "tb1"."date" ASC
  )
  </code></pre>
  
  <p>and it gives me the following error:</p>
  
  <blockquote>
    <p>Your query has the following error(s):
    Unsupported Hive type: timestamp with time zone</p>
  </blockquote>
  
  <p>however when I run the query on it's own it works fine, and the From_iso8601_timestamp is mentioned <a href="https://prestodb.io/docs/current/functions/datetime.html" rel="noreferrer">here</a> as a valid date function.</p>
  
  <p>can anyone tell me what I'm doing wrong?</p>