How we can convert into spark SQL?

select count(distinct md5) 
from mytestdb.test2_01dec 
where (REGEXP_REPLACE(md5,'"','')) not in (select distinct(REGEXP_REPLACE(hashemail,'"','')) from mytestdb.test1_hashemails_master)

Read more here:

Content Attribution

This content was originally published by Vamshi Krishna at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: