[jira] [Commented] (SPARK-44873) Alter nested view fails because of HMS client

["Paul King (Jira)" <ji...@apache.org>]

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

Paul King commented on SPARK-44873:
-----------------------------------

User 'kylerong-db' has created a pull request for this issue:
https://github.com/apache/spark/pull/42566

> Alter nested view fails because of HMS client
> ---------------------------------------------
>
>                 Key: SPARK-44873
>                 URL: https://issues.apache.org/jira/browse/SPARK-44873
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 3.1.0, 3.1.1, 3.1.2, 3.2.0, 3.1.3, 3.2.1, 3.3.0, 3.2.2, 3.3.1, 3.2.3, 3.2.4, 3.3.3, 3.4.2, 3.3.2, 3.4.0, 3.4.1, 3.5.0, 3.5.1, 3.3.4
>            Reporter: Kyle Rong
>            Assignee: Kyle Rong
>            Priority: Major
>             Fix For: 3.5.0, 4.0.0
>
>
> Currently, 
> {code:java}
> CREATE OR REPLACE VIEW t AS SELECT " +
>         "struct(id AS `$col2`, struct(id AS `$col`) AS s1) AS s2 FROM RANGE(5)
> ALTER VIEW t SET TBLPROPERTIES ('x' = 'y'){code}
> would fail when calling HMS's updateTable, because HMS does not support nested struct in view. We can fix this by passing HMS an empty schema, since we store the actual view schema in the table's properties already. This fix is similar to https://github.com/apache/spark/pull/37364



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org