title: regular expression in hive
body: <p>I am learning simple regular expressions in Hive. I am following a tutorial and simple hql statements get an error?</p>
  
  <pre><code>select REGEXP_EXTRACT( 'Hello, my name is Ben. Please visit' , 'Ben' )
  </code></pre>
  
  <p>This is the error message I am getting:</p>
  
  <p><code>Wrong arguments ''Ben'': org.apache.hadoop.hive.ql.metadata.HiveException: Unable to execute method public java.lang.String org.apache.hadoop.hive.ql.udf.UDFRegExpExtract.evaluate(java.lang.String,java.lang.String) on object org.apache.hadoop.hive.ql.udf.UDFRegExpExtract@ec0c06f of class org.apache.hadoop.hive.ql.udf.UDFRegExpExtract with arguments {Hello, my name is Ben. Please visit:java.lang.String, Ben:java.lang.String} of size 2</code></p>
  
  <p>It works in other languages, but I want to learn it in Hive. Any help would be appreciated.</p>