title: In Hive looking to select rows that have a special character in a column
body: <p>I'm looking to SELECT rows in Hive that have a special character [a-zA-Z0-9] in a column.</p>
  
  <p>I'm not quite sure how to construct the WHERE clause but based upon other threads I think it should look something like:</p>
  
  <pre><code>SELECT DISTINCT user_name
  FROM user_info
  WHERE user_name like regexp_extract('%[^a-zA-Z\d\s:]%')
  </code></pre>
  
  <p>but Hive provided this error:</p>
  
  <blockquote>
    <p>Error while compiling statement: FAILED: SemanticException [Error
    10014]: Line 3:21 Wrong arguments ''%[^a-zA-Z\d\s:]%'': No matching
    method for class org.apache.hadoop.hive.ql.udf.UDFRegExpExtract with
    (string). Possible choices: <em>FUNC</em>(string, string) <em>FUNC</em>(string,
    string, int)</p>
  </blockquote>
  
  <p>How should I set up the regexp_extract clause?</p>
  
  <p>Thanks</p>