title: Is there a Hive equivalent of SQL "not like"
body: <p>While Hive supports positive like queries: ex. </p>
  
  <blockquote>
    <p>select * from table_name where column_name <strong>like 'root~%'</strong>;</p>
  </blockquote>
  
  <p>Hive <strong>Does not</strong> support negative like queries: ex.</p>
  
  <blockquote>
    <p>select * from table_name where column_name <strong>not like 'root~%'</strong>;</p>
  </blockquote>
  
  <p>Does anyone know an equivalent solution that Hive does support?</p>