What's the best way to support array column types with external tables in hive? <p>So i have external tables of tab delimited data. A simple table looks like this:</p> <pre><code>create external table if not exists categories (id string, tag string, legid string, image string, parent string, created_date string, time_stamp int) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LOCATION 's3n://somewhere/'; </code></pre> <p>Now I'm adding another field to the end, it will be a comma separated list of values. </p> <p>Is there a way to specify this in the same way that I specify a field terminator, or do I have to rely on one of the serdes?</p> <p>eg:</p> <pre><code>...list_of_names ARRAY&lt;String&gt;) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ARRAY ELEMENTS SEPARATED BY ',' ... </code></pre> <p>(I'm assuming I'll need to use a serde for this, but I figured there wasn't any harm in asking)</p>