Skip to main content

Posts

Showing posts from 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

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 ext

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 ] -

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 ]

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 ]

Teiid 10.0.5 Released

Teiid 10.0.5 has been released . It resolves 8 issues: [ TEIID-5293 ] - Add implicit partitioning of joins to non-multisource partitioning as well [ 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 This is the final community release on the 10.0.x line. Please upgrade to 10.1 or 10.2 when possible.  Planning and work has begun on Teiid 11 and Teiid 1

Teiid 10.2.0 Released

We are pleased to announce the release of Teiid 10.2.0 .  This was the new normal of an 8 week cycle. See all 54 issues addressed.  The feature highlight are: TEIID-5236 Updated support for GeoServer and 9.4+ PostgreSQL JDBC drivers. TEIID-5246 Simplified configuration when using an external load balancer. TEIID-5248 v4 Api Support for Google Spreadsheets. TEIID-5220 Additional Npgsql support via limited information_schema support. Other Important Stuff: Several important OData translator issues were addressed - if you use the OData translator, you should upgrade or use next fix release 10.0.5/10.1.3 Teiid 10.1.3 and 10.0.5 will be available in about 3 weeks. Special thanks to the many community members who contributed to this release - in particular dalex dalex, Bram Gadeyne, Divyesh Vallabh, and Yuming Zhu. Thank you, The Teiid Team

Teiid 10.1.2 Released

Teiid 10.1.2 has been released . It resolves 13 issues: [ TEIID-5176 ] - Postgresql ODBC driver converts {fn CONCAT()} calls to a "textcat()" function [ TEIID-5268 ] - Anonymous bind login doesn't work for ldap connector [ TEIID-5269 ] - Odata4 metadata roundtrip is not in place [ TEIID-5271 ] - Joining more than one table/view to results of table function causes error [ TEIID-5274 ] - Odata4 translator can't handle conditions on columns which use conversions [ TEIID-5275 ] - OData4 translator doesn't handle IS NOT NULL condition properly [ TEIID-5276 ] - ClassCastException with OData4 translator when using COUNT function without GROUP BY clause [ TEIID-5277 ] - OData4 translator doesn't correctly translate LOCATE function to INDEXOF [ TEIID-5278 ] - Wrong indexing with SUBSTRING function and OData4 translator [ TEIID-5279 ] - OData4 translator incorrecly translates modu

Teiid 10.0.4 Released

Teiid 10.0.4 has been  released .  It resolves 17 issues: [ TEIID-5176 ] - Postgresql ODBC driver converts {fn CONCAT()} calls to a "textcat()" function [ TEIID-5253 ] - Timing issue in domain mode with materialization [ TEIID-5254 ] - Unhandled exception when making a multipart post to a rest varbinary value [ TEIID-5255 ] - Assertion failed in MergeJoinStrategy.setProcessingSortRight [ TEIID-5256 ] - Sysadmin Usage table doesn't track usage of procedures [ TEIID-5260 ] - TEIID30020 Processing exception for request, "select * into" doesn't work in some cases [ TEIID-5268 ] - Anonymous bind login doesn't work for ldap connector [ TEIID-5269 ] - Odata4 metadata roundtrip is not in place [ TEIID-5271 ] - Joining more than one table/view to results of table function causes error [ TEIID-5274 ] - Odata4 translator can't handle conditions on columns which use conver

Teiid 10.1.1 Released

Teiid 10.1.1 has been  released .  It resolves 13 issues: [ TEIID-5236 ] - Document and update GeoServer/PG JDBC compatibility [ TEIID-5242 ] - XML/JSON issues [ TEIID-5247 ] - SQL Server translator should support coalesce [ TEIID-5241 ] - Problem with OData proxy configuration [ TEIID-5243 ] - Embedded SessionService does not monitor sessions [ TEIID-5245 ] - Killed remote jdbc connections to an embedded server allowed to continue [ TEIID-5250 ] - Duplicate result uid reported when using procedure isFunction=true [ TEIID-5251 ] - OData WAR Module issue with WildFly-Swarm [ TEIID-5253 ] - Timing issue in domain mode with materialization [ TEIID-5254 ] - Unhandled exception when making a multipart post to a rest varbinary value [ TEIID-5255 ] - Assertion failed in MergeJoinStrategy.setProcessingSortRight [ TEIID-5256 ] - Sysadmin Usage table doesn't track usage of procedures

Teiid 9.3.7 Released

Teiid 9.3.7 has been released . It resolves 10 issues: [ TEIID-5190 ] - Postgresql translator does not support expressions in group by [ TEIID-5242 ] - XML/JSON issues [ TEIID-5200 ] - INSERT INTO query fails in BEGIN ATOMIC block if data is obtained from atomic procedure which catches some exception [ TEIID-5203 ] - Google Spreadsheet translator NPE thrown on UPDATE [ TEIID-5204 ] - NOW() is calculated several times for SYS tables [ TEIID-5221 ] - OData4 Translator generates invalid metadata [ TEIID-5241 ] - Problem with OData proxy configuration [ TEIID-5245 ] - Killed remote jdbc connections to an embedded server allowed to continue [ TEIID-5250 ] - Duplicate result uid reported when using procedure isFunction=true [ TEIID-5253 ] - Timing issue in domain mode with materialization This will be the last community release on the 9.3.x line.  Please upgrade to 10.x if possible - there is a sho

Teiid 10.0.3 Released

Teiid 10.0.3 has been  released .  It resolves 17 issues: [ TEIID-5174 ] - Filter internal constructs from oracle metadata [ TEIID-5190 ] - Postgresql translator does not support expressions in group by [ TEIID-5242 ] - XML/JSON issues [ TEIID-5247 ] - SQL Server translator should support coalesce [ TEIID-5136 ] - Osisoft translator - NPE when running query with inline view [ TEIID-5140 ] - Teiid 10 postgres driver version [ TEIID-5203 ] - Google Spreadsheet translator NPE thrown on UPDATE [ TEIID-5217 ] - preserve hint should be honored by rule plan outer joins [ TEIID-5221 ] - OData4 Translator generates invalid metadata [ TEIID-5226 ] - Error when inserting a Geometry value into PostgreSQL [ TEIID-5227 ] - Error when inserting a NULL value into a PostgreSQL Geometry datatype column [ TEIID-5235 ] - Could not find symbol in processing an inline view using except [ TEIID-5241

Data Integration for Java Developers - Introducing "Teiid Spring Boot"

Are you trying to integrate data from a REST web service with a data in your legacy RDBMS database?  How about data from Excel or CSV file,  JSON,  XML, MongoDB contents? As Java developers we know how to read the data from these sources and how to stitch data together, all it takes some boilerplate code right? How about running some filters on that data, working with data type incompatibilities between data sources like converting a string type to decimal, doing aggregations like grouping the records by certain parameters and finally exposing it as REST service and you got 30 minutes do it? If you have NOT heard about Teiid (t-ee-d) before, this software is exactly what it is designed to do. It has many more features, but let's focus on Data Integration feature. One of the basic features of Teiid is to provide ways to integrate data from multiple disparate sources where it knows how to work with data type incompatibilities and provides a relational data engine that can plan a

Teiid 10.1 Released

We are pleased to announce the release of Teiid 10.1.0 .  This was a shorter that usual release cycle, but that should become the new normal. See all 72 issues addressed.  The feature highlight are: TEIID-5161 Broader pushdown of the RAND function. TEIID-5134 The -final designation has been dropped from major/minor releases, and weekly snapshots have replaced preview releases. TEIID-5201 NpgSQL client query support. TEIID-5222 General array type conversion. TEIID-5212 Additional optimization of join order with left outer joins. Other Important Stuff: OsiSoft Pi support is now robust and should be suitable for most integration scenarios. Teiid 10.0.3 and 9.3.7 will be available in about 2 weeks. 9.3.7 will likely be the last release on the 9.3 line. Special thanks to the many community members who contributed to this release.  In particular dalex dalex, Aditi Patel, Divyesh Vallabh, El Fuego who identified several important issues each. Thank you, The Teiid Tea

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 bloc

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