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

Carbon 1.3.0-Partitioning:After Splitting the Partition,no records are displayed

    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_4 (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');

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

      show partitions part_nation_4;

      ALTER TABLE part_nation_4 SPLIT PARTITION(5) INTO('(EGYPT,ETHIOPIA)','FRANCE');

      show partitions part_nation_4;

      select * from part_nation_4 where N_NAME='FRANCE';
      select * from part_nation_4 where N_NAME='EGYPT';
      select * from part_nation_4 where N_NAME='CANADA';

        Attachments

        1. Split1.PNG
          49 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: