You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "anubhav tarar (JIRA)" <ji...@apache.org> on 2017/04/20 06:08:04 UTC
[jira] [Created] (CARBONDATA-959) Unable to query carbon table with
complex data type on hive
anubhav tarar created CARBONDATA-959:
----------------------------------------
Summary: Unable to query carbon table with complex data type on hive
Key: CARBONDATA-959
URL: https://issues.apache.org/jira/browse/CARBONDATA-959
Project: CarbonData
Issue Type: Bug
Components: hive-integration
Affects Versions: 1.0.0-incubating
Environment: hive1.2.1,spark 2.1
Reporter: anubhav tarar
Assignee: anubhav tarar
Priority: Minor
Attachments: newdata.csv
started the spark shell
created carbon table with complex type
carbon.sql("create table complextypes(id string,MAC array<string>) stored by 'carbondata' ")
carbon.sql("""LOAD DATA INPATH 'hdfs://localhost:54310/newdata.csv' into table complextypes""")
start hive shell
create table complex(id string,mac array<string>);
OK
alter table complextype set FILEFORMAT
> INPUTFORMAT "org.apache.carbondata.hive.MapredCarbonInputFormat"
> OUTPUTFORMAT "org.apache.carbondata.hive.MapredCarbonOutputFormat"
> SERDE "org.apache.carbondata.hive.CarbonHiveSerDe";
alter table complex set LOCATION 'hdfs://localhost:54310/opt/carbonStore/default/complextypes' ;
query the data
hive> select * from complex;
OK
Failed with exception java.io.IOException:java.lang.NullPointerException
Time taken: 2.05 seconds
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)