score:6

Accepted answer

using a leftanti join would be a possible solution. this will remove rows from the left table that are present in the right table for the given key.

table1.join(table2, seq("user_id", "item_id"), "leftanti")

Related Query

More Query from same tag