[
https://issues.apache.org/jira/browse/CARBONDATA-1143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashwini K reassigned CARBONDATA-1143:
-------------------------------------
Assignee: Ashwini K
> Incorrect Data load while loading data into struct of struct
> ------------------------------------------------------------
>
> Key: CARBONDATA-1143
> URL: https://issues.apache.org/jira/browse/CARBONDATA-1143
> Project: CarbonData
> Issue Type: Bug
> Components: data-load
> Affects Versions: 1.2.0
> Environment: spark 2.1
> Reporter: Vandana Yadav
> Assignee: Ashwini K
> Priority: Minor
> Attachments: structinstructnull.csv
>
> Time Spent: 1h 50m
> Remaining Estimate: 0h
>
> Incorrect Data load while loading data into struct of struct
> Steps to reproduce:
> 1) Create table:
> create table structinstruct(id int, structelem struct<id1:int, structelem:
> struct<id2:int, name:string>>)stored by 'carbondata';
> 2)Load data:
> load data inpath 'hdfs://localhost:54310/structinstructnull.csv' into table
> structinstruct options('delimiter'=',' ,
> 'fileheader'='id,structelem','COMPLEX_DELIMITER_LEVEL_1'='#',
> 'COMPLEX_DELIMITER_LEVEL_2'='|');
> 3)Query executed:
> select * from structinstruct;
> 4) Actual result:
> +-------+------------------------------------------------------+--+
> | id | structelem |
> +-------+------------------------------------------------------+--+
> | 1 | {"id1":111,"structelem":{"id2":1001,"name":"abc"}} |
> | 2 | {"id1":222,"structelem":{"id2":2002,"name":"xyz"}} |
> | NULL | {"id1":333,"structelem":{"id2":3003,"name":"def"}} |
> | 4 | {"id1":null,"structelem":{"id2":4004,"name":"pqr"}} |
> | 5 | {"id1":555,"structelem":{"id2":null,"name":"ghi"}} |
> | 6 | {"id1":666,"structelem":{"id2":6006,"name":"null"}} |
> | 7 | {"id1":null,"structelem":{"id2":1001,"name":null}} |
> +-------+------------------------------------------------------+--+
> 7 rows selected (1.023 seconds)
> 5) Expected Result: In last row "id2" should be null as there is no such
> value(1001) provided in csv for that
> 6) Data in CSV:
> 1,111#1001|abc
> 2,222#2002|xyz
> null,333#3003|def
> 4,null#4004|pqr
> 5,555#null|ghi
> 6,666#6006|null
> 7,null
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
