Ayushi Sharma created CARBONDATA-1679:
-----------------------------------------
Summary: After Splitting the Partition,no records are displayed
Key: CARBONDATA-1679
URL: https://issues.apache.org/jira/browse/CARBONDATA-1679
Project: CarbonData
Issue Type: Bug
Components: sql
Affects Versions: 1.3.0
Reporter: Ayushi Sharma
Attachments: Split1.PNG
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';
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
