Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.3.0
-
None
-
None
Description
create table part_nation_drop (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');
show partitions part_nation_drop;
load data inpath '/spark-warehouse/tpchhive.db/nation/nation.tbl' into table part_nation_drop options('DELIMITER'='|','FILEHEADER'='N_NATIONKEY,N_NAME,N_REGIONKEY,N_COMMENT');
select * from part_nation_drop where N_Name='ALGERIA';
ALTER TABLE part_nation_drop DROP PARTITION(1);
select * from part_nation_drop where N_Name='ALGERIA';