[SPARK-46908] Extend SELECT * support outside of select list

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: Spark Core
• Labels: SQL pull-request-available
• Assignee: Serge Rielau
• Reporter: Serge Rielau
• Shepherd: Wenchen Fan
• Created: 29/Jan/24 20:29
• Updated: 02/Feb/24 01:20
• Resolved: 02/Feb/24 01:20

Description

Traditionally * is confined to thr select list and there to the top level of expressions.
Spark does, in an undocumented fashion support * in the SELECT list for function argument list.
Here we want to expand upon this capability by adding the WHERE clause (Filter) as well as a couple of more scenarios such as row value constructors and IN operator.

Issue Links

• links to: GitHub Pull Request #44938