You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "lkl (Jira)" <ji...@apache.org> on 2022/06/22 08:42:00 UTC
[jira] [Updated] (HIVE-26347) hive-2.3.5-csvserde-add colnum报错
[ 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)