title: Hive: Split string using regexp as a separate column
body: <p>I have a string in a text column. I want to extract the hashtag values from the string into a new table so that I can find the distinct count for each hashtag.  </p>
  
  <p>Example strings-></p>
  
  <blockquote>
    <p>NeverTrump is never more. They were crushed last night in Cleveland at
    Rules Committee by a vote of 87-12. MAKE AMERICA GREAT AGAIN!</p>
    
    <p>CrookedHillary is outspending me by a combined 31 to 1 in Florida,
    Ohio, &amp; Pennsylvania. I haven't started yet! </p>
    
    <p>CrookedHillary is not qualified!</p>
    
    <p>MakeAmericaSafeAgain!#GOPConvention #RNCinCLE </p>
    
    <p>MakeAmericaGreatAgain #ImWithYou</p>
  </blockquote>