title: Search Arrays in Hive
body: <p>I need to search an array function for specific values in hive.</p>
  
  <p>I have a table that creates a row for each event.  I used <code>collect_set(event_id)</code> to roll the table up to the person level.  I now need to search the array to put users into separate categories.  I tried using a case when statement, <code>find_in_set</code>, and <code>in_file</code> but none of those functions work on arrays.  </p>
  
  <p>Any ideas?  Can I convert an array into a string?  Ideally I would have used a <code>group_concat</code> function in SQL - but hive does not support it</p>