title: Hive Extract Data in a Array
body: <p>I need to extract the 5th value from data string array in Hive,</p>
  
  <pre><code>arr = ("abc", "123-4567", "10", "ax", "cdpp asd", "00", "q", "na", "avail", "n", "n", "na")
  </code></pre>
  
  <p>How can I extract <code>"cdpp asd"</code> ie 5th value.</p>
  
  <p>We can use <code>SUBSTR</code>, and <code>INSTR</code> but is there any other way to achieve this?  </p>