[HUDI-5759] Hudi do not support add column on mor table with log

• Type: Bug
• Status: Open
• Priority: Blocker
• Resolution: Unresolved
• Fix Version/s: 0.14.0
• Component/s: spark
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Qijun Fu
• Created: 10/Feb/23 02:44
• Updated: 23/May/23 05:35

Description

We test the following sqls in the latest master branch 

```sql

create table h0 (
  id int,
  name string,
  price double,
  ts long
) using hudi
 options (
  primaryKey ='id',
  type = 'mor',
  preCombineField = 'ts'
 )
 partitioned by(ts)
 location '/tmp/h0';

insert into h0 select 1, 'a1', 10, 1000;
update h0 set price = 20 where id = 1;

alter table h0 add column new_col1 int;
update h0 set price = 22 where id = 1;
select * from h0;

```

And found that we can't read the table after add column and update. 

Issue Links

• links to: GitHub Pull Request #7915