[jira] [Created] (CARBONDATA-672) Complex data type is not working while fetching it from Database

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

[jira] [Created] (CARBONDATA-672) Complex data type is not working while fetching it from Database

Akash R Nilugal (Jira)
Anurag Srivastava created CARBONDATA-672:
--------------------------------------------

             Summary: Complex data type is not working while fetching it from Database
                 Key: CARBONDATA-672
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-672
             Project: CarbonData
          Issue Type: Bug
          Components: data-query
    Affects Versions: 1.0.0-incubating
         Environment: Spark - 2.1
            Reporter: Anurag Srivastava
         Attachments: complex_data_type.png, ct5.csv, log, pass_fetch.png

I created a table with an complex data type and then load data into it. Data loaded successfully but when I am trying to fetch data it is giving me error.

*Create Table :*

create table ct10(id Int,data array<Int>)stored by 'carbondata';

*Load Data :*

LOAD DATA inpath 'hdfs://localhost:54310/ct4.csv' INTO table ct1 options('DELIMITER'=',', 'FILEHEADER'='id, data','QUOTECHAR'='"','COMPLEX_DELIMITER_LEVEL_1'='#');

*Data Query :*

Select * from ct10;

*Error :*


While when we use query *select  id from ct10;*, its working fine.

I am attaching screen shot, CSV and log with it.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)