Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-1681

Carbon 1.3.0-Partitioning:After dropping the partition, the data is also getting dropped.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.3.0
    • None
    • sql
    • None

    Description

      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';

      Attachments

        1. drop_part1.PNG
          43 kB
          Ayushi Sharma
        2. drop_part_2.PNG
          25 kB
          Ayushi Sharma

        Activity

          People

            Unassigned Unassigned
            Ayushi_22 Ayushi Sharma
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: