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

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.0.0-incubating
• Component/s: hive-integration
• Environment: hive1.2.1,spark 2.1
• Assignee: anubhav tarar
• Reporter: anubhav tarar
• Created: 20/Apr/17 06:07
• Updated: 12/Oct/17 11:20
• Resolved: 12/Oct/17 11:20

Description

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