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

Carbon 1.3.0-Partitioning:No records are displayed for the newly added partition.

    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 (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 options('DELIMITER'='|','FILEHEADER'='N_NATIONKEY,N_NAME,N_REGIONKEY,N_COMMENT');

      show partitions part_nation

      select * from part_nation where N_NAME='Germany';

      ALTER TABLE part_nation ADD PARTITION('GERMANY');

      select * from part_nation where N_NAME='GERMANY';

        Attachments

        1. Add_part_logs.txt
          8 kB
          Ayushi Sharma
        2. AddPart.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: