[SPARK-44873] Alter nested view fails because of HMS client

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 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
• Fix Version/s: 3.5.0, 4.0.0
• Component/s: SQL
• Assignee: Kyle Rong
• Reporter: Kyle Rong
• Shepherd: Gengliang Wang
• Created: 18/Aug/23 16:30
• Updated: 19/Aug/23 01:34
• Resolved: 18/Aug/23 18:07

Description

Currently, 

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

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

Issue Links

• links to: [Github] Pull Request #42566 (kylerong-db)