[HIVE-19960] Add Column Mapping to JsonSerDe

• Type: New Feature
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 3.0.0, 4.0.0
• Component/s: Serializers/Deserializers
• Assignee: Unassigned
• Reporter: David Mollitor
• Created: 21/Jun/18 13:30
• Updated: 21/Jun/18 13:31

Description

Enhance the JSON SerDe to accept a SerDe property that allows for arbitrary mapping of JSON parameter names to column names. This would be very similar to Hive HBase integration.

{"fname":"John","lname":"Doe"}

CREATE TABLE (
first_name string,
last_name string,
...
WITH SERDEPROPERTIES (
"json.columns.mapping" = "fname:first_name,lname:last_name"
);

Issue Links

• is depended upon by: HIVE-18785 Make JSON SerDe First-Class SerDe