3 ms·
i rarely ever use exists and prefer to do left joins or left semi joins (in spark) i'm not exactly sure what you're asking though, in terms of sql generation,
by captaintobs 4y ago
i rarely ever use exists and prefer to do left joins or left semi joins (in spark)
i'm not exactly sure what you're asking though, in terms of sql generation, it's not difficult for me because i just take in sql and output sql from the ast
- zasdffaa 4y agoExists can be very efficient as it allows execution to stop immediately when something is found.