Ayushi Sharma created CARBONDATA-1676:
-----------------------------------------

             Summary: No records are displayed for the newly added partition.
                 Key: CARBONDATA-1676
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1676
             Project: CarbonData
          Issue Type: Bug
          Components: sql
    Affects Versions: 1.3.0
            Reporter: Ayushi Sharma
         Attachments: AddPart.PNG, Add_part_logs.txt

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



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to