Ravindra Pesala created CARBONDATA-2197:
-------------------------------------------

             Summary: Standard partition issues
                 Key: CARBONDATA-2197
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2197
             Project: CarbonData
          Issue Type: Bug
            Reporter: Ravindra Pesala


create table comp_dt2(id int,name string) partitioned by (dt date,c4 int) 
stored by 'carbondata';
insert into comp_dt2 select 1,'A','2001-01-01',1;
insert into comp_dt2 select 2,'B','2001-01-01',1;
insert into comp_dt2 select 3,'C','2002-01-01',2;
insert into comp_dt2 select 4,'D','2002-01-01',null;
select * from comp_dt2;
Alter table comp_dt2 compact 'minor';
select * from comp_dt2;
show segments for table comp_dt2;
clean files for table comp_dt2;
select * from comp_dt2;
insert into comp_dt2 select 5,'E','2003-01-01',3;
insert into comp_dt2 select 6,'F','2003-01-01',3;
insert into comp_dt2 select 7,'G','2003-01-01',4;
insert into comp_dt2 select 8,'H','2004-01-01','';
select * from comp_dt2;
Alter table comp_dt2 compact 'minor';
clean files for table comp_dt2;
select * from comp_dt2;
show segments for table comp_dt2;
select * from comp_dt2;
insert into comp_dt2 select 9,'H','2001-01-01',1;
insert into comp_dt2 select 10,'I','2002-01-01',null;
insert into comp_dt2 select 11,'J','2003-01-01',4;
insert into comp_dt2 select 12,'K','2003-01-01',5;
select * from comp_dt2;
Alter table comp_dt2 compact 'minor';
show segments for table comp_dt2;
select * from comp_dt2;
clean files for table comp_dt2;
select * from comp_dt2;
insert into comp_dt2 select 13,'L','2004-01-01';
select * from comp_dt2;
Alter table comp_dt2 compact 'major';
select * from comp_dt2;
show segments for table comp_dt2;
select * from comp_dt2;



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to