[HIVE-5104] HCatStorer fails to store boolean type

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.11.0
• Fix Version/s: 0.12.0
• Component/s: HCatalog
• Release Note: Saving records that contain Boolean type's is now supported via Pig's HCatStorer.
• Assignee: Karl D. Gierach
• Reporter: Ron Frohock
• Created: 15/Aug/13 22:45
• Updated: 15/Oct/13 23:28
• Resolved: 03/Sep/13 20:32

Description

Unable to store boolean values to HCat table

Assume in Hive you have two tables...
CREATE TABLE btest(test as boolean);
CREATE TABLE btest2(test as boolean);

Then in Pig
A = LOAD 'btest' USING org.apache.hcatalog.pig.HCatLoader();
STORE A INTO 'btest2' USING org.apache.hcatalog.pig.HCatStorer();

You will get an "ERROR 115: Unsupported type 5: in Pig's Schema"

Checking HCatBaseStorer.java, the case for data types doesn't check for booleans. Might have been overlooked in adding boolean to Pig in 0.10