May 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4187) Extend support for PI OLEDB Enterprise Queries in OSI PI Translator

by Al S (JIRA)

Al S created TEIID-4187: --------------------------- Summary: Extend support for PI OLEDB Enterprise Queries in OSI PI Translator Key: TEIID-4187 URL: https://issues.jboss.org/browse/TEIID-4187 Project: Teiid Issue Type: Enhancement Components: Misc. Connectors Affects Versions: 8.13.3 Reporter: Al S Assignee: Steven Hawkins Priority: Minor Attachments: PI-OLEDB-Enterprise-2012-User-Guide.pdf Background - PI OLEDB queries go against the PI Data Archive whereas PI OLEDB Enterprise go against PI AF, which is a metadata layer that sits atop the PI Data Archive. Both sets of queries are now accessible from the PI JDBC adapter. Please add the following enhancements to allow the OSI PI translator to work more effectively with OLEDB Enterprise queries. 1) Import table valued functions as Teiid procedures 2) Allow the pushdown of nested table joins 3) Update the PI translator to use the CROSS APPLY syntax. Please refer to the OLEDB Enterprise Guide for query syntax and rules for more detail. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4186) Prevent partial aggregate pushdown based upon type

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4186?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4186: ---------------------------------- > Prevent partial aggregate pushdown based upon type > -------------------------------------------------- > > Key: TEIID-4186 > URL: https://issues.jboss.org/browse/TEIID-4186 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5 > > > For limited value types, such as boolean or byte, there is little value in their use as grouping columns and should be avoided - even if distinct value counts are not available. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4186) Prevent partial aggregate pushdown based upon type

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4186: ------------------------------------- Summary: Prevent partial aggregate pushdown based upon type Key: TEIID-4186 URL: https://issues.jboss.org/browse/TEIID-4186 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.0, 8.12.5 For limited value types, such as boolean or byte, there is little value in their use as grouping columns and should be avoided - even if distinct value counts are not available. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4185) Add more documentation about Embedded

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4185?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-4185: ------------------------------------ > Where are we with TEIID-3825 - as moving forward we may want to promote swarm usage with embedded? Sure, swarm approach on a first final release(current in 1.0.0.CR1), we can base on that. > Add more documentation about Embedded > ------------------------------------- > > Key: TEIID-4185 > URL: https://issues.jboss.org/browse/TEIID-4185 > Project: Teiid > Issue Type: Task > Components: Documentation, Embedded > Affects Versions: 9.x > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 9.x > > > [1] is some document related with Teiid embedded, but we need more or enhance to make the Embedded production ready. > [1] https://teiid.gitbooks.io/documents/content/embedded/Embedded_Guide.html -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4185) Add more documentation about Embedded

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4185?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4185: --------------------------------------- Beyond the guide there are the javadocs and the quickstarts that are based on embedded. The javadocs and supplemental api documentation is lacking. Beyond that we need to think about api improvements - such as deprecating the direct usage of creating a Model object in favor of relying on deployment artifacts. Where are we with TEIID-3825 - as moving forward we may want to promote swarm usage with embedded? > Add more documentation about Embedded > ------------------------------------- > > Key: TEIID-4185 > URL: https://issues.jboss.org/browse/TEIID-4185 > Project: Teiid > Issue Type: Task > Components: Documentation, Embedded > Affects Versions: 9.x > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 9.x > > > [1] is some document related with Teiid embedded, but we need more or enhance to make the Embedded production ready. > [1] https://teiid.gitbooks.io/documents/content/embedded/Embedded_Guide.html -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4185) Add more documentation about Embedded

by Kylin Soong (JIRA)

Kylin Soong created TEIID-4185: ---------------------------------- Summary: Add more documentation about Embedded Key: TEIID-4185 URL: https://issues.jboss.org/browse/TEIID-4185 Project: Teiid Issue Type: Task Components: Documentation, Embedded Affects Versions: 9.x Reporter: Kylin Soong Assignee: Kylin Soong Fix For: 9.x [1] is some document related with Teiid embedded, but we need more or enhance to make the Embedded production ready. [1] https://teiid.gitbooks.io/documents/content/embedded/Embedded_Guide.html -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3644) Create a embedded example to show security authentication with picketlink

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3644?page=com.atlassian.jira.plugin... ] Kylin Soong closed TEIID-3644. ------------------------------ > Create a embedded example to show security authentication with picketlink > ------------------------------------------------------------------------- > > Key: TEIID-3644 > URL: https://issues.jboss.org/browse/TEIID-3644 > Project: Teiid > Issue Type: Task > Components: Embedded > Affects Versions: 8.12 > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 8.12 > > > Create a embedded example to show security authentication with picketlink -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3520) Add support for Swagger Translator

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3520?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3520: ------------------------------------- doc link https://teiid.gitbooks.io/documents/content/reference/Swagger_Translator.... > Add support for Swagger Translator > ---------------------------------- > > Key: TEIID-3520 > URL: https://issues.jboss.org/browse/TEIID-3520 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 9.0 > > > http://swagger.io is popular REST service description framework, it defines a specification http://swagger.io/specification/ for REST service definition. > Teiid WS translator should add the ability to read this file (like WSDL) and provide the REST methods as endpoints that can be consumed from Teiid. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4184) Timestamps need to be submitted without supporting {ts} for OSI PI translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4184?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4184. ----------------------------------- Fix Version/s: 9.0 Resolution: Done Changed the logic to use string literals instead. > Timestamps need to be submitted without supporting {ts} for OSI PI translator > ----------------------------------------------------------------------------- > > Key: TEIID-4184 > URL: https://issues.jboss.org/browse/TEIID-4184 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.13.3 > Reporter: Al S > Assignee: Steven Hawkins > Priority: Minor > Labels: osisoft-pi > Fix For: 9.0 > > > Queries with OSI PI translator insert a {ts} when passing timestamps but the PI SQL engine does not handle this well. > Example model query: > select "tag","time","value" from "schema-name"."picomp2" > Example query against Teiid schema: > select * from IceDataThree where tag='sinusoid' and timecol>'2016-01-01 00:00:00' > Translation: > SELECT TOP 1000 g_0."tag" AS c_0, g_0."time" AS c_1, g_0."value" AS c_2 FROM "piarchive"."picomp2" AS g_0 > 02.WHERE g_0."tag" = 'sinusoid' AND g_0."time" > {ts '2016-04-20 00:00:00.0'} > Error: > 20:02:57,250 WARN [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue21) sV28Up1 > 02.GiGOM Connector worker process failed for atomic-request=sV28Up1GiGOM.2.0.3: org > 03..teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error exe > 04.cuting statement(s): [SQL: SELECT TOP 1000 g_0."tag" AS c_0, g_0."time" AS c_1, > 05.g_0."value" AS c_2 FROM "piarchive"."picomp2" AS g_0 WHERE g_0."tag" = 'sinusoid > 06.' AND g_0."time" > {ts '2016-04-20 00:00:00.0'}] > Caused by: com.osisoft.rdsa.RdsaException: [PIOLEDB] [SQL Parser] [Line 1] Synta > 48.x error near 'ts'. > If the translation were to simply remove the "ts" part the query would work: > SELECT TOP 1000 g_0."tag" AS c_0, g_0."time" AS c_1, g_0."value" AS c_2 FROM "piarchive"."picomp2" AS g_0 > WHERE g_0."tag" = 'sinusoid' AND g_0."time" > '2016-04-20 00:00:00.0' -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3520) Add support for Swagger Translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3520?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3520: --------------------------------------- I'm adding a release note for this. What kind of docs are needed for this? > Add support for Swagger Translator > ---------------------------------- > > Key: TEIID-3520 > URL: https://issues.jboss.org/browse/TEIID-3520 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 9.0 > > > http://swagger.io is popular REST service description framework, it defines a specification http://swagger.io/specification/ for REST service definition. > Teiid WS translator should add the ability to read this file (like WSDL) and provide the REST methods as endpoints that can be consumed from Teiid. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 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 2016