[
https://issues.apache.org/jira/browse/SPARK-52261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Max Gekk updated SPARK-52261:
-----------------------------
Description:
The code below raises the misleading error:
{code:java}
[INVALID_USAGE_OF_STAR_OR_REGEX] Invalid usage of '*' in Project. SQLSTATE:
42000; line 7 pos 9;
{code}
{code:sql}
with foo as (
values ("one", 1), ("two", 2), ("three", 3) as a (str, num)
union all
values ("four"), ("five"), ("six") as b (str)
),
bar as (
select * from foo
)
select * from foo
{code}
The error is not caused by '*' usage, and should be similar to:
{code:sql}
with foo as (
values ("one", 1), ("two", 2), ("three", 3) as a (str, num)
union all
values ("four"), ("five"), ("six") as b (str)
)
select * from foo
{code}
{code:java}
[NUM_COLUMNS_MISMATCH] UNION can only be performed on inputs with the same
number of columns, but the first input has 2 columns and the second input has 1
columns. SQLSTATE: 42826; line 2 pos 2;
{code}
was:
The code below raises the misleading error:
{code:java}
[INVALID_USAGE_OF_STAR_OR_REGEX] Invalid usage of '*' in Project. SQLSTATE:
42000; line 7 pos 9;
{code}
{code:sql}
sql(
"""with foo as (
| values ("one", 1), ("two", 2), ("three", 3) as a (str, num)
| union all
| values ("four"), ("five"), ("six") as b (str)
|),
|bar as (
| select * from foo
|)
|select * from foo
|""".stripMargin).collect()
{code}
The error is not caused by '*' usage, and should be similar to:
{code:sql}
sql(
"""with foo as (
| values ("one", 1), ("two", 2), ("three", 3) as a (str, num)
| union all
| values ("four"), ("five"), ("six") as b (str)
|)
|select * from foo
|""".stripMargin).collect()
{code}
{code:java}
[NUM_COLUMNS_MISMATCH] UNION can only be performed on inputs with the same
number of columns, but the first input has 2 columns and the second input has 1
columns. SQLSTATE: 42826; line 2 pos 2;
{code}
> Misleading error: Invalid usage of '*'
> --------------------------------------
>
> Key: SPARK-52261
> URL: https://issues.apache.org/jira/browse/SPARK-52261
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 4.0.0
> Reporter: Max Gekk
> Priority: Major
>
> The code below raises the misleading error:
> {code:java}
> [INVALID_USAGE_OF_STAR_OR_REGEX] Invalid usage of '*' in Project. SQLSTATE:
> 42000; line 7 pos 9;
> {code}
> {code:sql}
> with foo as (
> values ("one", 1), ("two", 2), ("three", 3) as a (str, num)
> union all
> values ("four"), ("five"), ("six") as b (str)
> ),
> bar as (
> select * from foo
> )
> select * from foo
> {code}
> The error is not caused by '*' usage, and should be similar to:
> {code:sql}
> with foo as (
> values ("one", 1), ("two", 2), ("three", 3) as a (str, num)
> union all
> values ("four"), ("five"), ("six") as b (str)
> )
> select * from foo
> {code}
> {code:java}
> [NUM_COLUMNS_MISMATCH] UNION can only be performed on inputs with the same
> number of columns, but the first input has 2 columns and the second input has
> 1 columns. SQLSTATE: 42826; line 2 pos 2;
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
