title: Find function in HIVE
body: <p>I want to check if a field contains a string.</p>
  
  <p>I want a function that would look like this:</p>
  
  <pre><code>FIND("string_to_find",field_to_search)
  </code></pre>
  
  <p>My data looks like this:</p>
  
  <pre><code>field_to_search
  ---------------
  "no match in this string"
  "record 2 has no matches"
  "ahh finally xxxstring_to_findxxx is here"
  </code></pre>
  
  <p>I am looking for a function that identifies that the specified string is contained and at what position the string starts.</p>
  
  <pre><code>return
  ------
  -1
  -1
  15
  </code></pre>