[ https://issues.apache.org/jira/browse/CARBONDATA-1679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chetan Bhat updated CARBONDATA-1679: ------------------------------------ Summary: Carbon 1.3.0-Partitioning:After Splitting the Partition,no records are displayed (was: After Splitting the Partition,no records are displayed) > Carbon 1.3.0-Partitioning: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)