[JBoss JIRA] (TEIID-3616) HBase translator - NPE if date value is 'null'
by Juraj Duráni (JIRA)
[ https://issues.jboss.org/browse/TEIID-3616?page=com.atlassian.jira.plugin... ]
Juraj Duráni commented on TEIID-3616:
-------------------------------------
There is also one issue with teiid's insert statement. It translates it as UPSERT which is an "alias" for both insert and update. Does teiid distinguish between those statements?
> HBase translator - NPE if date value is 'null'
> ----------------------------------------------
>
> Key: TEIID-3616
> URL: https://issues.jboss.org/browse/TEIID-3616
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: Hbase: 1.1.1
> Phoenix: 4.5.0-HBase-1.1
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Attachments: log
>
>
> If the source table in HBase contains a 'NULL' date value, Teiid throws an NPE. I did not encounter any NPE using org.apache.phoenix.jdbc.PhoenixDriver [1]. Other data types seem to be OK too.
> I have tried integer, char, varchar, float, double, tinyint, smallint, bigint, decimal, varbinary, boolean, time, date, timestamp.
> [1]
> Connection con = new org.apache.phoenix.jdbc.PhoenixDriver().connect("jdbc:phoenix:localhost", new Properties())
> ResultSet rs = con.createStatement().executeQuery("select datevalue from smalla");
> while(rs.next()){
> System.out.println(rs.getDate(1));
> }
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 7 months
[JBoss JIRA] (TEIID-3616) HBase translator - NPE if date value is 'null'
by Juraj Duráni (JIRA)
[ https://issues.jboss.org/browse/TEIID-3616?page=com.atlassian.jira.plugin... ]
Juraj Duráni updated TEIID-3616:
--------------------------------
Attachment: log
Server.log
> HBase translator - NPE if date value is 'null'
> ----------------------------------------------
>
> Key: TEIID-3616
> URL: https://issues.jboss.org/browse/TEIID-3616
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: Hbase: 1.1.1
> Phoenix: 4.5.0-HBase-1.1
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Attachments: log
>
>
> If the source table in HBase contains a 'NULL' date value, Teiid throws an NPE. I did not encounter any NPE using org.apache.phoenix.jdbc.PhoenixDriver [1]. Other data types seem to be OK too.
> I have tried integer, char, varchar, float, double, tinyint, smallint, bigint, decimal, varbinary, boolean, time, date, timestamp.
> [1]
> Connection con = new org.apache.phoenix.jdbc.PhoenixDriver().connect("jdbc:phoenix:localhost", new Properties())
> ResultSet rs = con.createStatement().executeQuery("select datevalue from smalla");
> while(rs.next()){
> System.out.println(rs.getDate(1));
> }
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 7 months
[JBoss JIRA] (TEIID-3617) I want limit each user connections
by Xian Liu (JIRA)
Xian Liu created TEIID-3617:
-------------------------------
Summary: I want limit each user connections
Key: TEIID-3617
URL: https://issues.jboss.org/browse/TEIID-3617
Project: Teiid
Issue Type: Feature Request
Reporter: Xian Liu
Assignee: Steven Hawkins
we deploy teiid for users to get data, but some users will create many connections to teiid and they are not necessary, I need to find a good way to limit each user account can only get like 50 connections or so
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 7 months
[JBoss JIRA] (TEIID-3616) HBase translator - NPE if date value is 'null'
by Juraj Duráni (JIRA)
Juraj Duráni created TEIID-3616:
-----------------------------------
Summary: HBase translator - NPE if date value is 'null'
Key: TEIID-3616
URL: https://issues.jboss.org/browse/TEIID-3616
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7.1.6_2
Environment: Hbase: 1.1.1
Phoenix: 4.5.0-HBase-1.1
Reporter: Juraj Duráni
Assignee: Steven Hawkins
If the source table in HBase contains a 'NULL' date value, Teiid throws an NPE. I did not encounter any NPE using org.apache.phoenix.jdbc.PhoenixDriver [1]. Other data types seem to be OK too.
I have tried integer, char, varchar, float, double, tinyint, smallint, bigint, decimal, varbinary, boolean, time, date, timestamp.
[1]
Connection con = new org.apache.phoenix.jdbc.PhoenixDriver().connect("jdbc:phoenix:localhost", new Properties())
ResultSet rs = con.createStatement().executeQuery("select datevalue from smalla");
while(rs.next()){
System.out.println(rs.getDate(1));
}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 7 months
[JBoss JIRA] (TEIID-3568) Order By and Limit are not getting pushed to the database, when Union and join are used together.
by Guru Prasad (JIRA)
[ https://issues.jboss.org/browse/TEIID-3568?page=com.atlassian.jira.plugin... ]
Guru Prasad commented on TEIID-3568:
------------------------------------
Ordered limit is not being pushed if the query has union along with join.
Find the plan for the below query, where we are sorting and applying limit after the DB call. Can even that be pushed to the db as in the case when there is only union all.
*Query union along with join*
select u.e1, u.e2 from (
select pm1.g1.e1, pm1.g1.e2 from pm1.g1
union all
select pm3.g1.e1, pm3.g1.e2 from pm3.g1 )as u
left outer join
pm2.g1 on u.e1 = pm2.g1.e1
order by u.e1 limit 3
*Plan:*
ProjectNode(0) output=[u.e1, u.e2] [u.e1, u.e2]
LimitNode(1) output=[u.e1, u.e2] limit 3
SortNode(2) output=[u.e1, u.e2] [SORT] [u.e1]
JoinNode(3) [ENHANCED SORT JOIN RAN AS SORT MERGE (SORT/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[u.e1=pm2.g1.e1] output=[u.e1, u.e2]
LimitNode(4) output=[u.e1, u.e2] limit 3
SortNode(5) output=[u.e1, u.e2] [SORT] [u.e1]
UnionAllNode(6) output=[u.e1, u.e2]
ProjectNode(7) output=[pm1.g1.e1, convert(pm1.g1.e2, object) AS e2] [pm1.g1.e1, convert(pm1.g1.e2, object) AS e2]
AccessNode(8) output=[pm1.g1.e1, pm1.g1.e2] SELECT pm1.g1.e1, pm1.g1.e2 FROM pm1.g1
ProjectNode(9) output=[pm3.g1.e1, convert(pm3.g1.e2, object) AS e2] [pm3.g1.e1, convert(pm3.g1.e2, object) AS e2]
AccessNode(10) output=[pm3.g1.e1, pm3.g1.e2] SELECT pm3.g1.e1, pm3.g1.e2 FROM pm3.g1
AccessNode(11) output=[pm2.g1.e1] SELECT pm2.g1.e1 FROM pm2.g1 ORDER BY pm2.g1.e1
*Query with only union all, without join*
select u.e1, u.e2 from (
select pm1.g1.e1, pm1.g1.e2 from pm1.g1
union all
select pm3.g1.e1, pm3.g1.e2 from pm3.g1 )as u
order by u.e1 limit 3
*Plan* :
LimitNode(0) output=[pm1.g1.e1, convert(pm1.g1.e2, object) AS e2] limit 3
SortNode(1) output=[pm1.g1.e1, convert(pm1.g1.e2, object) AS e2] [SORT] [pm1.g1.e1]
UnionAllNode(2) output=[pm1.g1.e1, convert(pm1.g1.e2, object) AS e2]
ProjectNode(3) output=[pm1.g1.e1, convert(pm1.g1.e2, object) AS e2] [pm1.g1.e1, convert(pm1.g1.e2, object) AS e2]
AccessNode(4) output=[pm1.g1.e1, pm1.g1.e2] SELECT pm1.g1.e1, pm1.g1.e2 FROM pm1.g1 ORDER BY pm1.g1.e1 LIMIT 3
ProjectNode(5) output=[pm3.g1.e1, convert(pm3.g1.e2, object) AS e2] [pm3.g1.e1, convert(pm3.g1.e2, object) AS e2]
AccessNode(6) output=[pm3.g1.e1, pm3.g1.e2] SELECT pm3.g1.e1, pm3.g1.e2 FROM pm3.g1 ORDER BY pm3.g1.e1 LIMIT 3
> Order By and Limit are not getting pushed to the database, when Union and join are used together.
> --------------------------------------------------------------------------------------------------
>
> Key: TEIID-3568
> URL: https://issues.jboss.org/browse/TEIID-3568
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Affects Versions: 8.1
> Reporter: Guru Prasad
> Assignee: Steven Hawkins
> Fix For: 8.12
>
> Attachments: ShowPlan.txt
>
>
> Order By and Limit are not getting pushed to the database, when Union and join are used together.
> In this scenario there if the underlying table has millions of records the query never returns with data.
> *Query 1*: Using only Join without union, this works fine.
> SELECT u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode FROM (
> select evttypecode, evtsysid, evtutctod, evtsystod, evtcatcode from XYZ.Tab1
> ) as u
> LEFT OUTER JOIN XYZ.CATEGORY AS ct ON u.evtcatcode = ct.evtcatcode
> WHERE (u.EVTUTCTOD >= {ts'2015-06-03 19:20:00.8'}) AND (u.EVTUTCTOD <= {ts'2015-06-03 19:20:01.0'}) ORDER BY u.evtsysid LIMIT 8
> PROCESSOR PLAN:
> AccessNode(0) output=[evttypecode AS evttypecode, evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod, evtcatcode AS evtcatcode]
> SELECT g_0.EVTTYPECODE AS c_0, g_0.EVTSYSID AS c_1, g_0.EVTUTCTOD AS c_2, g_0.EVTSYSTOD AS c_3, g_0.EVTCATCODE AS c_4 FROM ABC.Tab1 AS g_0 LEFT OUTER JOIN ABC.CATEGORY AS g_1 ON g_0.EVTCATCODE = g_1.EVTCATCODE WHERE (g_0.EVTUTCTOD >= {ts'2015-06-03 19:20:00.8'}) AND (g_0.EVTUTCTOD <= {ts'2015-06-03 19:20:01.0'}) ORDER BY c_1 LIMIT 8
> *Query 2*: Using only Union without any join, this also works fine.
> SELECT u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode FROM (
> select evttypecode, evtsysid, evtutctod, evtsystod, evtcatcode from XYZ.Tab1
> UNION ALL
> select evttypecode, evtsysid, evtutctod, evtsystod, evtcatcode from XYZ.Tab2
> ) as u
> WHERE (u.EVTUTCTOD >= {ts'2015-06-03 19:20:00.8'}) AND (u.EVTUTCTOD <= {ts'2015-06-03 19:20:01.0'}) ORDER BY u.evtsysid LIMIT 8
> PROCESSOR PLAN:
> AccessNode(0) output=[evttypecode AS evttypecode, evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod, evtcatcode AS evtcatcode]
> SELECT g_1.EVTTYPECODE AS c_0, g_1.EVTSYSID AS c_1, g_1.EVTUTCTOD AS c_2, g_1.EVTSYSTOD AS c_3, g_1.EVTCATCODE AS c_4 FROM ABC.Tab1 AS g_1 WHERE (g_1.EVTUTCTOD >= {ts'2015-06-03 19:20:00.8'}) AND (g_1.EVTUTCTOD <= {ts'2015-06-03 19:20:01.0'}) UNION ALL
> SELECT g_0.EVTTYPECODE AS c_0, g_0.EVTSYSID AS c_1, g_0.EVTUTCTOD AS c_2, g_0.EVTSYSTOD AS c_3, g_0.EVTCATCODE AS c_4 FROM ABC.Tab2 AS g_0 WHERE (g_0.EVTUTCTOD >= {ts'2015-06-03 19:20:00.8'}) AND (g_0.EVTUTCTOD <= {ts'2015-06-03 19:20:01.0'}) ORDER BY c_1 LIMIT 8
> *Query 3*: Using both Union and join, this does not push down the order by and limit.
> SELECT u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode FROM (
> select evttypecode, evtsysid, evtutctod, evtsystod, evtcatcode from XYZ.Tab1
> UNION ALL
> select evttypecode, evtsysid, evtutctod, evtsystod, evtcatcode from XYZ.Tab2
> ) as u
> LEFT OUTER JOIN XYZ.EVTTYPE AS tp ON tp.evttypecode = u.evttypecode
> LEFT OUTER JOIN XYZ.CATEGORY AS ct ON u.evtcatcode = ct.evtcatcode
> WHERE (u.EVTUTCTOD >= {ts'2015-06-03 19:20:00.8'}) AND (u.EVTUTCTOD <= {ts'2015-06-03 19:20:01.0'}) ORDER BY u.evtsysid LIMIT 8
> PROCESSOR PLAN:
> ProjectNode(0) output=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode] [u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode]
> LimitNode(1) output=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode] limit 8
> SortNode(2) output=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode] [SORT] [u.evtsysid]
> JoinNode(3) [MERGE JOIN (SORT/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[u.evtcatcode=evtcatcode] output=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode]
> JoinNode(4) [MERGE JOIN (SORT/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[u.evttypecode=evttypecode] output=[u.evtcatcode, u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod]
> AccessNode(5) output=[u.evttypecode, u.evtcatcode, u.evtsysid, u.evtutctod, u.evtsystod]
> SELECT g_1.EVTTYPECODE AS c_0, g_1.EVTCATCODE AS c_1, g_1.EVTSYSID AS c_2, g_1.EVTUTCTOD AS c_3, g_1.EVTSYSTOD AS c_4 FROM ABC.Tab1 AS g_1 WHERE (g_1.EVTUTCTOD >= {ts'2015-06-03 19:20:00.8'}) AND (g_1.EVTUTCTOD <= {ts'2015-06-03 19:20:01.0'})
> UNION ALL SELECT g_0.EVTTYPECODE AS c_0, g_0.EVTCATCODE AS c_1, g_0.EVTSYSID AS c_2, g_0.EVTUTCTOD AS c_3, g_0.EVTSYSTOD AS c_4 FROM ABC.Tab2 AS g_0 WHERE (g_0.EVTUTCTOD >= {ts'2015-06-03 19:20:00.8'}) AND (g_0.EVTUTCTOD <= {ts'2015-06-03 19:20:01.0'})
> AccessNode(6) output=[evttypecode] SELECT g_0.EVTTYPECODE AS c_0 FROM ABC.EVTTYPE AS g_0 ORDER BY c_0
> AccessNode(7) output=[evtcatcode] SELECT g_0.EVTCATCODE AS c_0 FROM ABC.CATEGORY AS g_0 ORDER BY c_0
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 7 months
[JBoss JIRA] (TEIID-3615) Add a api-docs page with Swagger-UI in REST Service Through VDB
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3615?page=com.atlassian.jira.plugin... ]
Kylin Soong updated TEIID-3615:
-------------------------------
Description:
With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model:
* foo
* getAllStocks
* getAllStockById
* getAllStockBySymbol
Correspondingly, there are 4 api:
* http://localhost:8080/portfoliorest_1/rest/foo
* http://localhost:8080/portfoliorest_1/rest/getAllStocks
* http://localhost:8080/portfoliorest_1/rest/getAllStockById/{id}
* http://localhost:8080/portfoliorest_1/rest/getAllStockBySymbol/{symbol}
With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example.
[1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB
[2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn...
[3] http://petstore.swagger.io/
was:
With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model:
* foo
* getAllStocks
* getAllStockById
* getAllStockBySymbol
Correspondingly, there are 4 api:
* /portfoliorest_1/rest/foo
* /portfoliorest_1/rest/getAllStocks
* /portfoliorest_1/rest/getAllStockById/{id}
* /portfoliorest_1/rest/getAllStockBySymbol/{symbol}
With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example.
[1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB
[2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn...
[3] http://petstore.swagger.io/
> Add a api-docs page with Swagger-UI in REST Service Through VDB
> ---------------------------------------------------------------
>
> Key: TEIID-3615
> URL: https://issues.jboss.org/browse/TEIID-3615
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.12
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 9.0
>
>
> With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model:
> * foo
> * getAllStocks
> * getAllStockById
> * getAllStockBySymbol
> Correspondingly, there are 4 api:
> * http://localhost:8080/portfoliorest_1/rest/foo
> * http://localhost:8080/portfoliorest_1/rest/getAllStocks
> * http://localhost:8080/portfoliorest_1/rest/getAllStockById/{id}
> * http://localhost:8080/portfoliorest_1/rest/getAllStockBySymbol/{symbol}
> With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example.
> [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB
> [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn...
> [3] http://petstore.swagger.io/
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 7 months
[JBoss JIRA] (TEIID-3615) Add a api-docs page with Swagger-UI in REST Service Through VDB
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3615?page=com.atlassian.jira.plugin... ]
Kylin Soong updated TEIID-3615:
-------------------------------
Description:
With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model:
* foo
* getAllStocks
* getAllStockById
* getAllStockBySymbol
Correspondingly, there are 4 api:
* /portfoliorest_1/rest/foo
* /portfoliorest_1/rest/getAllStocks
* /portfoliorest_1/rest/getAllStockById/{id}
* /portfoliorest_1/rest/getAllStockBySymbol/{symbol}
With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example.
[1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB
[2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn...
[3] http://petstore.swagger.io/
was:
With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model:
* foo
* getAllStocks
* getAllStockById
* getAllStockBySymbol
Correspondingly, there are 4 api:
* /portfoliorest_1/rest/foo/{id}
* /portfoliorest_1/rest/getAllStocks
* /portfoliorest_1/rest/getAllStockById/{id}
* /portfoliorest_1/rest/getAllStockBySymbol/{symbol}
With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example.
[1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB
[2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn...
[3] http://petstore.swagger.io/
> Add a api-docs page with Swagger-UI in REST Service Through VDB
> ---------------------------------------------------------------
>
> Key: TEIID-3615
> URL: https://issues.jboss.org/browse/TEIID-3615
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.12
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 9.0
>
>
> With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model:
> * foo
> * getAllStocks
> * getAllStockById
> * getAllStockBySymbol
> Correspondingly, there are 4 api:
> * /portfoliorest_1/rest/foo
> * /portfoliorest_1/rest/getAllStocks
> * /portfoliorest_1/rest/getAllStockById/{id}
> * /portfoliorest_1/rest/getAllStockBySymbol/{symbol}
> With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example.
> [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB
> [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn...
> [3] http://petstore.swagger.io/
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 7 months
[JBoss JIRA] (TEIID-3615) Add a api-docs page with Swagger-UI in REST Service Through VDB
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3615?page=com.atlassian.jira.plugin... ]
Kylin Soong updated TEIID-3615:
-------------------------------
Description:
With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model:
* foo
* getAllStocks
* getAllStockById
* getAllStockBySymbol
Correspondingly, there are 4 api:
* /portfoliorest_1/rest/foo/{id}
* /portfoliorest_1/rest/getAllStocks
* /portfoliorest_1/rest/getAllStockById/{id}
* /portfoliorest_1/rest/getAllStockBySymbol/{symbol}
With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example.
[1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB
[2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn...
[3] http://petstore.swagger.io/
was:
With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model:
* foo
* getAllStocks
* getAllStockById
* getAllStockBySymbol
Correspondingly, there are 4 api:
* /portfoliorest_1/rest/foo
* /portfoliorest_1/rest/getAllStocks
* /portfoliorest_1/rest/getAllStockById/{id}
* /portfoliorest_1/rest/getAllStockBySymbol/{symbol}
With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example.
[1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB
[2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn...
[3] http://petstore.swagger.io/
> Add a api-docs page with Swagger-UI in REST Service Through VDB
> ---------------------------------------------------------------
>
> Key: TEIID-3615
> URL: https://issues.jboss.org/browse/TEIID-3615
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.12
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 9.0
>
>
> With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model:
> * foo
> * getAllStocks
> * getAllStockById
> * getAllStockBySymbol
> Correspondingly, there are 4 api:
> * /portfoliorest_1/rest/foo/{id}
> * /portfoliorest_1/rest/getAllStocks
> * /portfoliorest_1/rest/getAllStockById/{id}
> * /portfoliorest_1/rest/getAllStockBySymbol/{symbol}
> With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example.
> [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB
> [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn...
> [3] http://petstore.swagger.io/
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 7 months