You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Liang Chen (JIRA)" <ji...@apache.org> on 2017/09/04 14:07:00 UTC
[jira] [Commented] (CARBONDATA-1416) Show Segments raises exception
for a Partition Table after Updation.
[ https://issues.apache.org/jira/browse/CARBONDATA-1416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16152643#comment-16152643 ]
Liang Chen commented on CARBONDATA-1416:
----------------------------------------
[~nehabhardwaj] please verify this issue with pull request 1304, see if it is ok?
> Show Segments raises exception for a Partition Table after Updation.
> --------------------------------------------------------------------
>
> Key: CARBONDATA-1416
> URL: https://issues.apache.org/jira/browse/CARBONDATA-1416
> Project: CarbonData
> Issue Type: Bug
> Components: data-query
> Environment: spark 2.1
> Reporter: Neha Bhardwaj
> 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)