[
https://issues.apache.org/jira/browse/HIVE-9864?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14375464#comment-14375464
]
Alexander Pivovarov commented on HIVE-9864:
-------------------------------------------
JsonPath supports several Json Parsers including Jackson.
But hive has dependency to old Jackson version 1.9.2 (org.codehause.jackson)
JsonPath requires com.fasterxml.jackson version (since version 2.0)
This is why I'm going to use json-smart 2.1.1 parser
https://github.com/netplex/json-smart-v2
We can switch JsonPath to Jackson parser after we upgrade to the newer Jackson
version
> Create UDF jsonpath which support full JsonPath syntax
> ------------------------------------------------------
>
> Key: HIVE-9864
> URL: https://issues.apache.org/jira/browse/HIVE-9864
> Project: Hive
> Issue Type: Improvement
> Components: UDF
> Reporter: Alexander Pivovarov
> Assignee: Alexander Pivovarov
>
> 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.
> {code}
> Object result = JsonPath.parse(json).read(path)
> {code}
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
