[
https://issues.apache.org/jira/browse/CARBONDATA-672?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anurag Srivastava updated CARBONDATA-672:
-----------------------------------------
Description:
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 :*
!
https://issues.apache.org/jira/secure/attachment/12848539/complex_data_type.png!While when we use query *select id from ct10;*, its working fine.
!
https://issues.apache.org/jira/secure/attachment/12848538/pass_fetch.png!I am attaching screen shot, CSV and log with it.
was:
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.
> 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 :*
> !
https://issues.apache.org/jira/secure/attachment/12848539/complex_data_type.png!> While when we use query *select id from ct10;*, its working fine.
> !
https://issues.apache.org/jira/secure/attachment/12848538/pass_fetch.png!> I am attaching screen shot, CSV and log with it.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
Locked
