carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sangeeta Gulia (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CARBONDATA-1679) Carbon 1.3.0-Partitioning:After Splitting the Partition,no records are displayed
Date Thu, 14 Dec 2017 12:26:00 GMT

    [ https://issues.apache.org/jira/browse/CARBONDATA-1679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16290778#comment-16290778
] 

Sangeeta Gulia commented on CARBONDATA-1679:
--------------------------------------------

I am unable to replicate this issue. It is working correctly as per current master code.

My csv contains the below records:
0|ALGERIA|0| haggle. carefully final deposits detect slyly agai|
1|ARGENTINA|1|al foxes promise slyly according to the regular accounts. bold requests alon|
2|BRAZIL|1|y alongside of the pending deposits. carefully special packages are about the ironic
forges. slyly special |
3|CANADA|1|eas hang ironic, silent packages. slyly regular packages are furiously over the
tithes. fluffily bold|
4|EGYPT|4|y above the carefully unusual theodolites. final dugouts are quickly across the
furiously regular d|
5|ETHIOPIA|0|ven packages wake quickly. regu|
6|FRANCE|3|refully final requests. regular, ironi|
7|GERMANY|3|l platelets. regular accounts x-ray: unusual, regular acco|
8|INDIA|2|ss excuses cajole slyly across the packages. deposits print aroun|
9|INDONESIA|2| slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey
players sleep blithely. carefull|
10|IRAN|4|efully alongside of the slyly final dependencies. |
11|IRAQ|4|nic deposits boost atop the quickly final requests? quickly regula|
12|JAPAN|2|ously. final, express gifts cajole a|
13|JORDAN|4|ic deposits are blithely about the carefully regular pa|
14|KENYA|0| pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily
past t|
15|MOROCCO|0|rns. blithely bold courts among the closely regular packages use furiously bold
platelets?|
16|MOZAMBIQUE|0|s. ironic, unusual asymptotes wake blithely r|
17|PERU|1|platelets. blithely pending dependencies use fluffily across the even pinto beans.
carefully silent accoun|
18|CHINA|2|c dependencies. furiously express notornis sleep slyly regular accounts. ideas
sleep. depos|
19|ROMANIA|3|ular asymptotes are about the furious multipliers. express dependencies nag above
the ironically ironic account|
20|SAUDI ARABIA|4|ts. silent requests haggle. closely express packages sleep across the blithely|
21|VIETNAM|2|hely enticingly express accounts. even, final |
22|RUSSIA|3| requests against the platelets use never according to the quickly regular pint|
23|UNITED KINGDOM|3|eans boost carefully special requests. accounts are. carefull|
24|UNITED STATES|1|y final packages. slow foxes cajole quickly. quickly silent platelets breach
ironic accounts. unusual pinto be|

and below is my output for the queries after 
"ALTER TABLE part_nation_4 SPLIT PARTITION(5) INTO('(EGYPT,ETHIOPIA)','FRANCE');": 

+--------------------+
|           partition|
+--------------------+
| 0, n_name = DEFAULT|
| 1, n_name = ALGERIA|
|2, n_name = ARGEN...|
|  3, n_name = BRAZIL|
|  4, n_name = CANADA|
|7, n_name = EGYPT...|
|  8, n_name = FRANCE|
|   6, n_name = JAPAN|
+--------------------+

+-----------+-----------+--------------------+------+
|n_nationkey|n_regionkey|           n_comment|n_name|
+-----------+-----------+--------------------+------+
|          6|          3|refully final req...|FRANCE|
+-----------+-----------+--------------------+------+

+-----------+-----------+--------------------+------+
|n_nationkey|n_regionkey|           n_comment|n_name|
+-----------+-----------+--------------------+------+
|          4|          4|y above the caref...| EGYPT|
+-----------+-----------+--------------------+------+

+-----------+-----------+--------------------+------+
|n_nationkey|n_regionkey|           n_comment|n_name|
+-----------+-----------+--------------------+------+
|          3|          1|eas hang ironic, ...|CANADA|
+-----------+-----------+--------------------+------+

Can you please retest it again with the csv records I have provided?

> 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