[CARBONDATA-1676] Carbon 1.3.0-Partitioning:No records are displayed for the newly added partition.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.3.0
• Component/s: sql
• Assignee: Unassigned
• Reporter: Ayushi Sharma
• Created: 08/Nov/17 10:58
• Updated: 09/Jan/18 07:13

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