[jira] [Closed] (CARBONDATA-959) Unable to query carbon table with complex data type on hive

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Closed] (CARBONDATA-959) Unable to query carbon table with complex data type on hive

Akash R Nilugal (Jira)

     [ https://issues.apache.org/jira/browse/CARBONDATA-959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

anubhav tarar closed CARBONDATA-959.
------------------------------------
    Resolution: Fixed

> 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.4.14#64029)