May 2019 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIIDSB-97) Add profile to build and package bits

by Van Halbert (Jira)

Van Halbert created TEIIDSB-97: ---------------------------------- Summary: Add profile to build and package bits Key: TEIIDSB-97 URL: https://issues.jboss.org/browse/TEIIDSB-97 Project: Teiid Spring Boot Issue Type: Enhancement Components: core Reporter: Van Halbert Assignee: Van Halbert Fix For: 1.1.0 For productization, a profile will be created that will trigger the server build and package for distribution, to be used for image creation. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 5 months

1
0
0 / 0

[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)

6 years, 5 months

1
0
0 / 0

[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)

6 years, 5 months

1
0
0 / 0

[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)

6 years, 5 months

1
0
0 / 0

[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)

6 years, 5 months

1
0
0 / 0

[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 updated TEIID-5481: ---------------------------------- Fix Version/s: 12.3 (was: 12.x) > 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)

6 years, 5 months

1
0
0 / 0

[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... ] Work on TEIID-5481 started by Steven Hawkins. --------------------------------------------- > 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.x > > > 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)

6 years, 5 months

1
0
0 / 0

[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)

6 years, 5 months

1
0
0 / 0

[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)

6 years, 5 months

1
0
0 / 0

[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)

6 years, 5 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2019