Details
-
Type:
Bug
-
Status: Resolved
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.0.0, 1.1.0, 1.2.0
-
Fix Version/s: None
-
Component/s: export, vendors/postgres
-
Labels:None
Description
Exporting a boolean column in PostgreSQL (only tried direct mode so far) just results in a single char 't' or 'f'. Importing this into Hive seems to result only in NULL values. I'm not exactly sure but Hive seems to expect the Thrift representation of a Boolean which would probably be different from 't'/'f' so this won't work. If this is true it unfortunately means that we either have to change every output row or teach Hive to CAST (I've seen that somewhere in the Hive documentation but I'm not sure how it works yet) those values properly.
I've only mentioned PostgreSQL but this problem might exist for other databases too? I will try to test this more next week.