title: How to parse data in Hive by character &
body: <p>The data looks like this: </p>
  
  <pre><code>fsid=4778&amp;awid=5&amp;url=http%3a%2f%2fwww.abcd.com%2f2-03&amp;pfhid=-356847895&amp;event=Login&amp;Incorrect=False
  fsid=3478&amp;awid=5&amp;url=http%3a%2f%2fwww.abcd.com%2f2-03&amp;pfhid=-356847895&amp;event=Login&amp;userid=10598&amp;Incorrect=False
  </code></pre>
  
  <p>I want to see how many fsid I have in total and how many userid in total, a lot of records have userid missing. 
  I am using Hive, maybe it's not the best approach, I know how to do this in python if this is a flat text file. 
  Thank you. </p>