[jira] [Created] (CARBONDATA-1143) Incorrect Data load while loading data into struct of struct

["Vandana Yadav (JIRA)" <ji...@apache.org>]

Vandana Yadav created CARBONDATA-1143:
-----------------------------------------

             Summary: 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
            Priority: Minor
         Attachments: structinstructnull.csv

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.3.15#6346)