title: Extracting email_address from a string in hive
body: <p>I am new to hive
  I have a string and I want to extract the email address from that string in hive</p>
  <pre><code>Select regexp_extract('my email address is xxxxxx@gmail.com', '@(.*)',0);
  OK
  @gmail.com
  </code></pre>
  <p>It is only extracting the domain name but I need the full email address i.e. 'xxxxxx@gmail.com'</p>
  <p>I an new to regex</p>