You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Anurag Srivastava (JIRA)" <ji...@apache.org> on 2017/01/20 13:23:26 UTC
[jira] [Created] (CARBONDATA-672) Complex data type is not working
while fetching it from Database
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)