[
https://issues.apache.org/jira/browse/SPARK-50322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Max Gekk updated SPARK-50322:
-----------------------------
Description:
The example below portraits the issue:
{code:sq}
create table tt1(c1 int);
insert into tt1 values (1);
execute immediate 'with v1 as (select * from tt1 where 1 = (Select * from
identifier(:tab))) select * from v1' using 'tt1' as tab;
[UNBOUND_SQL_PARAMETER] Found the unbound parameter: tab. Please, fix `args`
and provide a mapping of the parameter to either a SQL literal or collection
constructor functions such as `map()`, `array()`, `struct()`. SQLSTATE: 42P02;
line 1 pos 66;
'Project [*]
+- 'SubqueryAlias v1
+- 'SubqueryAlias v1
+- 'Project [*]
+- 'Filter (1 = scalar-subquery#10 [])
: +- 'Project [*]
: +- 'PlanWithUnresolvedIdentifier namedparameter(tab),
org.apache.spark.sql.catalyst.parser.AstBuilder$$Lambda$3404/0x000000f802380000@45ec7633
+- SubqueryAlias spark_catalog.default.tt1
+- Relation spark_catalog.default.tt1[c1#4] parquet
{code}
was:
The example below portraits the issue:
```
create table tt1(c1 int);
insert into tt1 values (1);
execute immediate 'with v1 as (select * from tt1 where 1 = (Select * from
identifier(:tab))) select * from v1' using 'tt1' as tab;
[UNBOUND_SQL_PARAMETER] Found the unbound parameter: tab. Please, fix `args`
and provide a mapping of the parameter to either a SQL literal or collection
constructor functions such as `map()`, `array()`, `struct()`. SQLSTATE: 42P02;
line 1 pos 66;
'Project [*]
+- 'SubqueryAlias v1
+- 'SubqueryAlias v1
+- 'Project [*]
+- 'Filter (1 = scalar-subquery#10 [])
: +- 'Project [*]
: +- 'PlanWithUnresolvedIdentifier namedparameter(tab),
org.apache.spark.sql.catalyst.parser.AstBuilder$$Lambda$3404/0x000000f802380000@45ec7633
+- SubqueryAlias spark_catalog.default.tt1
+- Relation spark_catalog.default.tt1[c1#4] parquet
```
> Cannot resolve parameterized identifier in a sub-query
> ------------------------------------------------------
>
> Key: SPARK-50322
> URL: https://issues.apache.org/jira/browse/SPARK-50322
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 4.0.0
> Reporter: Max Gekk
> Assignee: Max Gekk
> Priority: Major
>
> The example below portraits the issue:
> {code:sq}
> create table tt1(c1 int);
> insert into tt1 values (1);
> execute immediate 'with v1 as (select * from tt1 where 1 = (Select * from
> identifier(:tab))) select * from v1' using 'tt1' as tab;
> [UNBOUND_SQL_PARAMETER] Found the unbound parameter: tab. Please, fix `args`
> and provide a mapping of the parameter to either a SQL literal or collection
> constructor functions such as `map()`, `array()`, `struct()`. SQLSTATE:
> 42P02; line 1 pos 66;
> 'Project [*]
> +- 'SubqueryAlias v1
> +- 'SubqueryAlias v1
> +- 'Project [*]
> +- 'Filter (1 = scalar-subquery#10 [])
> : +- 'Project [*]
> : +- 'PlanWithUnresolvedIdentifier namedparameter(tab),
> org.apache.spark.sql.catalyst.parser.AstBuilder$$Lambda$3404/0x000000f802380000@45ec7633
> +- SubqueryAlias spark_catalog.default.tt1
> +- Relation spark_catalog.default.tt1[c1#4] parquet
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
