[CARBONDATA-4303] Columns mismatch when insert into table with static partition

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.3.0
• Component/s: spark-integration
• Assignee: Unassigned
• Reporter: Yahui Liu
• Created: 12/Oct/21 03:18
• Updated: 26/Oct/21 05:29
• Resolved: 26/Oct/21 05:29

Description

Following insert will have null value:

CREATE TABLE select_from (i int, b string) stored as carbondata;

CREATE TABLE table1 (i int) partitioned by (a int, b string) stored as carbondata;

insert into table select_from select 1, 'a';

insert into table table1 partition(a='100',b) select 1, b from select_from;

select * from table1;

Expected:

1, 100, a

Actual result:

1, 100, null