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: https://stackoverflow.com/questions/66276423/how-we-can-convert-into-spark-sql

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: