[Bug] SERDEPROPERTIES are missing when KSHC create table

[maomaodev]

Code of Conduct

• I agree to follow this project's Code of Conduct

Search before asking

• I have searched in the issues and found no similar issues.

Describe the bug

1. Execute the following SQL to create table and insert.

CREATE TABLE test_table (name STRING, age INT)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES ('field.delim' = ',')
STORED AS TEXTFILE;

INSERT INTO TABLE test_table VALUES ('alice', 30);

2. Check the underlying HDFS data. Output is alice30, Expected is alice,30

hdfs dfs -cat /usr/hive/warehouse/test_table/part-00000-08cdc3f0-15af-413a-a709-46e24f1ace91-c000

3. Cause: SERDEPROPERTIES are missing when KSHC create table, it did not strip the option. prefix. See: [SPARK-31257][SPARK-33561][SQL] Unify create table syntax spark#28026

Affects Version(s)

master

Kyuubi Server Log Output

Kyuubi Engine Log Output

Kyuubi Server Configurations

Kyuubi Engine Configurations

Additional context

No response

Are you willing to submit PR?

• Yes. I would be willing to submit a PR with guidance from the Kyuubi community to fix.
• No. I cannot submit a PR at this time.