[
https://issues.apache.org/jira/browse/HIVE-26347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
lkl updated HIVE-26347:
-----------------------
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.
was:
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);
> hive-2.3.5-csvserde-add colnum报错
> --------------------------------
>
> Key: HIVE-26347
> URL: https://issues.apache.org/jira/browse/HIVE-26347
> Project: Hive
> Issue Type: Bug
> Components: JDBC, Query Planning, Serializers/Deserializers
> Affects Versions: 2.3.5, 2.3.7
> Reporter: lkl
> Priority: Major
>
> 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.
>
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
