[
https://issues.apache.org/jira/browse/CARBONDATA-4031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kejian Li updated CARBONDATA-4031:
----------------------------------
Summary: Deleted data on the partition come back after inserting overwrite
on the other partition (was: Deleted data on the partition come back after
inserting overwrite on that partition)
> Deleted data on the partition come back after inserting overwrite on the
> other partition
> ----------------------------------------------------------------------------------------
>
> Key: CARBONDATA-4031
> URL: https://issues.apache.org/jira/browse/CARBONDATA-4031
> Project: CarbonData
> Issue Type: Bug
> Components: data-query
> Affects Versions: 2.0.0
> Reporter: Kejian Li
> Priority: Critical
> Fix For: 2.1.0
>
>
> There is a table with two partitions. User deletes some records on one of
> partitions and then inserts overwrite the other partition. Deleted records on
> the previous partition comes back.
> 1. CREATE TABLE sdl.s_x034_carbon (guid STRING, sales_guid STRING,
> dt BIGINT) STOED AS carbondata PARTITIONED BY (dt)
> 2. select * from s_x034_carbon where dt=20200907 limit 5;
> 3. select dt, count(1) from s_x034_carbon group by dt;
> 4. delete from s_x034_carbon where dt= 20200907 and
> guid='595E1862D81A09D0E1008000AC1E0124';
> 5. select dt, count(1) from s_x034_carbon group by dt;
> 6. insert overwrite table s_x034_carbon partition (dt=20200908)
> select a.guid as guid, a.sales_guid as sales_guid from s_x034_carbon a
> where dt = 20200907;
> 7. select dt, count(1) from s_x034_carbon group by dt;
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
