[SPARK-48966] Improve error message with invalid unresolved column reference in UDTF call

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Daniel
• Reporter: Daniel
• Created: 22/Jul/24 18:53
• Updated: 15/Aug/24 23:22
• Resolved: 15/Aug/24 23:22

Description

This bug covers improving an error message in the event of invalid UDTF calls. For example:

select * from udtf(
  observed => TABLE(select column from t),
  value_col => classic_dollars
)

Currently we get:

Unsupported subquery expression: Table arguments are used in a function where they are not supported:
'UnresolvedTableValuedFunction [udtf], observed => table-argument#68918 [], value_col => 'classic_dollars, false
   +- Project ...
       +- SubqueryAlias ...
          +- Relation ...

But the real error is that the user passed column identifier classic_dollars rather than string "classic_dollars" into the string argument.

The core reason is that CheckAnalysis checks the analyzer output tree for unresolved nodes at the end rather than reporting the error at the time of attempted resolving of the corresponding expression or operator (in this case, the unresolved attribute reference resulting from the unquoted classic_dollars).

Issue Links

• links to: GitHub Pull Request #47447