Skip to main content

Posts

Teiid Runtimes Explained

If you have been following Teiid lately we have been going through a whole lot of renovations. Yes, renovations or reorganization or refactoring or whatever you want to call it. Basically, we are making Teiid more modular with fewer dependencies that can be used by however your use case dictates rather than use it as one monolith application deployed into WildFly JEE Application Server. There is nothing wrong in using Teiid as server model, but with the proliferation of container-based workloads and cloud-based architectures, the previous server-based model does not work or simply won't scale. So, we needed to think of alternatives, thus Teiid team introduced a couple different versions modular Teiid what we are calling as "Teiid Runtimes".

Note that in these modular Teiid runtimes, not all the features you were used to using in Teiid Server model may not be there but you will have extensions to add in those that are most appropriate for your domain. If you are looking …
Recent posts

Teiid 10.2.2 Released

Teiid 10.2.2 addresses 14 issues:
[TEIID-5336] - Improve TEIID-5253 [TEIID-4784] - Provide functionality to perform RENAME table in DDL scripts [TEIID-5324] - MongoDB: SecurityType "None" is not working [TEIID-5328] - regression of org.teiid.padSpace does not affect to the "IN" operator behavior [TEIID-5329] - Problem with salesforce url [TEIID-5330] - FIRST_VALUE/LAST_VALUE/LEAD/LAG functions always try to return integer [TEIID-5331] - LEAD/LAG ignores ORDER BY in the OVER clause [TEIID-5333] - Complex foreign keys set the referenced key regardless of order [TEIID-5334] - Improve pg/ODBC mapping of char type [TEIID-5335] - "No value was available" in ROW_NUMBER while inserting in foreign temporary table [TEIID-5339] - Vertica join query fails due to unexpected ordering of intermediate results [TEIID-5342] - If excel FIRST_DATA_ROW_NUMBER is past all rows, th…

Teiid 10.3.1 Released

We are pleased to announce the release of Teiid 10.3.1 (A regression with TEIID-5314 caused an immediate patch release).  See all 48 issues addressed.  The feature highlight are:
TEIID-5293 Added implicit partition wise joining in non-multisource scenarios as well.TEIID-5308 Added ENV_VAR and SYS_PROP functions and clarified the usage of the ENV function.TEIID-4745 Added a polling query to trigger the reload of materialized views.TEIID-5317 Added ODBC 3.0 functions current_time, current_date, current_timestamp.TEIID-5314 Environment variables can now be used instead of or to override system properties.TEIID-5307 Added more information_schema tables for pg compatibility.TEIID-4864 Added update support to the Excel translator. Special thanks to the many community members who contributed to this release - in particular Andreas Krück, Divyesh Vallabh, Mathieu Rampant, Mike Higgins, Pedro Inácio, Yuming Zhu, Michael Echevarria, and Bram Gadeyne.

We should also extend a warm welcome to Rafal…

Teiid 10.1.4 Released

Teiid 10.1.4 has been released. It resolves 12 issues: [TEIID-5336] - Improve TEIID-5253 [TEIID-4784] - Provide functionality to perform RENAME table in DDL scripts [TEIID-5319] - SAP IQ translator wrong pushdown of query with multiple JOINs [TEIID-5324] - MongoDB: SecurityType "None" is not working [TEIID-5326] - SAP IQ timestamp conversion to varchar wrong resulting format [TEIID-5328] - regression of org.teiid.padSpace does not affect to the "IN" operator behavior [TEIID-5329] - Problem with salesforce url [TEIID-5330] - FIRST_VALUE/LAST_VALUE/LEAD/LAG functions always try to return integer [TEIID-5331] - LEAD/LAG ignores ORDER BY in the OVER clause [TEIID-5333] - Complex foreign keys set the referenced key regardless of order [TEIID-5339] - Vertica join query fails due to unexpected ordering of intermediate results [TEIID-5342] - If excel FIRST_DATA_ROW_NUMBER is …

Teiid 10.2.1 Released

Teiid 10.2.1 has been released. It resolves 12 issues:
[TEIID-5293] - Add implicit partitioning of joins to non-multisource partitioning as well [TEIID-5220] - Add support for information_schema namespace [TEIID-5294] - Bug with the name correction logic (TEIID30151 eror) [TEIID-5296] - With MongoDB, timestamp operations throw exceptions when called on null or missing values [TEIID-5297] - With MongoDB, null is returned from timestamp functions if the same function is part of WHERE clause [TEIID-5300] - ClassCastException during query Optimization [TEIID-5310] - updateMatView does not check for null validity [TEIID-5312] - NullPointerException thrown when the second time login via GSS API [TEIID-5313] - Oracle translator issue with mixing string types and general issues with non-ascii strings [TEIID-5315] - MATVIEW_MAX_STALENESS_PCT reloads only based upon ttl [TEIID-5319] - SAP IQ translator wrong …

Teiid 10.1.3 Released

Teiid 10.1.3 has been released. It resolves 13 issues:
[TEIID-5293] - Add implicit partitioning of joins to non-multisource partitioning as well [TEIID-5265] - AssertionError: Batch not found in storage [TEIID-5288] - OData4 skiptoken is not pulling from the cached results [TEIID-5290] - NOW() function returns the same value for each call in BEGIN...END block [TEIID-5294] - Bug with the name correction logic (TEIID30151 eror) [TEIID-5296] - With MongoDB, timestamp operations throw exceptions when called on null or missing values [TEIID-5297] - With MongoDB, null is returned from timestamp functions if the same function is part of WHERE clause [TEIID-5300] - ClassCastException during query Optimization [TEIID-5301] - With MongoDB, a query with subquery in HAVING clause doesn't return any results [TEIID-5310] - updateMatView does not check for null validity [TEIID-5312] - NullPointerException thro…