[
https://issues.jboss.org/browse/TEIID-2159?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2159:
---------------------------------------
If this needs to be validating then we'll add a json type (which is quite a bit of
work) and a JsonParse functions makes sense. Otherwise clob/blob will work and JsonParse
isn't necessary.
I would expect the JsonForrest/JsonObject functionality to be merged. That is JsonObject
should take a name and derived columns to produce an object result.
JsonArray replaces XMLConcat. Also JsonAgg could be JsonArrayAgg or just always produce an
array result.
Provide language objects to produce a JSON document
---------------------------------------------------
Key: TEIID-2159
URL:
https://issues.jboss.org/browse/TEIID-2159
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Reporter: Ramesh Reddy
Assignee: Steven Hawkins
SQLXML is standard that lets users define XML constructs to define a XML documents using
SQL. However there is such standard exists for producing the JSON based documents.
It would be nice if Teiid provides such SQL language extensions produce and deal with
JSON documents. The constructs equivalent from SQLXML are
JsonParse
JsonObject
JsonArray
JsonForrest
JsonAgg
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see:
http://www.atlassian.com/software/jira