title: Using SQL Where clauses on an array column
body: <p>A column contains a list of arrays in a table in <code>hadoop</code>. When the array has no data the column has the following <code>[]</code>.</p>
  <p>I am trying to return a list of unique IDs where <code>[]</code> does not appear in that column. I can't use <code>&lt;&gt;</code> or <code>!=</code>.</p>
  <p>I also tried returning rows where the character length is greater than 2, but this didn't work.</p>
  <p>How can I return rows that do not contain <code>[]</code>?</p>