Tuesday, January 9, 2018

Teiid 10.0.2 Released

Teiid 10.0.2 has been released.  It resolves 13 issues:
  • [TEIID-5176] - Postgresql ODBC driver converts {fn CONCAT()} calls to a "textcat()" function
  • [TEIID-4851] - Random errors about PostGIS without using it
  • [TEIID-5164] - Infinispan hotrod translator aggregate functions issues
  • [TEIID-5168] - PrestoDB translator - Convert to float not pushed correctly
  • [TEIID-5178] - doc formatting issues
  • [TEIID-5183] - NPE in Swagger translator
  • [TEIID-5184] - Clob not supported in dynamic VDB
  • [TEIID-5186] - NPE in QueryResolver when calling virtual procedure
  • [TEIID-5189] - Empty XmlElement throws an NPE when passed for the non-nullable parameter
  • [TEIID-5198] - Procedure names containing . do not resolve properly
  • [TEIID-5199] - Infinispan hotrod translator correlated subquery with where criteria issue
  • [TEIID-5200] - INSERT INTO query fails in BEGIN ATOMIC block if data is obtained from atomic procedure which catches some exception
  • [TEIID-5204] - NOW() is calculated several times for SYS tables
10.1 is expected in about 2 weeks.  For anyone already using the PI translator, please pick up the latest snapshot as there have been quite a few fixes.

Thanks,
Steve

Wednesday, January 3, 2018

Teiid 9.3.6 Released

Happy New Year to everyone!  After an end of year slow down, Teiid 9.3.6 has been released.  It resolves 11 issues:
  • [TEIID-4851] - Random errors about PostGIS without using it
  • [TEIID-5027] - Translator infinispan-hotrod incorrect data type import
  • [TEIID-5153] - RAND function gives same results in view
  • [TEIID-5164] - Infinispan hotrod translator aggregate functions issues
  • [TEIID-5171] - Forward navigation of expand returns wrong results.
  • [TEIID-5172] - Missing message for key "TEIID31262"
  • [TEIID-5173] - Swagger API mixup
  • [TEIID-5183] - NPE in Swagger translator
  • [TEIID-5184] - Clob not supported in dynamic VDB
  • [TEIID-5189] - Empty XmlElement throws an NPE when passed for the non-nullable parameter
  • [TEIID-5198] - Procedure names containing . do not resolve properly
Expect a Teiid 10.1 in a couple of weeks.

Thanks,
Steve

Wednesday, December 6, 2017

Teiid 10.0.1 Released

Teiid 10.0.1 has been released.  It resolves 14 issues:
  • [TEIID-5106] - Tables names are case sensitive in Postgres/Oracle/MSSQL but not in Teiid.
  • [TEIID-5154] - Missing default method for IsDistinct
  • [TEIID-5137] - SystemAdmin.usage column dependency issue
  • [TEIID-5138] - JGroups Channel creation in domain mode is invalid
  • [TEIID-5139] - Reached maximum thread count "10" for worker pool "async-teiid-threads"
  • [TEIID-5140] - Teiid 10 postgres driver version
  • [TEIID-5146] - UNION of two similar JOIN queries fails with ASSERTION FAILED error if it contains table function of procedural call with arguments
  • [TEIID-5152] - "No value was available" error message when evaluating an expression
  • [TEIID-5153] - RAND function gives same results in view
  • [TEIID-5166] - Google spreadsheet insert fails
  • [TEIID-5171] - Forward navigation of expand returns wrong results.
  • [TEIID-5172] - Missing message for key "TEIID31262"
  • [TEIID-5173] - Swagger API mixup
  • [TEIID-5175] - Binding of Hive date types should not use the calendar
A 9.3.6 release will be made available before the end of the year.

Thanks,
Steve 

Wednesday, November 22, 2017

Teiid 9.3.5 Released

Teiid 9.3.5 has been released.  It resolves 8 issues:
  • [TEIID-5130] - Document/refine behavior of treating result parameter as the first parameter
  • [TEIID-5128] - transaction support value not cloned on access node
  • [TEIID-5133] - XmlTable path language is not always identical to XPathValue expressions
  • [TEIID-5137] - SystemAdmin.usage column dependency issue
  • [TEIID-5146] - UNION of two similar JOIN queries fails with ASSERTION FAILED error if it contains table function of procedural call with arguments
  • [TEIID-5152] - "No value was available" error message when evaluating an expression
  • [TEIID-5153] - RAND function gives same results in view
  • [TEIID-5166] - Google spreadsheet insert fails
For those in the US happy Thanksgiving.  You can expect community activity to return to normal next week.

Thanks,
Steve

Monday, November 6, 2017

Teiid 9.2.7 Released

Teiid 9.2.7 has been released.  It resolves 6 issues:
  • [TEIID-4870] - Google translator unexpected behavior for view update without trigger
  • [TEIID-5094] - Is DISTINCT FROM evaluation with two null values
  • [TEIID-5098] - Unsyncronized static date format for Salesforce bulk inserts
  • [TEIID-5107] - teiid-olingo-*.war not deploying in wildfly when using domain
  • [TEIID-5109] - Set operations and parenthesis
  • [TEIID-5133] - XmlTable path language is not always identical to XPathValue expressions
This is the last community release on the 9.2.x line.

Thanks,
Steve

Thursday, November 2, 2017

Teiid 10.0.0.Final Released

After 5 months of work we are pleased to announce the release of Teiid 10.0.0.Final.  This is longer than a typical cycle, but it should be worth the wait as we were able to pick up WildFly 11.0 and address 165 issues.  The major feature highlight are:
  • TEIID-4981 Amazon S3 translator support, now read the objects directly from Amazon S3 with security
  • TEIID-5026 The behavior of the FROM_UNIXTIME function was corrected and the related datetime functions UNIX_TIMESTAMP, TO_MILLIS, and FROM_MILLIS were added.
  • TEIID-1131 Added support for importing sequence information.
  • TEIID-5073 Added a salesforce-41 translator/resource adapter pair, which defaults to accessing the v40 salesforce API.
  • TEIID-4208 Added parallelism to plan execution involving large sorts.
  • TEIID-5002 Upgraded to WildFly 11
  • TEIID-4711 Generalized IS DISTINCT support.
Other Important Stuff:
  • Take note of major changes in the release in particular the removal of XML document models and switching the artifact group from org.jboss.teiid to org.teiid.
  • Teiid Spring Boot was launched make getting starting with Teiid and Spring seamless - thank you Ganesh Pol and Christian Posta for early testing
  • With TEIID-4208 and other performance enhancements you should expect to see a performance boost especially for higher data volume / lower query volume workloads.
  • Couchbase access is now quite robust
  • OsiSoft Pi access has gone under more review and will be continue to be refined in 10.1
Special thanks to the many community members who contributed to this release.  In particular dalex dalex and Mike Higgins who identified several important issues.

On the horizon:
  • Teiid 9.2.7 will be the last community release on 9.2.x and is expected tomorrow.  Teiid 9.3.x will receive "extended" community support until the release of 10.2 as to ease any transition issues.
  • Teiid WildFly Swarm will be updated in the near future.  Initially this may be against the 9.3.x release stream as Swarm is not yet on WildFly 11.
Thank you,
The Teiid Team

Thursday, October 26, 2017

Low-risk Monolith to Microservice Evolution

Christian Posta has written a series of blog posts covering a host of Red Hat technologies that enable migrating from a monolith to microservices.  For the impatient, the third part highlights the usage of Teiid Spring Boot.  Ramesh has done great work getting this effort off the ground and we hope that it continues to gain attention and community usage.  Please interact with us through JIRA or the forums if you have a data integration or migration scenario with Spring Boot that Teiid could help enable.

Thanks,
Steve