carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chetan Bhat (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CARBONDATA-1679) Carbon 1.3.0-Partitioning:After Splitting the Partition,no records are displayed
Date Fri, 17 Nov 2017 14:33:01 GMT

     [ 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)

Mime
View raw message