[jira] [Commented] (CARBONDATA-1414) Show Segments raises exception for a Partition Table after Updation.

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (CARBONDATA-1414) Show Segments raises exception for a Partition Table after Updation.

Akash R Nilugal (Jira)

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

Liang Chen commented on CARBONDATA-1414:
----------------------------------------

[~nehabhardwaj] please verify if pull request 1304 fix this issue or not ?

> Show Segments raises exception for a Partition Table after Updation.
> --------------------------------------------------------------------
>
>                 Key: CARBONDATA-1414
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1414
>             Project: CarbonData
>          Issue Type: Bug
>          Components: data-query
>         Environment: spark 2.1
>            Reporter: Neha Bhardwaj
>            Assignee: Liang Chen
>         Attachments: list_partition_table.csv
>
>
> 1. Create Partition Table :
> DROP TABLE IF EXISTS list_partition_table_string;
>  CREATE TABLE list_partition_table_string(shortField SHORT, intField INT, bigintField LONG, doubleField DOUBLE, timestampField TIMESTAMP, decimalField DECIMAL(18,2), dateField DATE, charField CHAR(5), floatField FLOAT, complexData ARRAY<STRING> ) PARTITIONED BY (stringField STRING) STORED BY 'carbondata' TBLPROPERTIES('PARTITION_TYPE'='LIST', 'LIST_INFO'='Asia, America, Europe', 'DICTIONARY_EXCLUDE'='stringfield');
> 2. Load Data :
> load data inpath 'hdfs://localhost:54310/CSV/list_partition_table.csv' into table list_partition_table_string options('FILEHEADER'='shortfield,intfield,bigintfield,doublefield,stringfield,timestampfield,decimalfield,datefield,charfield,floatfield,complexdata', 'COMPLEX_DELIMITER_LEVEL_1'='$','COMPLEX_DELIMITER_LEVEL_2'='#', 'SINGLE_PASS'='TRUE');
> 3. Update Data :
> update list_partition_table_string set (stringfield)=('China') where stringfield = 'Japan' ;
>  update list_partition_table_string set (stringfield)=('Japan') where stringfield > 'Europe' ;
>  update list_partition_table_string set (stringfield)=('Asia') where stringfield < 'Europe' ;
> 4. Compaction :
> ALTER TABLE list_partition_table_string COMPACT 'Minor';
>  Show segments for table list_partition_table_string;
> Expected Output: Segments Must be Displayed.
> Actual Output : Error: java.lang.NullPointerException (state=,code=0)



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