[HIVE-4551] HCatLoader smallint/tinyint promotions to Int have issues with ORC integration

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.12.0
• Component/s: HCatalog
• Assignee: Sushanth Sowmyan
• Reporter: Sushanth Sowmyan
• Created: 13/May/13 21:09
• Updated: 24/Mar/14 20:40
• Resolved: 27/Jul/13 15:09

Description

This was initially reported from an e2e test run, with the following E2E test:

                {
                        'name' => 'Hadoop_ORC_Write',
                        'tests' => [
                                {
                                 'num' => 1
                                ,'hcat_prep'=>q\
drop table if exists hadoop_orc;
create table hadoop_orc (
            t tinyint,
            si smallint,
            i int,
            b bigint,
            f float,
            d double,
            s string)
        stored as orc;\
                                ,'hadoop' => q\
jar :FUNCPATH:/testudf.jar org.apache.hcatalog.utils.WriteText -libjars :HCAT_JAR: :THRIFTSERVER: all100k hadoop_orc\,
                                ,'result_table' => 'hadoop_orc'
                                ,'sql' => q\select * from all100k;\
                                ,'floatpostprocess' => 1
                                ,'delimiter' => '       '
                                },
                       ],
                },

This fails with the following error:

2013-04-26 00:26:07,437 WARN org.apache.hadoop.mapred.Child: Error running child
org.apache.pig.backend.executionengine.ExecException: ERROR 6018: Error converting read value to tuple
	at org.apache.hcatalog.pig.HCatBaseLoader.getNext(HCatBaseLoader.java:76)
	at org.apache.hcatalog.pig.HCatLoader.getNext(HCatLoader.java:53)
	at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.PigRecordReader.nextKeyValue(PigRecordReader.java:211)
	at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:532)
	at org.apache.hadoop.mapreduce.MapContext.nextKeyValue(MapContext.java:67)
	at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:143)
	at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:765)
	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:369)
	at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:396)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1195)
	at org.apache.hadoop.mapred.Child.main(Child.java:249)
Caused by: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.io.ByteWritable cannot be cast to org.apache.hadoop.io.IntWritable
	at org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableIntObjectInspector.getPrimitiveJavaObject(WritableIntObjectInspector.java:45)
	at org.apache.hcatalog.data.HCatRecordSerDe.serializePrimitiveField(HCatRecordSerDe.java:290)
	at org.apache.hcatalog.data.HCatRecordSerDe.serializeField(HCatRecordSerDe.java:192)
	at org.apache.hcatalog.data.LazyHCatRecord.get(LazyHCatRecord.java:53)
	at org.apache.hcatalog.data.LazyHCatRecord.get(LazyHCatRecord.java:97)
	at org.apache.hcatalog.mapreduce.HCatRecordReader.nextKeyValue(HCatRecordReader.java:203)
	at org.apache.hcatalog.pig.HCatBaseLoader.getNext(HCatBaseLoader.java:63)
	... 12 more
2013-04-26 00:26:07,440 INFO org.apache.hadoop.mapred.Task: Runnning cleanup for the task

Issue Links

• is related to: HCATALOG-425 Pig cannot read/write SMALLINT/TINYINT columns
• is related to: HIVE-4816 Followup from HIVE-4551 : Reworking HCat Record Transformation