[SPARK-40829] STORED AS serde in CREATE TABLE LIKE view does not work

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0, 3.2.2, 3.4.0
• Fix Version/s: 3.2.3, 3.3.2, 3.4.0
• Component/s: SQL
• Assignee: Butao Zhang
• Reporter: Butao Zhang
• Created: 18/Oct/22 07:06
• Updated: 18/Oct/22 22:44
• Resolved: 18/Oct/22 21:56

Description

SPARK-29839 added the feat for supporting STORED AS in CREATE TABLE LIKE, and we could use this syntax to create a table with specified serde based on a existing table or view.

I found that if we create a table based on a view, the serde of created table is always parquet.  However, if we use USING syntax  (SPARK-29421) to create a table with specified serde based a view, we can get the correct serde.

I think we shoud fix this to add specified serde for the created table when using create table like view stored as syntax.

 

Issue Links

• relates to: SPARK-29839 Supporting STORED AS in CREATE TABLE LIKE
• links to: [Github] Pull Request #38295 (zhangbutao)
• links to: [Github] Pull Request #38295 (zhangbutao)