dtenedor opened a new pull request, #49420: URL: https://github.com/apache/spark/pull/49420
### What changes were proposed in this pull request? Per initial feedback from testing, users would like table aliases (such as those mapping to left and right side inputs to a prior join) to remain available after SET, DROP, and EXTEND operators. Here is an example that should work: ``` values (0), (1) lhs(a) |> inner join values (1), (2) rhs(a) using (a) |> extend lhs.a + rhs.a as z1 |> extend lhs.a - rhs.a as z2 |> drop z1 |> where z2 = 0 |> order by lhs.a, rhs.a, z2 |> set z2 = 4 |> limit 2 |> select lhs.a, rhs.a, z2; 1 1 4 ``` ### Why are the changes needed? This makes SQL pipe syntax easier to use. ### Does this PR introduce _any_ user-facing change? Yes, see above. ### How was this patch tested? This PR adds and updates golden file based testing. ### Was this patch authored or co-authored using generative AI tooling? No. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
