[
https://issues.apache.org/jira/browse/SPARK-48966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyukjin Kwon resolved SPARK-48966.
----------------------------------
Fix Version/s: 4.0.0
Resolution: Fixed
Issue resolved by pull request 47447
[https://github.com/apache/spark/pull/47447]
> Improve error message with invalid unresolved column reference in UDTF call
> ---------------------------------------------------------------------------
>
> Key: SPARK-48966
> URL: https://issues.apache.org/jira/browse/SPARK-48966
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 4.0.0
> Reporter: Daniel
> Assignee: Daniel
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0
>
>
> 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{}}}).
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
