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

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.3.0
    • Fix Version/s: None
    • Component/s: sql
    • Labels:
      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_part_2.PNG
          25 kB
          Ayushi Sharma
        2. drop_part1.PNG
          43 kB
          Ayushi Sharma

          Activity

            People

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

              Dates

              • Created:
                Updated: