[jira] [Created] (HUDI-3237) ALTER TABLE column type change fails select query

["Raymond Xu (Jira)" <ji...@apache.org>]

Raymond Xu created HUDI-3237:
--------------------------------

             Summary: ALTER TABLE column type change fails select query
                 Key: HUDI-3237
                 URL: https://issues.apache.org/jira/browse/HUDI-3237
             Project: Apache Hudi
          Issue Type: Bug
    Affects Versions: 0.10.1
            Reporter: Raymond Xu
            Assignee: Yann Byron
             Fix For: 0.11.0


{code:sql}
create table if not exists cow_nonpt_nonpcf_tbl (
  id int,
  name string,
  price double
) using hudi
options (
  type = 'cow',
  primaryKey = 'id'
);

insert into cow_nonpt_nonpcf_tbl select 1, 'a1', 20;

ALTER TABLE cow_nonpt_nonpcf_tbl alter column id comment "primary id";

DESC cow_nonpt_nonpcf_tbl;

-- this works fine so far

ALTER TABLE cow_nonpt_nonpcf_tbl alter column name comment "name column";

DESC cow_nonpt_nonpcf_tbl;

-- this saves the comment for name column
-- but comment for id column was reverted back to NULL

{code}

reported while testing on 0.10.1-rc1 (spark 3.0.3, 3.1.2)




--
This message was sent by Atlassian Jira
(v8.20.1#820001)