[jira] [Commented] (SPARK-44577) INSERT BY NAME returns non-sensical error message

2023-07-31 Thread ASF GitHub Bot (Jira) 


[ 
https://issues.apache.org/jira/browse/SPARK-44577?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17749089#comment-17749089
 ] 

ASF GitHub Bot commented on SPARK-44577:


User 'Hisoka-X' has created a pull request for this issue:
https://github.com/apache/spark/pull/42220

> INSERT BY NAME returns non-sensical error message
> -
>
> Key: SPARK-44577
> URL: https://issues.apache.org/jira/browse/SPARK-44577
> Project: Spark
>  Issue Type: Bug
>  Components: Spark Core
>Affects Versions: 3.4.0
>Reporter: Serge Rielau
>Priority: Major
>
> CREATE TABLE bug(c1 INT);
> INSERT INTO bug BY NAME SELECT 1 AS c2;
> ==> Multi-part identifier cannot be empty.



--
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

[jira] [Commented] (SPARK-44577) INSERT BY NAME returns non-sensical error message

2023-07-28 Thread Jia Fan (Jira) 


[ 
https://issues.apache.org/jira/browse/SPARK-44577?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17748772#comment-17748772
 ] 

Jia Fan commented on SPARK-44577:
-

https://github.com/apache/spark/pull/42220

> INSERT BY NAME returns non-sensical error message
> -
>
> Key: SPARK-44577
> URL: https://issues.apache.org/jira/browse/SPARK-44577
> Project: Spark
>  Issue Type: Bug
>  Components: Spark Core
>Affects Versions: 3.4.0
>Reporter: Serge Rielau
>Priority: Major
>
> CREATE TABLE bug(c1 INT);
> INSERT INTO bug BY NAME SELECT 1 AS c2;
> ==> Multi-part identifier cannot be empty.



--
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

[jira] [Commented] (SPARK-44577) INSERT BY NAME returns non-sensical error message

2023-07-28 Thread Jia Fan (Jira) 


[ 
https://issues.apache.org/jira/browse/SPARK-44577?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17748769#comment-17748769
 ] 

Jia Fan commented on SPARK-44577:
-

Let me fix this, thanks for report.

> INSERT BY NAME returns non-sensical error message
> -
>
> Key: SPARK-44577
> URL: https://issues.apache.org/jira/browse/SPARK-44577
> Project: Spark
>  Issue Type: Bug
>  Components: Spark Core
>Affects Versions: 3.4.0
>Reporter: Serge Rielau
>Priority: Major
>
> CREATE TABLE bug(c1 INT);
> INSERT INTO bug BY NAME SELECT 1 AS c2;
> ==> Multi-part identifier cannot be empty.



--
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

[jira] [Commented] (SPARK-44577) INSERT BY NAME returns non-sensical error message

2023-07-28 Thread Linhong Liu (Jira) 


[ 
https://issues.apache.org/jira/browse/SPARK-44577?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17748745#comment-17748745
 ] 

Linhong Liu commented on SPARK-44577:
-

[~fanjia] could you make a followup PR to fix this?

The error is at: 
[https://github.com/apache/spark/blob/master/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/analysis/TableOutputResolver.scala#L243]

we should do something like:

```

val pathInfo = if (colPath.empty) {

  "table"

} else {

  s"struct ${colPath.quoted}"

}

throw QueryCompilationErrors.incompatibleDataToTableExtraStructFieldsError(
     tableName,

    pathInfo,   // the changes

    extraCols
)

```

> INSERT BY NAME returns non-sensical error message
> -
>
> Key: SPARK-44577
> URL: https://issues.apache.org/jira/browse/SPARK-44577
> Project: Spark
>  Issue Type: Bug
>  Components: Spark Core
>Affects Versions: 3.4.0
>Reporter: Serge Rielau
>Priority: Major
>
> CREATE TABLE bug(c1 INT);
> INSERT INTO bug BY NAME SELECT 1 AS c2;
> ==> Multi-part identifier cannot be empty.



--
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

[jira] [Commented] (SPARK-44577) INSERT BY NAME returns non-sensical error message

2023-07-28 Thread Linhong Liu (Jira) 


[ 
https://issues.apache.org/jira/browse/SPARK-44577?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17748746#comment-17748746
 ] 

Linhong Liu commented on SPARK-44577:
-

cc [~cloud_fan] 

> INSERT BY NAME returns non-sensical error message
> -
>
> Key: SPARK-44577
> URL: https://issues.apache.org/jira/browse/SPARK-44577
> Project: Spark
>  Issue Type: Bug
>  Components: Spark Core
>Affects Versions: 3.4.0
>Reporter: Serge Rielau
>Priority: Major
>
> CREATE TABLE bug(c1 INT);
> INSERT INTO bug BY NAME SELECT 1 AS c2;
> ==> Multi-part identifier cannot be empty.



--
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