[HIVE-26347] hive-2.3.5-csvserde-add colnum报错

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.3.5, 2.3.7
• Component/s: JDBC, Query Planning, Serializers/Deserializers
• Assignee: Unassigned
• Reporter: lkl
• Created: 22/Jun/22 08:37
• Updated: 22/Jun/22 08:41

Description

reproduce like below:

 

drop table trrr2;
CREATE  TABLE  IF NOT EXISTS `trrr2` (`id` string,`name` string)  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'  TBLPROPERTIES ('rowformat'='SERDE','serdelibclass'='org.apache.hadoop.hive.serde2.OpenCSVSerde','outputformatclass'='org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat','inputformatclass'='org.apache.hadoop.mapred.TextInputFormat','serdename'='org.apache.hadoop.hive.serde2.OpenCSVSerde');

ALTER TABLE trrr2 add columns(abc string);

 

error msg below:

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. java.lang.IllegalArgumentException: Error: type expected at the position 0 of '<derived from deserializer>' but '<' is found.