Tuesday, July 3, 2018

Blogging has moved

Now that we have worked the kinks out of our new teiid.io site, we've added a simple blogging feature there teiid.io/blog. For the time being however that means that some features will not there - such as an RSS feed or comments. As we get more familiar with Hugo, we'll add necessary features.

Thank you,
Steve

Wednesday, May 23, 2018

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, the last row is still used
  • [TEIID-5345] - ClassCastException if multi-column dependent join is pushed to literals
  • [TEIID-5347] - low level MetadataFactory properties not honored by DDL import
You can expect the next fix release in 4-5 weeks. Thank you, Steve

Tuesday, May 22, 2018

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 Korytkowski to the Teiid Team. Rafal has begun by finishing off the work on the Exosal translator and will help with efforts related to cloud and OpenShift support.

Other Important Stuff:
  • The new website is (mostly) live! See teiid.io. There are no under construction animated GIFs, but you can expect a few issues as we get the new Hugo/Netlify/Travis build worked out. Notice that we're effectively combining tooling and backend under a single site.  The content is being updated to be more relevant for cloud and OpenShift deployments. A lot of work is happening in creating a self-service data virtualization OpenShift based solution. If you have any interest in becoming involved, or would like to see more around the image build/configuration please let us know.
  • Teiid 10.2.2 and 10.1.4 will be available in the next couple of days. That will effectively end support for the 10.1.x release stream.
Thank you,
The Teiid Team


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 past all rows, the last row is still used
This concludes the community releases on 10.1.x. Please upgrade to 10.2 or 10.3. 10.2.2 will be released tomorrow. Thanks, Steve

Monday, May 7, 2018

Friday, April 20, 2018

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 pushdown of query with multiple JOINs
  • [TEIID-5320] - SAP IQ translator wrong pushdown of dateadd function
If you have time please check out the latest 10.3 snapshot. We are about half way mark in the cycle. 

Thanks,
Steve

Tuesday, April 17, 2018

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 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
Up next will be a 10.2.1 by the end of the week. Thanks, Steve