[HIVE-9864] Create UDF jsonpath which support full JsonPath syntax

• Type: Improvement
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Component/s: UDF
• Assignee: Alexander Pivovarov
• Reporter: Alexander Pivovarov
• Created: 05/Mar/15 00:31
• Updated: 23/Mar/15 10:46

Description

Existing udf get_json_object supports limited JsonPath syntax.
It would be nice if we have full JsonPath syntax support.

We can use Jayway JsonPath 2.0.0 to query json (Apache License, Version 2.0)
Reasons:
1. existing get_json_object syntax is limited in comparison to Jayway JsonPath

2. get_json_object uses lots of custom java code which can be replaced with simple JsonPath API calls, e.g.

Object result = JsonPath.parse(json).read(path)

I think we should not change existing get_json_object udf and better to create new one because Jayway JsonPath works slightly different in some situations.

Issue Links

• relates to: HIVE-10055 Upgrade Jackson version to the latest stable version
• links to: https://github.com/jayway/JsonPath
• links to: https://reviews.apache.org/r/32387/