Friday, February 12, 2016

Teiid 8.13.1 Released

Teiid 8.13.1 is now available.  It is a fix release addressing 15 issues:
  • [TEIID-3748] - Impala translator - SELECT and HAVING statements are translating differently for Case statements
  • [TEIID-3949] - Subqueries are wrongly pushed down to the underlying datasource
  • [TEIID-3950] - UDFs aren't found when using old function definitions model
  • [TEIID-3951] - Stored procedure in view model from SQL server 2000
  • [TEIID-3953] - .TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal".
  • [TEIID-3954] - OData 4 procedure/action result set lob handling incorrect
  • [TEIID-3956] - Retrieving just a stream property fails for OData4
  • [TEIID-3960] - Otherwise evaluatable constructs will inhibit pushdown
  • [TEIID-3963] - Arrays returned by actions/functions from odata4 result in errors
  • [TEIID-3964] - Cassandra does not account for null values
  • [TEIID-3969] - Missing translators in cli scripts
  • [TEIID-3971] - Clob.getSubstring(int,int) returns empty or whole string
  • [TEIID-3973] - org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate COLUMN1: No value was available
  • [TEIID-2734] - Add native query support to Cassandra
  • [TEIID-3936] - Wildfly kit is missing jboss integration docs
We are expected a Teiid 9.0 Alpha1 next week.  Please also checkout our new documentation home for 9.0 and later:

We are just through the initial conversion from confluence.  Please let us know if you see something that needs fixed.


Tuesday, January 26, 2016

Wildfly based Teiid 8.13 Final Released

Keeping up the tradition of time boxed releases, the Teiid team is proud to announce 8.13.0 Final which is based on Wildfly 9.0.2 We have resolved little over 100 issues (features, enhancements, bugs) in this release. You can download at

The major highlights are 
  • Wildfly integration. 
  • Completely re-done build system.
  • Includes all the fixes from maintenance release fixes in 8.12.x series. 
  • Teiid Embedded kit is now removed and examples are enhanced to use maven.
There will be no further maintenance releases on 8.12 series. We will start on 8.13 maintenance now.

Once again we had great interactions with community in developing this release. We sincerely extend our appreciation all the community folks who helped though out the 8.13 cycle.

What's Coming Next:

Even lot more. We are moving all the documents from confluence to gitbooks. We are already doing much progress on 9.0 release, expect a Alpha release in next few weeks. We are looking for integration with Spark, analytical platform and data quality tools. So, if you know of any solutions or have a recommendations please talk to us.

We are always looking for volunteers, so if you got idea or just want contribute to Teiid, please come talk to us in the forums.

Thank you for your continued support.

Ramesh & Steve.

Monday, January 18, 2016

Teiid 8.13 CR3 Released

Teiid 8.13 CR3 with WildFly 9.0.2 has been released. CR3 pulled forward a lot of fixes from 8.12.x (see the 8.12.4 blog entry) along with new issues since CR2 was released.

The final version of 8.13 should be released in approximately a week. If you are considering a migration to Teiid 8.13 / Wildfly, please test things out ahead of the release.  As needed fix releases will follow the final until Teiid 9 is stable.

Thanks for all the community support,

Wednesday, January 13, 2016

Teiid 8.12.4 Released

Teiid 8.12.4 has been released.  A somewhat large change is that there is now a new Redshift translator available to account for differences between Redshift and Postgres.  All issues addressed:

  • [TEIID-3874] - Invalid source query for subquery referencing a common table
  • [TEIID-3879] - Error during state transfer prevents a node from loading later
  • [TEIID-3880] - Missing dependency in "org.apache.olingo" module
  • [TEIID-3882] - Unable to convert Geometry Collection to GeoJSON
  • [TEIID-3884] - Queries with NextToken failing with NPE
  • [TEIID-3885] - Redshift - conversion to time does not work
  • [TEIID-3886] - Redshift - query ends with error message "Query cancelled on user's request"
  • [TEIID-3887] - Redshift - RS does not support ASCII function
  • [TEIID-3888] - Redshift - there is not function SUBSTR (RS uses SUBSTRING)
  • [TEIID-3889] - asynch start transaction / rollback throws exception
  • [TEIID-3891] - MetadataFactory create function from method does not account for primitive return types
  • [TEIID-3892] - There is no pg type for geometry
  • [TEIID-3895] - OData - metadata returns primary key with attribute "Nullable=true"
  • [TEIID-3897] - dimensional check for ewkb is incorrect
  • [TEIID-3900] - OData - malformed URL causes NPE
  • [TEIID-3876] - Add an option to import RowId as binary
  • [TEIID-3899] - Allow Web Services translator to retrieve metadata without source connection
  • [TEIID-3270] - Allow UDFs to call Teiid functions
  • [TEIID-3419] - Add ability to set a default role across all VDBs
  • [TEIID-3870] - Add ability to properly qualify package objects
  • [TEIID-3890] - Add a redshift translator
  • [TEIID-3865] - too much logging of source cancel
  • [TEIID-3866] - with clause used by subquery repeated in the subquery
  • [TEIID-3875] - Many info messages upon startup that start with: TEIID31173 Inherent
  • [TEIID-3893] - Handling of binary odbc parameters needs improved
  • [TEIID-3896] - When error occurs in the materialization process, an ERROR should be logged instead of DEBUG
  • [TEIID-3901] - MetadataFactory should account for user defined aggregate functions
This should be the last release on the 8.12.x line.  Expect another Teiid 8.13 CR shortly - with a final release by the end of next week.  From there fixes will be available on the 8.13 line.  Teiid 8.13 has support for Wildfly 9.0.2 support, but no new feature work so that it provides a transitional release into Teiid 9.  Teiid 9.0 Alpha is still expected by the end of January.


Tuesday, January 5, 2016

Teiid 8.13 CR2 with WildFly 9.0.2

The candidate release 2 of Teiid 8.13 with WildFly is now released. The target version of WildFly is 9.0.2.Final, which is latest stable release by the WildFly team. You can download it from
This version removed the "embedded" and includes various fixes/enhancements that are going on in 8.12.x series. All those issues are forward merged into this release.

We can consider CR2 version is pretty close to the final version to be released in a week. If you have not tested your Teiid usecase, test it right away and let us know of any issues you see.

Thank you.


Monday, December 14, 2015

Teiid 8.13 Beta1 with WildFly 9.0.2 Available

The next revision Beta1 of Teiid 8.13 with WildFly is now released. The target version of WildFly we choose is 9.0.2.Final, which is latest stable release by the WildFly team. You can download it from

The issues described about sockets, clustering in previous release are now fixed. Support for Web-Console is added back in this release. The navigation of Web-Console has changed a lot, so please take a look and give us feedback.

In the next revision we will be removing "embedded" kit, and will be updating the corresponding examples soon.  We expect to have release a candidate release before the holiday break and hopefully final following soon after that.

This Beta1 version is be good version for start testing you usecase and letting us know about any issues you encounter, we can try fix them before final release.

Thank you.


Thursday, December 10, 2015

Teiid 8.12.3 Released

Teiid 8.12.3 has been released.  Issues addressed include:
  • [TEIID-3814] - Rest Web Service URL for VDB
  • [TEIID-3823] - Issues with fetchsize and local connections
  • [TEIID-3827] - multi-source view insert throwing TEIID30492 error
  • [TEIID-3840] - teiid-outh-util.bat - typo in name
  • [TEIID-3841] - sap-nw-gateway translator wrongly encodes when a parameter includes a space
  • [TEIID-3845] - select count(*) query not working on SimpleDB connector in Teiid
  • [TEIID-3846] - Wrong alias rewriting in subqueries
  • [TEIID-3847] - HiveTranslator should not use a Calendar for the Hive getDate
  • [TEIID-3848] - Issue with hive literal timestamps
  • [TEIID-3850] - Source caching with the cache directive can be at the wrong scope
  • [TEIID-3851] - foreign temp additional extension properties not accessible in QMI
  • [TEIID-3854] - Impala translator - ORDER BY clause using incorrect columns when not in SELECT list
  • [TEIID-3857] - ProjectIntoNode should report a transaction required even with iterator processing
  • [TEIID-3858] - Planning error with unrelated sort columns and view removal
  • [TEIID-3682] - Add logon properties to audit messages
  • [TEIID-3831] - For results set caching there should scope metadata for source tables/procedures
  • [TEIID-3829] - olingo module junit test failed
  • [TEIID-3839] - minimize implicit dependencies on sun classes
Depending upon the progression of 8.13 and the criticality of any issues discovered, this may be the last of the fix releases on 8.12.x.  Teiid 8.13 is introducing Wildfly 9 support, but no new feature work so that it provides a transitional release into Teiid 9.  Teiid 8.13 should provide Beta1 next week and the first 9.0 Alpha should be available by the end of January.