carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anurag Srivastava (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CARBONDATA-672) Complex data type is not working while fetching it from Database
Date Fri, 20 Jan 2017 13:24:26 GMT

     [ 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)

Mime
View raw message