[jira] [Created] (CARBONDATA-1681) After dropping the partition, the data is also getting dropped.

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (CARBONDATA-1681) After dropping the partition, the data is also getting dropped.

Akash R Nilugal (Jira)
Ayushi Sharma created CARBONDATA-1681:
-----------------------------------------

             Summary: After dropping the partition, the data is also getting dropped.
                 Key: CARBONDATA-1681
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1681
             Project: CarbonData
          Issue Type: Bug
          Components: sql
    Affects Versions: 1.3.0
            Reporter: Ayushi Sharma
         Attachments: drop_part1.PNG, drop_part_2.PNG

create table part_nation_drop (N_NATIONKEY BIGINT,N_REGIONKEY BIGINT,N_COMMENT STRING) partitioned by (N_NAME STRING) stored by 'carbondata' tblproperties('partition_type'='list','list_info'='ALGERIA,ARGENTINA,BRAZIL,CANADA,(EGYPT,ETHIOPIA,FRANCE),JAPAN');

show partitions part_nation_drop;

load data inpath '/spark-warehouse/tpchhive.db/nation/nation.tbl' into table part_nation_drop options('DELIMITER'='|','FILEHEADER'='N_NATIONKEY,N_NAME,N_REGIONKEY,N_COMMENT');

select * from part_nation_drop where N_Name='ALGERIA';

ALTER TABLE part_nation_drop DROP PARTITION(1);

select * from part_nation_drop where N_Name='ALGERIA';



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)