CODEWITHSUNDEEP
azure-data-lakeu-sql
Refi
Refi

Reputation: 79

U-SQL correlated subquery

Is it possible to execute some sort of a query in U-SQL where you have an inner subsquery referencing each row in the outer query?

Upvotes: 0

Views: 211

Answers (2)

Michael Rys
Michael Rys

Reputation: 6684

U-SQL does not provide correlated subqueries. Best is to rewrite them into joins or semijoins as pointed out by Joel and Dragan.

Upvotes: 1

Joel Cochran
Joel Cochran

Reputation: 7738

SEMIJOIN is the U-SQL version of T-SQL "IN", and ANTISEMIJOIN is "NOT IN". Can you provide more details about your specific use case?

Upvotes: 0

Related Questions