Monday, July 10, 2017

Teiid 9.3.1 Released

Teiid 9.3.1 has been released.  23 issues were addressed:
  • [TEIID-4636] - In the SWARM readme's, need to indicate the URL to connect
  • [TEIID-4793] - Change of class loading no longer requires module dependencies
  • [TEIID-4985] - Update Quickstart to use new columns in status table
  • [TEIID-4315] - HBase Quickstart issues
  • [TEIID-4896] - Two VDB's referencing same teiid_ispn:cache is not using the same cache
  • [TEIID-4942] - Statement batch does not enforce autoCommitTxn
  • [TEIID-4947] - Error with Salesforce translator if criteria on outer join on a custom table is from the right side table
  • [TEIID-4948] - java.lang.IllegalArgumentException: No marshaller registered for ispn.G1
  • [TEIID-4950] - PostgreSQL Linux ODBC driver v09.06.0100 and newer does not work with Teiid Server 9.1.1
  • [TEIID-4953] - JOIN of CTEs fails if one of them is dependent and has window functions with inner DISTINCT in underlying queries
  • [TEIID-4960] - Problems when using External Materialized Views
  • [TEIID-4961] - External Materialized View With State Loaded but 0 Cardinality
  • [TEIID-4962] - 9.3 teiid-standalone-mode-install.cli gives an error on startup
  • [TEIID-4967] - Couchbase - incorrect data returned from VIEW if one value is NULL
  • [TEIID-4968] - oids are not unique in pg_attribute
  • [TEIID-4969] - Couchbase - ORDER BY returns empty result
  • [TEIID-4970] - Couchbase - GROUP BY returns empty result
  • [TEIID-4972] - Couchbase - query with comparison criteria not properly translated
  • [TEIID-4973] - Couchbase - Teiid returns empty result if source query fails
  • [TEIID-4974] - Couchbase - TRANSLATE function is transalted as REPLACE
  • [TEIID-4975] - Couchbase - SUBSTRING function is not translated correctly
  • [TEIID-4986] - Couchbase import nested array handling
  • [TEIID-4952] - release notes is not having tokens replaced
The next preview release of 10.0 will be due out in about 2 weeks.

Thanks,
Steve

Tuesday, July 4, 2017

Teiid 10.0.0 Alpha1 Released

Teiid 10.0.0 Alpha1 has been released.  Feature work is still ongoing. We're active in Spring Boot support, an OrientDB translator, and re-licensing - as of this release the main project and documentation are under ASL2 license instead of the LGPL.

Other News:
  • Couchbase testing has revealed a host of issues with this new translator.  We'll address these in both 9.3.x and 10.0.
  • Teiid 9.3.1 will be available in the next week.
  • Please have a look at the Red Hat effort around Spark in OpenShift - radanalytics.io.  As our OpenShift support evolves you will be able to rapidly integrate Teiid with elastic analytical workloads in Spark.
Thanks,
Steve

Monday, June 12, 2017

Teiid 9.2.4 Released

Teiid 9.2.4 has been released.  7 issues were addressed:
  • [TEIID-4858] - hive translator is extremely slow
  • [TEIID-4838] - View with a union that projects nulls fails to resolve properly
  • [TEIID-4875] - Planning issue with multiple aggregate decompositions through a join tree
  • [TEIID-4913] - MetadataFactory is not replacing . in column names
  • [TEIID-4927] - Update dockerfile
  • [TEIID-4942] - Statement batch does not enforce autoCommitTxn
  • [TEIID-4953] - JOIN of CTEs fails if one of them is dependent and has window functions with inner DISTINCT in underlying queries
From here the pace of fix releases for 9.2 will begin to slow.  The next fix will be released in 6-8 weeks.  9.3.x will become the primary focus of support - expect a 9.3.1 in 2-3 weeks.

Also the first preview release of 10.0 will be due out in about 1.5 weeks.

Thanks,
Steve

Friday, June 9, 2017

Teiid 9.1.5 Released

Teiid 9.1.5 has been released.  This will be the last patch release off of 9.1.x.

9 issues were addressed:
  • [TEIID-4797] - Oracle: empty catalog messed up VDB schemas name
  • [TEIID-4819] - Tree page modifications removing the previous page, don't remove immediately
  • [TEIID-4852] - Wrong OData results with multiple self relationships
  • [TEIID-4877] - Boolean syntax is broken on pg 9.5 data sources
  • [TEIID-4890] - DatabaseMetadata Procedure Columns order is incorrect
  • [TEIID-4892] - oData v4 error using $expand
  • [TEIID-4893] - Inconsistent behavior of SUBSTRING function
  • [TEIID-4927] - Update dockerfile
  • [TEIID-4953] - JOIN of CTEs fails if one of them is dependent and has window functions with inner DISTINCT in underlying queries
We will continue to support 9.2 and 9.3.  Expect a 9.2.4 release early next week.

Thanks,
Steve

Tuesday, June 6, 2017

Teiid 9.3 Final Released

With about 3 1/2 months of work, 138 issues later, 9.3 Final release is ready.  Feature highlights include:
  • TEIID-3624 CREATE DOMAIN support for user-defined simple types.
  • TEIID-4724 DDL .vdb deployment.
  • TEIID-4557 TEIID-2465 Memory restrictions at the operation and session level.
  • TEIID-4578 SQLAlchemy and Superset support through our pg/odbc access.
  • TEIID-4646 LEAD/LAG/FIRST_VALUE/LAST_VALUE analytic/value function support.
  • TEIID-2820 Couchbase support via a new translator and resource adapter.
  • TEIID-4733 Infinispan Support via a new translator and resource adapter.
There were also several important planning issues that were resolved including: More join pruning and left outer join optimization.

DDL VDB support has been enhanced to be nearly equivalent to of its XML counterpart.  We will continue to improve the usability, feature set, and refine the syntax when necessary.


UI Work

If you haven't seen it, please also check out Data Service Builder - which is a streamlined web UI for JDV/Teiid. We will release a Designer version based on Teiid 9.3 in near future. However after that Designer will be mostly in maintenance mode.  We are going to focus more on Web-based UI for future.

10.x and Beyond

Although initially slated for 9.3 change data capture (CDC) event handling based on Debezium to keep the materialization tables in sync with source data sources like MySQL and PostgreSQL will be delayed until 10.0 or later.

With the emergence of Cloud-based processing and Microservices architectures, we have been taking a hard look at Teiid and how we could progress technology into future. We have laid out some initial plans about our thinking and some immediate actions. We are soliciting your input all these matters, so please get involved so that we can shape Teiid together.

Thanks again to everyone who contributed to this release.
Ramesh & Steve

Friday, May 26, 2017

Teiid 9.3 CR1

Teiid 9.3 CR1 has been released.  A recap of all feature highlights:
  • TEIID-3624 CREATE DOMAIN support for user defined simple types.
  • TEIID-4724 DDL .vdb deployment.
  • TEIID-4557 TEIID-2465 Memory restrictions at the operation and session level.
  • TEIID-4578 SQLAlchemy and Superset support through our pg/odbc access.
  • TEIID-4646 LEAD/LAG/FIRST_VALUE/LAST_VALUE analytic/value function support.
  • TEIID-2820 Couchbase support via a new translator and resource adapter.
  • TEIID-4733 Infinispan Support via a new translator and resource adapter.
There have been 136 issues addressed so far - https://issues.jboss.org/projects/TEIID/versions/12332954 - please test your issues if possible before the final release in early June.

Other news:
  • A Teiid 9.1.5 will be released shortly after 9.3 Final.
  • Teiid 10.0 work has begun.
    • Please comment on TEIID-4895 with regards to WildFly utilization.  Comments on JRE support are welcome as well - can you describe what circumstances may be holding you to 1.6 or 1.7?
    • We will likely start including the Data Services Builder in the all-in-one download.  Data Services Builder and other efforts will be at the forefront of offering data virtualization on OpenShift.
Thanks,
Steve

Thursday, May 11, 2017

Teiid 9.2.3 Released

Teiid 9.2.3 is now available.  This fix release covers 12 issues:
  • [TEIID-4861] - ASSERTION FAILED: expected reference to be not null
  • [TEIID-4868] - formats in timestampformat functions on sybase are ignored.
  • [TEIID-4874] - SQL Server translator should support full outer join by default
  • [TEIID-4875] - Planning issue with multiple aggregate decompositions through a join tree
  • [TEIID-4876] - Salesforce connector not working properly in 9.2.2 release
  • [TEIID-4877] - Boolean syntax is broken on pg 9.5 data sources
  • [TEIID-4887] - Domain mode configuration fails with CNF
  • [TEIID-4890] - DatabaseMetadata Procedure Columns order is incorrect
  • [TEIID-4892] - oData v4 error using $expand
  • [TEIID-4893] - Inconsistent behavior of SUBSTRING function
  • [TEIID-4899] - import foreign schema "import qualifiers" problem
Thanks,
Steve