[JBoss JIRA] (TEIID-5481) Evaluate JSONPATH as expression language for Json payload to table
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5481?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5481:
---------------------------------------
Beyond this for full processing, we'd need something like:
jsoncast - which could take a json and cast to one of the known types (string, boolean, decimal, or an array of those)
jsontable - which could iterate on a context item and extract columns based upon paths.
> 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)
5 years, 4 months
[JBoss JIRA] (TEIID-5746) Add support for a multi-row array table
by Steven Hawkins (Jira)
Steven Hawkins created TEIID-5746:
-------------------------------------
Summary: Add support for a multi-row array table
Key: TEIID-5746
URL: https://issues.jboss.org/browse/TEIID-5746
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 12.3
When arraytable was added, we had only limited support for 1 dimensional arrays. It should support both a single row and a multi-row (multi-dimensional) case.
The proposal is for the syntax:
arraytable([row|rows] ...)
if it is not specified or row, it is a single row result. If rows, then it will expect a multi-dimensional array and produce 1 row per element in the outer array.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 4 months
[JBoss JIRA] (TEIID-5481) Evaluate JSONPATH as expression language for Json payload to table
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5481?page=com.atlassian.jira.plugin... ]
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)
5 years, 4 months
[JBoss JIRA] (TEIID-5481) Evaluate JSONPATH as expression language for Json payload to table
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5481?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5481:
---------------------------------------
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)
5 years, 4 months
[JBoss JIRA] (TEIID-5738) Upgrade to WildFly 16
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5738?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5738:
---------------------------------------
I've updated to 17.0.0.Alpha1. Took a pass at making the wild parent wildfly-parent, rather than jboss-parent as there are less versions to manage - but we pick up a lot more of their plugins such that it's simpler to stick with jboss-parent.
Before this is resolved I'll see if there are doc and config updates to remove deprecation warnings. I'm specifically thinking of security stuff that should be moved to elyctron.
> Upgrade to WildFly 16
> ---------------------
>
> Key: TEIID-5738
> URL: https://issues.jboss.org/browse/TEIID-5738
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Shwetha vr
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 12.3
>
>
> Upgrade to the latest WildFly for the next Teiid minor release.
> Note that it has not been tested if Teiid 12.2 is compatible with WildFly 16, so that could be an initial workaround. See the forum https://developer.jboss.org/thread/280075 for a discussion of managing the overlay separately from WildFly.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 4 months
[JBoss JIRA] (TEIIDSB-93) Fix the travis build
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-93?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIIDSB-93:
---------------------------------------
I'll also update the travis settings for access to the maven snapshot repo. It will push new snapshots on all master commits.
> Fix the travis build
> --------------------
>
> Key: TEIIDSB-93
> URL: https://issues.jboss.org/browse/TEIIDSB-93
> Project: Teiid Spring Boot
> Issue Type: Quality Risk
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
>
> It is unclear why the travis builds are not completing testing with a variety of travis changes (repeating steps, separating build from test, etc.) did not improve the situation. It appears to just hang on dependency downloading for no discernible reason.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 4 months
[JBoss JIRA] (TEIIDSB-96) Strange pg errors
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-96?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIIDSB-96.
-----------------------------------
Resolution: Done
This was missed from TEIIDSB-90. The pg metadata needs enabled for either secure or non-secure.
> Strange pg errors
> -----------------
>
> Key: TEIIDSB-96
> URL: https://issues.jboss.org/browse/TEIIDSB-96
> Project: Teiid Spring Boot
> Issue Type: Bug
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 1.1.0
>
>
> Running an openshift example locally, connecting via pg and running TestODBCSocketTransport produces an expected set of errors. Doing the same thing against the same build running in minishift produces a host of strange errors where it appears that the pg metadata is not resolvable.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 4 months
[JBoss JIRA] (TEIIDSB-96) Strange pg errors
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-96?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIIDSB-96:
---------------------------------------
An example:
{code}
org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'pg_catalog.getOid(SYS.Columns.TableUID)' is an unknown form. Check that the function name and number of arguments is correct.
at org.teiid.query.resolver.util.ResolverVisitor.resolveFunction(ResolverVisitor.java:774) ~[teiid-engine-12.2.0.jar!/:12.2.0]
at org.teiid.query.resolver.util.ResolverVisitor.visit(ResolverVisitor.java:392) ~[teiid-engine-12.2.0.jar!/:12.2.0]
at org.teiid.query.sql.symbol.Function.acceptVisitor(Function.java:169) ~[teiid-engine-12.2.0.jar!/:12.2.0]
at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:50) ~[teiid-engine-12.2.0.jar!/:12.2.0]
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:57) ~[teiid-engine-12.2.0.jar!/:12.2.0]
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.postVisitVisitor(SimpleQueryResolver.java:229) ~[teiid-engine-12.2.0.jar!/:12.2.0]
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:194) ~[teiid-engine-12.2.0.jar!/:12.2.0]
at org.teiid.query.sql.symbol.Function.acceptVisitor(Function.java:169) ~[teiid-engine-12.2.0.jar!/:12.2.0]
{code}
> Strange pg errors
> -----------------
>
> Key: TEIIDSB-96
> URL: https://issues.jboss.org/browse/TEIIDSB-96
> Project: Teiid Spring Boot
> Issue Type: Bug
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 1.1.0
>
>
> Running an openshift example locally, connecting via pg and running TestODBCSocketTransport produces an expected set of errors. Doing the same thing against the same build running in minishift produces a host of strange errors where it appears that the pg metadata is not resolvable.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 4 months