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)