Hi , I have 4 parquet files and I want to find data which is common in all of them e.g
SELECT TableA.*, TableB.*, TableC.*, TableD.* FROM (TableB INNER JOIN TableA ON TableB.aID= TableA.aID) INNER JOIN TableC ON(TableB.cID= Tablec.cID) INNER JOIN TableA ta ON(ta.dID= TableD.dID) WHERE (DATE(TableC.date)=date(now())) I can do a 2 files join like - val joinedVal = g1.join(g2,g1.col("kmer") === g2.col("kmer")) But I am trying to find common kmer strings from 4 files. Thanks Roni