-
1. Re: Support for Oracle analytical functions in Teiid ?
shawkins Jul 30, 2012 8:32 AM (in response to masilamani)1 of 1 people found this helpfulTeiid 7.5 added support for built-in analytical and windowed aggregates in general. 7.6 corrected a few issues, and 7.7 added a general concept of a user defined aggregate function. So if you are starting with Teiid 7.7+, then you can use the built-in aggregates in a windowed manner and also the analytical function row_number, rank, dense_rank - see https://docs.jboss.org/author/display/TEIID/Expressions. The Teiid 7.7 user defined aggregate support is through extension metadata on scalar functions - see https://docs.jboss.org/author/display/TEIID/DDL+Metadata Create Function options. The extension metadata "aggregate" and "analytic" should allow you to create a custom analytic function. It can even be supported in the engine - see https://docs.jboss.org/author/display/TEIID/Support+for+User-Defined+Functions+%28Non-Pushdown%29
If using Designer though, there is a caveat that the extension metadata file shipped even with the latest version is not up-to-date, so you aren't given a chance to manipulate these properties - https://issues.jboss.org/browse/TEIIDDES-1456
-
2. Re: Support for Oracle analytical functions in Teiid ?
masilamani Jul 30, 2012 5:12 PM (in response to shawkins)Hi Steve,
Thanks and it's very useful to know that this feature is included in Teiid. We are using Teiid Designer 7.4.5 which is part of RedHat EDS 5.2 so i wonder whether Teiid 7.7 will be included in 5.3 release. will take a look at it when we have Teiid 7.7 available in EDS.
Thanks, Mani
-
3. Re: Support for Oracle analytical functions in Teiid ?
rareddy Jul 30, 2012 5:21 PM (in response to masilamani)1 of 1 people found this helpfulYes, Teiid 7.7 will be in the EDS 5.3.
-
4. Re: Support for Oracle analytical functions in Teiid ?
masilamani Aug 1, 2012 12:56 PM (in response to rareddy)Thanks Ramesh. Looks like EDS 5.3 / SOA-P 5.3 is already released so will look into oracle analytical functions.
-
5. Re: Support for Oracle analytical functions in Teiid ?
rareddy Aug 1, 2012 1:18 PM (in response to masilamani)If you are working with EDS or Teiid 7.7, please note that some of the above links supplied above point to 8.x Teiid not 7.7 Teiid. So, those DDL based features are not available, however user aggregates are supported.
Ramesh..
-
6. Re: Support for Oracle analytical functions in Teiid ?
masilamani Aug 1, 2012 7:21 PM (in response to rareddy)Ramesh,
Thanks for the info.
Thanks, Mani
-
7. Re: Support for Oracle analytical functions in Teiid ?
yapnel Jan 26, 2013 6:10 AM (in response to masilamani)Hi
Can you advise if the analytical functions will be pushed down to source?
Nelson
-
8. Re: Support for Oracle analytical functions in Teiid ?
shawkins Jan 28, 2013 8:56 AM (in response to yapnel)Yes, windowed functions are eligible for push-down. I should correct above that user defined aggregate support starts in Teiid 8.0, not 7.7. But you are able to define custom analytical functions using the same extensions as well.
Steve