title: Hive INSTR function working incorrectly on string with UTF8 characters
body: <p>Hive INSTR function is working incorrectly on strings with UTF8 characters. When an accent character is part of the string, INSTR returns an incorrect character location for subsequent characters. It seems to be counting bytes instead of characters. </p>
  
  <p>With the accent character as part of string it returns 8</p>
  
  <pre><code>select INSTR("Réservation:", 'a'); returns 8 
  </code></pre>
  
  <p>Without the accent character as part of string it returns 7</p>
  
  <pre><code>select INSTR("Reservation:", 'a'); returns 7
  </code></pre>
  
  <p>Is there a fix to this or an alternate function that I could use ?</p>