Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-26347

hive-2.3.5-csvserde-add colnum报错

    XMLWordPrintableJSON

Details

    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.

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            liukailong123 lkl
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: