[teiid-issues] [JBoss JIRA] (TEIID-5481) Evaluate JSONPATH as expression language for Json payload to table
Steven Hawkins (Jira)
issues at jboss.org
Wed May 22 08:25:00 EDT 2019
[ https://issues.jboss.org/browse/TEIID-5481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13737250#comment-13737250 ]
Steven Hawkins edited comment on TEIID-5481 at 5/22/19 8:24 AM:
----------------------------------------------------------------
There will be two functions:
jsonquery(json|clob, jsonPath [, null_for_missing]) returns json - roughly the same functionality as xmlquery.
jsonpathvalue(json|clob, jsonPath [, null_for_missing]) returns string - roughly the same functionality as xpathvalue (returns a string value of a single item)
Neither quite match the semantics of the pg logic, but will be familiar to those who know jsonpath. The jayway implementation uses 0-based indexing - which does not seem to be consistent across implementations.
was (Author: shawkins):
There will be two functions:
jsonquery(json, jsonPath) returns json - roughly the same functionality as xmlquery.
jsonpathvalue(json, jsonPath) returns string - roughly the same functionality as xpathvalue (returns a string value of a single item)
Neither quite match the semantics of the pg logic, but will be familiar to those who know jsonpath. The jayway implementation uses 0-based indexing - which does not seem to be consistent across implementations.
> Evaluate JSONPATH as expression language for Json payload to table
> ------------------------------------------------------------------
>
> Key: TEIID-5481
> URL: https://issues.jboss.org/browse/TEIID-5481
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 12.3
>
>
> Currently in Teiid in order to turn a JSON document to a relational structure, JSONTOXML function is used then XPATH used on it to retrieve data using XMLTABLE.
> Investigate the feasibility of using JSONPATH [1] directly on JSON document to build a JSONTABLE construct.
> [1] https://code.google.com/archive/p/json-path/
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
More information about the teiid-issues
mailing list