title: presto syntax for csv external table with array in one of the fields
body: <p>I'm having trouble creating a table in Athena - that points at files with the following format:
  string, string, string, array.</p>
  
  <p>when I wrote the file - I delimited the array items with '|'. 
  I delimited each line with '\n' and each column with ','.</p>
  
  <p>so for example, a row in my CSV would look like that:</p>
  
  <p><code>Garfield, 15, orange, fish|milk|lasagna</code></p>
  
  <p>in hive (according to the documentation i read)- when creating a table with a row delimited format - while stating the delimiters you can state a 'collection items' delimiter - that states the delimiter between elements in array columns.
  I could not find an equivalent for Presto in the documentation,</p>
  
  <p>Is anyone aware if it's possible, if so - what is the format, or where can I find it? </p>
  
  <p>i tried "guessing" many forms, including 'collection items', none seem to work.</p>
  
  <pre><code>CREATE EXTERNAL TABLE `cats`(
    `name` string, 
    `age` string, 
    `color` string, 
    `foods` array&lt;string&gt;)
  ROW FORMAT DELIMITED 
    FIELDS TERMINATED BY ',' 
    LINES TERMINATED BY '\n' 
    COLLECTION ITEMS TERMINATED BY '|'
  STORED AS INPUTFORMAT 
    'org.apache.hadoop.mapred.TextInputFormat' 
  OUTPUTFORMAT 
    'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
  LOCATION
    'some-location'
  </code></pre>
  
  <p>Would really appreciate any insight, Thanks! :)</p>