[teiid-issues] [JBoss JIRA] (TEIID-4187) Extend support for PI OLEDB Enterprise Queries in OSI PI Translator
[
https://issues.jboss.org/browse/TEIID-4187?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-4187:
-------------------------------------
1) Turned OFF capability for "FULL OUTER JOINS", as PI does not support this
2) Turned ON capability for "supportsInlineViews" for allowing the Nested
tables.
3) Added following UDF
{code}
addPushDownFunction(PI, "ParentName", STRING, STRING, INTEGER);
//$NON-NLS-1$
addPushDownFunction(PI, "VarType", STRING, STRING); //$NON-NLS-1$
addPushDownFunction(PI, "UOMID", STRING, STRING); //$NON-NLS-1$
addPushDownFunction(PI, "UOMName", STRING, STRING); //$NON-NLS-1$
addPushDownFunction(PI, "UOMAbbreviation", STRING, STRING);
//$NON-NLS-1$
addPushDownFunction(PI, "UOMClassName", STRING, STRING); //$NON-NLS-1$
addPushDownFunction(PI, "UOMCanonicallD", STRING, STRING);
//$NON-NLS-1$
addPushDownFunction(PI, "UOMConvert", DOUBLE, DOUBLE, STRING, STRING);
//$NON-NLS-1$
{code}
4) During the metadata import converted all the artifacts with "guid" column
type to "string" in Teiid, the translator also does the appropriate casting for
value handling.
5) Added a "extension-metadata" property called "TVF", that can be
used decorate tables and procedures as Table Valued functions, which can be used in
lateral joins
6) Added support for push down of LATERAL JOINS, so that a LATERAL JOIN is converted to
"CROSS APPLY" or "OUTER APPLY" commands in PI
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: Ramesh Reddy
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.
4) When importing schemas, importer.ImportKeys has to be set to false as otherwise we
receive a DuplicateRecord exception since the table value function ft_GetPIPoint appears
in more than one place in the AF schemas. Could we please put in a fix/workaround to
address this?
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)