Question 292414 in Amazon Web Sevices Question posted in
The official Amazon Web Services documentation can be found here.

Amazon web services – How to extract domain from Email Address in Athena

I am trying to select domain name from an email address using Athena but my noob glasses cant find the translation that works.

As per my understanding the following should work but the required functions are missing in Athena

(SUBSTRING_INDEX(SUBSTR(sd_ccode, strpos(sd_ccode, '@') + 1),'.',1)) as Domain

would you know how these functions translate in Athena ?

Tags:

2

Answers


  1. 0

    You can use the split_part function, as in:

    select emailaddress , split_part(emailaddress,'@',2)
from table1
    Login or Signup to reply.
  2. 0

    One more method using regexp_extract function:

    regexp_extract(emailaddress ,'@(.*)',1)

    Regex '@(.*)' here is a capturing group after @ containing any number of characters

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search