Tuesday, December 13, 2016

Teiid 9.2 Alpha2 Available

Teiid 9.2 Alpha2 has been released. Due to the break and other issues this took slightly longer than anticipated.  Feature highlights since Alpha1:
  • TEIID-4532 Hashing Functions were added for md5, sha1, sha2-256, and sha2-512.
Feature Progress:

  • The DDL metadata system feature has been pared down to just TEIID-4629  
  • We're also putting more emphasis on materialization issues in anticipation of greater integration with Debezium.
Even if the features are not fully formed yet, the pace of fixes in general has been good as we're closing in on 70 issues.

Given the upcoming break, I don't expect the next pre-release until around January 6th.  Hopefully we'll be back to about every two weeks after than and stay on track for an early to mid February release.

Thanks,
Steve

Thursday, December 8, 2016

Data Service Builder - Sprint 8 available

The Teiid Tooling team has completed a Sprint 8 milestone for the Data Service Builder (DSB).

Data Service Builder (DSB) is a web interface that allows you to easily connect to your data, compose a data service, then test and deploy the data service for your applications to consume as an OData-based REST service.

See our Getting Started Page for instructions to download and try it out.   Also check out our Future Sprint Development Plans page.

Tuesday, November 22, 2016

Kerberos Authentication to Oracle from Teiid

In this article I will show step by step instructions on how to configure WildFly server running Teiid to participate in Kerberos login into Oracle database. This article also shows how the kerberos ticket is used for credential delegation to Oracle and also using Teiid OData Rest Web Service.

See https://developer.jboss.org/docs/DOC-55813 for full details.

Wednesday, November 16, 2016

Teiid 9.2 Alpha1 Released

Teiid 9.2 Alpha1 has been released.  Feature highlights so far:
In progress features:

  • Also using Teiid as a Postgres/Postgis source for qgis is nearly complete.
  • The build has been revamped to support our integration with WildFly Swarm.  Swarm provides a powerful new mechanism for embedding Teiid with the full power of the application server.  See an example/description at https://github.com/teiid/wildfly-swarm-teiid
  • It's not in this alpha, but a lot of work has been completed toward a more complete DDL metadata system.  Please follow this and other issues if you are interested in contributing.

We'll continue to shoot for a pre-release about every two weeks and still expect the final release in about 3 months.

Thanks,
Steve

Monday, October 31, 2016

Teiid 9.1.1 Released

Teiid 9.1.1 has been posted.  It addresses 7 issues:
  • [TEIID-3755] - Allow embedded to set the default authentication type
  • [TEIID-4499] - OData Kerberos cannot access VDB
  • [TEIID-4535] - Issues with EventDistributor
  • [TEIID-4541] - trustAllLocal works even for remote connections
  • [TEIID-4546] - On setting jboss-teiid cluster : throwing java.lang.IllegalArgumentException.
  • [TEIID-4547] - getQueryPlan fails in adminapi
  • [TEIID-4530] - Add semicolons to generated ddl
The most significant of which is a security issue - TEIID-4541.  If you are allowing remote JDBC connections, not using data roles, and have left trustAllLocal at the default setting, then remote connections that specify PassthroughAuthentication=true are also being allowed.  Please upgrade or alter your settings to prevent this.

The pace of fix releases for 9.0.x will now be much slower and end with the release of 9.2 Final.  The first alpha release of 9.2 should be available by the end of the week.

Thanks,
Steve

Wednesday, October 26, 2016

Teiid 9.0.5 Released

Teiid 9.0.5 has been posted.  It addresses 25 issues.  The most significant of which is a security issue - TEIID-4541.  If you are allowing remote JDBC connections, not using data roles, and have left trustAllLocal at the default setting, then remote connections that specify PassthroughAuthentication=true are also being allowed.

A fix release for 9.1 including TEIID-4541 will be available for 9.1 by Monday.  The first alpha release of 9.2 should be available by the end of next.

Thanks,
Steve

Thursday, October 20, 2016

Teiid 8.13.7 Released

8.13.7 is the last official release on the 8.13.x line and addresses 8 issues:
  • [TEIID-4325] - ASSERTION FAILED: expected reference to be not null
  • [TEIID-4354] - patch to CXF no longer needed with new version of the CXF in 9.0 series.
  • [TEIID-4360] - default token type needs to be "bearer" for OAuth2 access code negotiation
  • [TEIID-4405] - delete using in statement does not remove records from temporary table
  • [TEIID-4407] - Salesforce delete/update without a predicate does nothing
  • [TEIID-4448] - Multi-way join predicate inappropriately removed
  • [TEIID-4463] - No results with cross source outer join and offset only
  • [TEIID-4471] - Assertion error with temp table delete
Please upgrade to 9.x when possible, and please consult the release notes and the documentation to minimize potential issues.

Up next we have 9.0.5 due out by the middle of next week with a 9.2 Alpha1 the following week.

Thanks,
Steve

Friday, October 14, 2016

Teiid 9.1 Released

Teiid 9.1 is now available - http://teiid.jboss.org/downloads/.  We took an extra month in development as it turned out to be another large release with almost close to 200 issues. 

Teiid 9.1 is based upon WildFly 10.0.0.Final.  The downloads page contains a consolidated download with WildFly 10.0.0.Final + Teiid 9.1.0 + Teiid Web-Console 2.7.0.  You may also choose to use Docker image on Docker HubThe latest documents can be found on Teiid's GitBook site.

The major highlights of the release include

  • TEIID-2715 OData Metadata support for providing the metadata extension properties for OData.
  • TEIID-4243 BatchUpdateException support in JDBC to indicate what part of batch succeeds when a failure occurs.
  • TEIID-4191 NO QUOTE option for TEXTAGG.
  • TEIID-4200 Moved to WildFly 10 as host environment
  • TEIID-4332 Improved NDV calculations for costing.
  • TEIID-4378 TEIID-4376 Clob enhancements to support concat and use in EXECUTE IMMEDIATE.
  • TEIID-4100 OData expand support for siblings and nested expands.
  • TEIID-4393 Additional Geospatial Functions to more fully support the SQL-MM specification.
  • TEIID-4421 Embedded Translator Refinements to allow for functioning that is similar to the server.
  • TEIID-3630 Merge/Upsert pushdown is now supported.
For complete list see https://issues.jboss.org/browse/TEIID/fixforversion/12329070

Data Quality and Data Cleansing

We are very excited to announce that we have been working with Open Source Data Quality (OSDQ) community to bring Data Quality and Data Cleansing tools to Teiid. The OSDQ community released their latest Profiler UI tool 6.1.8 with built in first class support for Teiid, for which we sincerely grateful. This tool has many advanced Data Quality and Data Cleansing features, and we hope you give it try and give your feed back. Here are some videos to get you started with this tool.
If you have questions or suggestions on this tool, you can use Teiid forums to ask questions. The community leaders from OSDQ will also be monitoring Teiid forms.

What's Coming Up?

9.2 work is well underway - with a couple of BIG usability features. One of them is FULL DDL support - where Teiid will allow the creation of a VDB just using DDL in an ad-hoc manner just like any RDBMS. We are implementing much of the SQL-MED specification to accommodate the feature. We will also have support for WildFly Swarm.  Swarm can change forever the way you will build your Teiid applications in Microservices area or just as an another embedded application. There will be lot more talk and blogs about this in coming months on these topics. If you are interested please get INVOLVED!

Community, Community, Community

We are seeing steady increase in participants in all forms for which we are very grateful, we can't thank you enough. So, keep those questions rolling, express your opinions and STAY involved. Don't be shy with new ideas, we need to keep pace with market trends folks! and we can't do it without YOUR involvement.

Thank you.

Ramesh & Steve. 

Saturday, October 1, 2016

Teiid 9.1 CR1 Posted

Teiid 9.1 CR1 has been posted.  Notable features since Beta2:
  • TEIID-3630 Merge/Upsert pushdown is now supported.
There have been nearly 180 total issues addressed.  There is still time to address a few more important ones - so please let us know if you find anything otherwise the fix will be delayed until 9.1.1.

We will closely follow the final release with 9.0.5 and the last installment on 8.13.x - 8.13.7.

Thanks again for all the community support,
Steve

Monday, September 26, 2016

Teiid Licensing

Teiid has been under the LGPLv2.1 since its initial open sourcing effort.  Current trends for JBoss projects are toward more permissive licensing.  Many JBoss projects have already moved to the ASL (Apache Software License), and there is interest in having Teiid follow suit.  We'll track this effort under https://issues.jboss.org/browse/TEIID-4474.

If you have been a contributor we'll be reaching out to you regarding this proposal - or even better go ahead and leave your thoughts on the issue.

Thanks,
Steve

Wednesday, September 14, 2016

Teiid 9.1 Beta2 Released

Teiid 9.1 Beta2 has been posted.  Notable features since Beta1:
  • TEIID-4421 Embedded Translator Refinements to allow for functioning that is similar to the server.
There have been about 140 total issues addressed so far in 9.1 and there is on-going work to support full DDL definition of VDBs - but that may be delayed to 9.2 if needed.

We should be on track for a final release around the second week of October.

Thanks again for all the community support,
Steve

Tuesday, September 13, 2016

Teiid 9.0.4 Released

The 9.0.4 fix release is now available.  It addresses 13 issues since 9.0.3:
  • [TEIID-4263] - StringToTimestamp in convert fails during DST transition hour
  • [TEIID-4402] - Insert statement with a date field fails
  • [TEIID-4405] - delete using in statement does not remove records from temporary table
  • [TEIID-4406] - group by cast(... as date) results in NullPointException
  • [TEIID-4407] - Salesforce delete/update without a predicate does nothing
  • [TEIID-4410] - ConnectorWorkItem setting of convertIn should be based upon the execution factory
  • [TEIID-4417] - Issues with OData query generation logic
  • [TEIID-4424] - Error when factory overrides initCapabilities due WrappedConnection is what Teiid is passing
  • [TEIID-4434] - Results returned by google spreadhseet may have columns missing labels, preventing the VDB to load
  • [TEIID-4435] - HIVE: decimal datatype is treated like a string
  • [TEIID-4436] - TEIID11008:PSQLException-ERROR: missing FROM-clause entry for table "anon_grp0" running a query with GROUP BY and UNION ALL
  • [TEIID-4439] - salesforce-34 translator dependencies issues
  • [TEIID-4366] - Provide CORS support on OData Service
Thanks to all those who logged issues.  Also 9.1 Beta2 should be available by tomorrow.

Steve

Thursday, August 25, 2016

Teiid 9.1 Beta1 Released

After a small delay Teiid 9.1 Beta1 has been posted.  Notable features since Alpha2:
  • TEIID-4332 Improved NDV calculations for costing.
  • TEIID-4284 Salesforce Bulk API for SELECT queries.
  • TEIID-4378 TEIID-4376 Clob enhancements to support concat and use in EXECUTE IMMEDIATE.
  • TEIID-4100 OData expand support for siblings and nested expands.
  • TEIID-4393 Additional Geospatial Functions to more fully support the SQL-MM specification.
As always thanks for all the community support including the Impala analytical function support contributed by Don Krapohl.

Steve

Friday, August 19, 2016

Teiid 9.0.3 Released

The 9.0.3 fix release is now available.  It addresses 9 issues since 9.0.2:
  • [TEIID-4343] - Impala Translator - With Clause Support
  • [TEIID-4354] - patch to CXF no longer needed with new version of the CXF in 9.0 series.
  • [TEIID-4360] - default token type needs to be "bearer" for OAuth2 access code negotiation
  • [TEIID-4372] - Impala AVG returns double when bigdecimal is expected
  • [TEIID-4384] - Issue with ordered offset
  • [TEIID-4385] - Nested subquery in an aggregate fails to evaluate
  • [TEIID-4389] - Local connection waits for active VDB 1,000,000 times longer than specified in waitForLoad property
  • [TEIID-4391] - NONDETERMINISTIC functions incorrectly optimized out of ORDER BY
  • [TEIID-4395] - Oracle translator should pushdown clob conversion
A special thanks to Marco Adrito for discovering and working through TEIID-4354 and TEIID-4360.

Looking forward 9.1 Beta1 should be available by the end of next week.

Steve

Tuesday, August 16, 2016

Teiid Designer 10.1 released to support Teiid 9.0 and Wildfly

Teiid Designer 10.1 is our first release that supports Teiid 9.0 and the Wildfly runtime environments.

This release also includes a couple dozen bug fixes (see Release Notes) and enhancements.  Of note are:
  • support for Teiid 9.0 VDB versioning (i.e. major.minor.patch values)
  • multi-character delimiter option in flat file importer
 Try it out!  Download and install....

Teiid Tooling Project Team

Friday, July 29, 2016

Teiid 9.1 Alpha2 Available

After a small delay Teiid 9.1 Alpha2 has been posted.  Notable features since Alpha1:
  • TEIID-4332 Improved NDV calculations for costing.
  • TEIID-2715 OData Metadata support for providing the metadata extension properties for OData.
Also the OData 2 service layer has been removed.  Please contact the community if you still need that functionality and want to maintain it as an independent project.

WildFly Upgrade

While most of the issues with the WildFly upgrade should be resolved.  It is unclear when progress will be made on TEIID-3834: start/stop of a data source or resource adapter requires a restart (somewhat worse behavior than WildFly 9 from our perspective)

Teiid Whipper

Whipper is a new project that will incorporate the changes made to our BQT testing framework by our Red Hat QE team and will aim to provide new features / ease of use for validation testing of all things Teiid.

Teiid Designer

Teiid Designer should have a release compatible with WildFly 9 / Teiid 8.13.x and Teiid 9.0.x in the next two weeks.  There is still no timeline yet for a Teiid Designer release compatible with WildFly 10.

The OpenShift web UI continues to progress, please contact their community is you have any interest in following or contributing to the work.

9.0.x

9.0.3 is due out in approximately 2-3 weeks.

8.13.x

If needed 8.13.7, the last fix release on 8.13, will be available by the general release of 9.1.

As always thanks for all the community support,
Steve

Sunday, July 17, 2016

Teiid 9.0.2 Released

The 9.0.2 fix release is now available.  This addresses 10 issues since 9.0.1:
  • [TEIID-4304] - Correct handling with subquery in on clause
  • [TEIID-4311] - Teiid Admin Api not support to create XA datasource on Jboss server.
  • [TEIID-4321] - VDB Validation is showing warnings, but failing deployment
  • [TEIID-4324] - TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
  • [TEIID-4325] - ASSERTION FAILED: expected reference to be not null
  • [TEIID-4335] - No buffer when close is called
  • [TEIID-4338] - Hana and Vertica should be marked as requiring a source
  • [TEIID-4339] - Hot Rod ExecutionFactory name misspelled
  • [TEIID-4342] - loadMatView afterLoadScript error when calling a function
  • [TEIID-4336] - Errors in logs during server shutdown
A special thanks to Bram Gadeyne for identifying TEIID-4324 and to Mark Tawk for highlighting TEIID-4325 and TEIID-4342.

 Next up will be the 9.1 Alpha2 release by the end of the week.

Friday, July 15, 2016

Teiid 8.13.6 Released

The 8.13.6 fix release is now available.  This addresses 11 important issues:
  • [TEIID-3685] - org.teiid.padSpace does not affect to the "IN" operator
  • [TEIID-3815] - Oracle translator - OFFSET function does not work
  • [TEIID-4244] - Assertion failed error when joining duplicate rows to a table from other source
  • [TEIID-4248] - Build change for 8.13 caused the release notes to miss the version replacement
  • [TEIID-4260] - Accumulo: Resource adapter fails to load
  • [TEIID-4262] - Wrong result (empty or NULL) with an view and a single disjunction for join criteria
  • [TEIID-4280] - NPE in RuleMergeVirtual when running a query with nested CTEs
  • [TEIID-4287] - An exception is thrown by PostgreSQL when nested CTEs are pushed down
  • [TEIID-4290] - Rollback to savepoint should be a no op
  • [TEIID-4320] - Costing calculation issues
  • [TEIID-4324] - TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
This is likely the second to last fix release for 8.13.  Expect an 8.13.7 in about a month and for fix releases to continue on 9.0.x after that.

Steve

Sunday, July 3, 2016

Teiid 9.0.1 Released

The 9.0.1 fix release is now available.  This release addresses 13 issues including several issues related to WITH clause processing that were found by Salvatore R.:
  • [TEIID-3685] - org.teiid.padSpace does not affect to the "IN" operator
  • [TEIID-3771] - Teiid throws an NPE while executing query with nested subquery IN predicate
  • [TEIID-4272] - NPE when CTE and subuquery without a WITH clause are pushed together
  • [TEIID-4273] - With clause used in evaluatable subquery in a fully pushed user query is seen as missing temp table
  • [TEIID-4276] - Default for max sessions not consistently updated
  • [TEIID-4280] - NPE in RuleMergeVirtual when running a query with nested CTEs
  • [TEIID-4283] - External Materialization interleaving loads SYSADMIN.loadMatView
  • [TEIID-4287] - An exception is thrown by PostgreSQL when nested CTEs are pushed down
  • [TEIID-4288] - Cancel method against a socket based jdbc query can wait for synch timeout
  • [TEIID-4290] - Rollback to savepoint should be a no op
  • [TEIID-4304] - Correct handling with subquery in on clause
  • [TEIID-4310] - Sessions can not be shown in web-console runtime sub-panel
  • [TEIID-4312] - INNER and LEFT joins of CTEs fail or return incorrect results
Expect an 8.13.6 release to follow in a couple of days.

Thanks,
Steve Hawkins

Wednesday, June 29, 2016

Teiid 9.1 Alpha1 Released

Teiid 9.1 Alpha1 has been posted.  This is expected to be a typical 3 month feature release cycle with pre-releases about every two weeks.  So far in Alpha1 you'll find:
  • TEIID-4243 BatchUpdateException support in JDBC to indicate what part of batch succeeds when a failure occurs.
  • TEIID-4191 NO QUOTE option for TEXTAGG.
  • TEIID-4200 Moved to WildFly 10 as host environment
WildFly Upgrade

We chose to stick with the Teiid 9.x release series even with the platform update since we not introducing Teiid centric feature changes and this by itself will not be a breaking change for most.  However the WildFly 10 upgrade does mean that JRE 1.8+ is required for both the server and embedded.  Teiid 9.0 will be supported for an extended period to provide a JRE 1.7 compatible platform.  Other know issues:

TEIID-4306: xa datasource create cli not work
TEIID-3834: start/stop of a data source or resource adapter requires a restart (somewhat worse behavior than WildFly 9 from our perspective)

Teiid Designer

A Teiid Designer release should be available shortly that is compatible with WildFly 9 and Teiid 8.13.x with partial support for Teiid 9.0.x.  A Teiid Designer release compatible with WildFly 10 is TDB.  The tooling team has several irons including refinements to the OpenShift web UI and the Komodo project - so anyone with an interest in tooling work should contact their community.

Coming Soon to 9.1

TEIID-3617: Provide an option to Limit per user based connections
TEIID-3754: OData V2 service removal
TEIID-4000: Data Expand support
And much more...

9.0.x

9.0.1 is due out later this week, and as mentioned above we'll keep supporting 9.0.x for an extended period.

8.13.x

8.13.6 is due out next week.  At this point only critical/blocker fixes will make it into 8.13.x.

As always thanks for all the community support,
Steve

Monday, June 13, 2016

Teiid 9.0 Released for WildFly 9.0.2

Teiid 9.0 is now available - http://teiid.jboss.org/downloads/.  While slightly longer than expected, this release addresses a large number of issues - 273 - of which the vast majority are fixes.

Like 8.13.x, Teiid 9.0 is based upon WildFly 9.0.2.  The downloads page contains a consolidated download with WildFly 9.0.2 + Teiid 9.0.0 + Teiid Web-Console 2.7.0.  You may also choose to use Docker image on Docker Hub

It is important to consult the migration guide even if you are already on 8.13 to ensure a smooth transition.  Even though there are relatively few large features, there are some breaking changes - and not all provide backwards compatible options.

The community web site documentation page has been updated to reflect our conversion to GitBook.  We'll be working on converting the quickstarts into this documentation set as well.

Highlights
  • TEIID-3601 Large row counts internal tables and source queries are no longer limited to max integer rows. However update counts, count aggregate values, user result sets, etc. are still limited to max integer.
  • TEIID-3792 Array Quantified Comparisons can be used to search array values - for example expression = SOME (array_expression)
  • TEIID-3462 Semantic VDB Versioning can be used in the VDB name and connection string, rather than the simple integer version. See the Reference for more.
  • TEIID-3849 Cassandra Update Improvements for bulk/batch updates and asynch processing.
  • TEIID-3869 Additional geospatial support for Geoserver integration with Teiid.
  • TEIID-2476 Data role metadata filtering to omit non-accessible objects from system tables.
  • TEIID-4076 Improved autoCommitTxn detect to prevent unnecessary transactions.
  • TEIID-4084 Allowing for with clause inlining to improve performance.
  • TEIID-3725 JDG Cache/DSL Translator added cache swapping feature to support external materialization.
  • TEIID-3810 JDG Cache/DSL Translator upgraded support for JDG 6.6
  • TEIID-3520 Swagger Translator for calling REST services defined by Swagger.
  • TEIID-4202 Lateral join and procedure pushdown support for targeted sources.
9.x Work

You should expect a 9.1 in about 3 months.  It will primarily target updating to WildFly 10.  We will also be continue working on making materialization easier to use with JDG and other external sources.

8.13.x Work

There will likely be an 8.13.6 and 8.13.7 - but with the release of 9.1 we will stop supporting the 8.13 branch.

Thank you to everyone who helped bring issues to light.  If one of your issues does not seem fully addressed, please let us know.

Sunday, June 5, 2016

9.0 CR2 Released

We continue to narrow in on the 9.0 release.  CR2 addresses about two dozen issues since CR1.  Use maven or our downloads page.  The final release should be ready in about one more week.  Please let us know if you find any critical issues in CR2.

The 9.1 release effort has also begun, so if there are any issues that are a high priority for you, please vote or comment on them.

Thanks again for all of the community support,
Steve

Friday, June 3, 2016

8.13.5 Available

Teiid 8.13.5 is now released. 8.13.5 addresses 15 issues since 8.13.4:
  • [TEIID-4104] - FORMATTIMESTAMP function is not correctly pushed down when a column is passed as FORMAT argument
  • [TEIID-4175] - Certain nested dependent join structure will cause fewer results than expected
  • [TEIID-4192] - If a column is blank the TEXTAGG function excludes it from the output
  • [TEIID-4207] - Limit pushdown is incorrect for simpledb
  • [TEIID-4211] - Wrong rewriting of CTEs when pushed down to PostgreSQL
  • [TEIID-4214] - Null pointer exception with trace log
  • [TEIID-4221] - HANA translator: incorrect pushdown of week function
  • [TEIID-4223] - Hana translator: incorrect pushdown of QUARTER function
  • [TEIID-4224] - HANA translator : incorrect pushdown of DAYOFWEEK function
  • [TEIID-4225] - HANA translator : DAYNAME function is not pushed
  • [TEIID-4226] - HANA translator: boolean type converted to tinyint in each convert
  • [TEIID-4235] - dynamic sql recursion check not valid after caught exception
  • [TEIID-4237] - INNER JOIN returns incorrect results
  • [TEIID-3600] - DB2 - error getting substring if "from position" is out of range
  • [TEIID-4241] - Remove dependencies used for embedded examples
Thanks again to those who reported issues including community users Salvatore R and dalex dalex.

Steve

Wednesday, May 25, 2016

Teiid 9.0 CR1 Released

Teiid 9.0 CR1 is now available.  This is a very large release compared to most with 238 issues addressed so far.  A recap of the major features:
  • TEIID-3601 Large row counts internal tables and source queries are no longer limited to max integer rows. However update counts, count aggregate values, user result sets, etc. are still limited to max integer.
  • TEIID-3792 Array Quantified Comparisons can be used to search array values - for example expression = SOME (array_expression)
  • TEIID-3462 Semantic VDB Versioning can be used in the VDB name and connection string, rather than the simple integer version. See the Reference for more.
  • TEIID-3849 Cassandra Update Improvements for bulk/batch updates and asynch processing.
  • TEIID-3869 Additional geospatial support for Geoserver integration with Teiid.
  • TEIID-2476 Data role metadata filtering to omit non-accessible objects from system tables.
  • TEIID-4076 Improved autoCommitTxn detect to prevent unnecessary transactions.
  • TEIID-4084 Allowing for with clause inlining to improve performance.
  • TEIID-3725 JDG Cache/DSL Translator added cache swapping feature to support external materialization.
  • TEIID-3810 JDG Cache/DSL Translator upgraded support for JDG 6.6
  • TEIID-3520 Swagger Translator for calling REST services defined by Swagger.
  • TEIID-4202 Lateral join and procedure pushdown support for targeted sources.
This puts us on pace for a release in the next 2-3 weeks.

Even if you are already on 8.13.x, which uses the same Wildfly platform, you should checkout the migration guide.  The quickstarts have been updated - including several new scenarios.  There is still a lot more places that we want to correct/update that reference things like JBoss AS rather than Wildfly - so let us know if anything seems amiss.

Thanks,
Steve

Tuesday, May 3, 2016

Teiid 9.0 Beta2 Released

Teiid 9.0 Beta2 is now available.  The main feature in Beta2 since Alpha1:
  • TEIID-3725 JDG Cache/DSL Translator added cache swapping feature to support external materialization.
  • TEIID-3810 JDG Cache/DSL Translator upgraded support for JDG 6.6
  • TEIID-3520 Swagger Translator for calling REST services defined by Swagger.
Things will be a little slow this week as the core devs are meeting face to face, but we're making a lot of progress on planning.  Thanks again for all the community issues and posts - a special thanks to Marco Ardito for helping diagnosing ODBC issues and working with other community members.

Steve

Wednesday, April 27, 2016

Teiid 8.13.4 Released

Teiid 8.13.4 is now available. 8.13.4 addresses 13 issues since 8.13.3:
  • [TEIID-4107] - HSQL Syntax error when Teiid sends it a join query with no parenthesis
  • [TEIID-4109] - spatial_ref_sys reference needs qualified
  • [TEIID-4115] - XMLTABLE single element in sequence invalid conversion
  • [TEIID-4118] - Temp capabilities for null ordering not correct if default is changed
  • [TEIID-4120] - Teiid on Oracle Spatial generates incorrect SQL
  • [TEIID-4123] - Issues with odbc metadata
  • [TEIID-4130] - Prevent blocked exceptions from being thrown in AccessNode open
  • [TEIID-4136] - Sybase/SQL Server translator varchar length incorrect
  • [TEIID-4144] - Mismanagement of output columns in ruleimplementjoinstrategy
  • [TEIID-4151] - AssertionError: Delete failed
  • [TEIID-4160] - Impala - result set is not sorted if ORDER BY is defined in query
  • [TEIID-4168] - Odd resolving error with implicit temp groups
  • [TEIID-4169] - Deployment/start sequence issue
Be sure to also follow the 9.0 development as we are starting to narrow in on the release.

Thanks,
Steve

Tuesday, April 26, 2016

Teiid and GSoC

JBoss as an organization is mentoring 10 students - and the Teiid project is pleased to welcome Tuğba DOĞAN who will be working on connectivity to HDFS.

We'd also like to thank the other students who showed interest in Teiid - please try again next year and stay involved in the community if you can.

Steve

Thursday, April 14, 2016

Teiid Designer 10.0 Released

Teiid Designer 10.0 has been released in support of JBDS 9.0 and the Eclipse MARS platform.

Primary drivers for 10.0 include:
  • Compatibility with Teiid 8.12.4 Runtime
  • New Features
    • Simplified Preview Data feature. Allows testing ad-hoc queries against the selected table, view or procedure
    • New action to convert old User-Defined Function models into virtual model UDFs
  •  Bug fixing and enhancements to support dynamic vdb import/export
For details see:
Teiid Designer Project Team

Saturday, April 9, 2016

Teiid 9.0 Beta1 Released

We are ready to move into the Beta phase of 9.0 with the release of Beta1.  Any of the remaining larger features will likely be pushed to Teiid 9.1.  The main feature in Beta1 since Alpha2:
  • TEIID-4084 Allowing for with clause inlining to improve performance.

This should put us on track for a 9.0 release by the end of May.  Also a 8.13.4 release will probably be available by end of month depending upon what issues are found.

A reminder - the new GitBook documentation home for 9.0 and later is at: https://teiid.gitbooks.io/documents/content/

Steve

Tuesday, April 5, 2016

VDB Builder - 0.0.4 Update Available

The Teiid Tooling team has released the next milestone kit for VDB Builder.  The VDB Builder is a command line tool that allows creating, editing and managing dynamic VDBs and other artifacts.  It also allows interaction with a teiid server.

 

What's New?

Please see the announcement on our Teiid Tooling page for a full list of changes since the last milestone.

 

Try It Out

You can start building your VDBs now by downloading the milestone kit from SourceForge!
Contributions and feedback are welcome!

Teiid Tooling Team

Wednesday, March 23, 2016

Teiid 8.13.3 Released

Teiid 8.13.3 is now available.  In total 8.13.3 addresses 10 issues since 8.13.2:
  • [TEIID-4028] - adding salesforce-34 resource adapter does not work through the cli
  • [TEIID-4066] - Odata translator ClassNotFoundException: com.sun.ws.rs.ext.RuntimeDelegateImpl
  • [TEIID-4070] - Issues with resource adapters with api modules in wildfly
  • [TEIID-4089] - Teiid JDBC driver does not reset the update count when calling getMoreResults(int)
  • [TEIID-4093] - OData authentication fails with NPE when gss-pattern related properties are included in VDB
  • [TEIID-4096] - AssertionError with independent side of a dependent join that has an ordered limit
  • [TEIID-3050] - allow for more incremental insert with iterator
  • [TEIID-4075] - Netezza translator to support common table expressions
  • [TEIID-4098] - Always preserve columns order in google spreadsheets models
  • [TEIID-4046] - OData - $skip is beeing ignored
This release also includes an updated web console that addresses several issues.  Cumulatively that is well over 50 issues fixed since the initial 8.13 release.   Ideally we'll be able to slow the pace of 8.13 patch releases from here.

Thanks again for all the community work in identifying issues.  Next up will be 9.0.0 Beta1!

Steve



Thursday, March 17, 2016

Teiid 9.0 Alpha2 Released

We are making progress with 9.0 with the release of Alpha2.  The main features in Alpha2 since Alpha1:
  • TEIID-2476 Data role metadata filtering to omit non-accessible objects from system tables.
  • TEIID-4076 Improved autoCommitTxn detect to prevent unnecessary transactions.
The web console should be in better shape than with the Alpha1 release.  Once again there was also a substantial amount of fixes already picked up from 8.12.x and 8.13.x including a lot of refinements to the OData4 production logic.  So far 125 issues have been addressed - https://issues.jboss.org/projects/TEIID/versions/12315992


Expect 8.13.3 within the next week, which will pickup the web console changes and other fixes since 8.13.2.  Please let us know as soon as possible if you find any issues with 8.13 so that we get the fixes into 8.13.3.

As a reminder the new GitBook documentation home for 9.0 and later is at: https://teiid.gitbooks.io/documents/content/

Steve

Thursday, March 10, 2016

Teiid 8.13.2 Released

Teiid 8.13.2 is now available.  Note TEIID-4017 is an important security fix.  It is recommended that anyone running 8.12.x or 8.13.x upgrade to 8.13.2. 

In total 8.13.2 addresses 27 issues since 8.13.1:
  • [TEIID-3872] - Error with odata entity create with generated keys
  • [TEIID-3975] - 8.13+ Teiid Client should work on JRE 1.6
  • [TEIID-3978] - Remove AddressWrapper
  • [TEIID-3979] - Teiid generates queries containing VARCHAR without a size, causing an HSQL syntax error
  • [TEIID-3980] - NPE with Salesforce retrieve query and no matching entity
  • [TEIID-3981] - Salesforce-34 connector dependency on "com.force.api" is wrong
  • [TEIID-3983] - External Materialization MATVIEW_ONERROR_ACTION WAIT problem
  • [TEIID-3989] - PartialResultsWarning not being returned
  • [TEIID-3990] - Issues with nested correlated references
  • [TEIID-3993] - Teiid: indexOutOfBoundsException on union + count distinct query
  • [TEIID-3994] - AliasSymbol wrapping AliasSymbol error
  • [TEIID-3995] - SAP HANA materialization:function loadMatView with argument invalidate set to true problem
  • [TEIID-4003] - Vertica and DB2 translators use incorrect push down of WEEK function
  • [TEIID-4006] - Texttable column header option toString incorrect
  • [TEIID-4007] - Unparseable model name if user changes odata4 context root
  • [TEIID-4008] - Sending teiid varbinary value (x'') to Microsoft SQL Server errors
  • [TEIID-4011] - automatic/autonomous refresh of materialized views does not work
  • [TEIID-4015] - Error or incorrect value when there is a conflict between local and correlated names
  • [TEIID-4017] - EXECUTE IMMEDIATE in anonymous procedure ignores permissions
  • [TEIID-4022] - Materialization issue dynamic SQL command can't be executed due ambiguous group name
  • [TEIID-4023] - Exception with unresolved Array expression hashcode
  • [TEIID-4031] - Missing dependency in module com.fasterxml.jackson.dataformat.yaml
  • [TEIID-4034] - Google spreadsheet translator issues
  • [TEIID-3599] - Excel translator and dynamic filenames
  • [TEIID-3986] - Materialization planning should be sensitive to property changes
  • [TEIID-3987] - SYSADMIN.setProperty should resolve property keys
  • [TEIID-4052] - Dynamic SQL exception should include evaluated sql
Thanks for all of the community efforts in identifying these issues.  There are still several web console issues that will addressed in 8.13.3, which should be available in 2-3 weeks.

Another 9.0 Alpha will be available in a couple of days that includes all of these fixes and more.  Ideally we'll be moving on to Beta releases by the end of March.

Thanks,

Steve

Thursday, February 18, 2016

Teiid 9.0 Alpha1 Released

With the successful creation of the 8.13 transitional release, we are now ready to start the release stream for 9.0 with Alpha1. Please consult the migration documentation from 8.x to 9, and let us know if there is more content that needs added.

The main features in Alpha1 beyond targeting WildFly 9.0.2 are:
  • TEIID-3601 Large row counts internal tables and source queries are no longer limited to max integer rows. However update counts, count aggregate values, user result sets, etc. are still limited to max integer.
  • TEIID-3792 Array Quantified Comparisons can be used to search array values - for example expression = SOME (array_expression)
  • TEIID-3462 Semantic VDB Versioning can be used in the VDB name and connection string, rather than the simple integer version. See the Reference for more.
  • TEIID-3849 Cassandra Update Improvements for bulk/batch updates and asynch processing.
  • TEIID-3869 Additional geospatial support for Geoserver integration with Teiid.
There was also a substantial amount of fixes already picked up from 8.12.x and 8.13.x including a major overhaul of the Accumulo translator.

The new GitBook documentation home for 9.0 and later is at: https://teiid.gitbooks.io/documents/content/

Since we are just through the initial conversion from confluence, please let us know if you see something that needs fixed.

Stay tuned - there will be much more coming with subsequent pre-releases.

Steve


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: https://teiid.gitbooks.io/documents/content/

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

Steve

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 http://teiid.jboss.org/downloads/


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,
Steve

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.

Steve

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 http://teiid.jboss.org/downloads/
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.

Ramesh..