lkl created HIVE-26347:
--------------------------

             Summary: 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.7, 2.3.5
            Reporter: lkl


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);



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

Reply via email to