[PIG-4561] DBStorage unable to work with PostgreSQL

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 0.13.0, 0.14.0
• Component/s: piggybank
• Flags: Important
• Assignee: Unassigned
• Reporter: Neeleshkumar Mannur
• Created: 19/May/15 12:45
• Updated: 19/May/15 12:45

Description

Pig assumes bytearray as the default data type. When using the DBStorage class with MySQL with no data type specified, it works correctly for UTF8 strings. We pass encoding parameters in the connection string to DBStorage. So, DBStorage honours those parameters and values are stored correctly into the tables.

When using DBStorage with PostgreSQL, the same scenario stores UTF8 data in octal format in the tables. Hindi characters or rather all UTF8 characters are stored as "\347......." Also, none of the PostgreSQL connection parameters are honoured.