Thursday, October 29, 2015

Teiid 8.12.1 Released

Teiid 8.12.1 is now available.  It contains all of the 8.11.5 fixes plus a number of odata and hbase fixes.  All fixes since 8.12 include:
  • [TEIID-3757] - OData V2: $top doesn't work with virtual procedures
  • [TEIID-3760] - endswith defined with wrong return type
  • [TEIID-3761] - OData V2: The property based response and Function based responses are incorrect per specification
  • [TEIID-3762] - OData V2: $value on property is not supported
  • [TEIID-3764] - HBase - Phoenix driver does not support UNION
  • [TEIID-3765] - HBase - Phoenix does not support scalar subquery
  • [TEIID-3767] - HBase - Phoenix does not support LIKE ESCAPE
  • [TEIID-3770] - HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate
  • [TEIID-3771] - Teiid throws an NPE while executing query with nested subquery IN predicate
  • [TEIID-3776] - Teiid throws NPE if query contains AVG function on varchar type
  • [TEIID-3777] - ORDER BY DESC is ignored in STRING_AGG function when DISTINCT is also specified
  • [TEIID-3783] - Error when limit/sort is pushed above a window function
  • [TEIID-3785] - PostgreSQL - Large Objects may not be used in auto-commit mode.
  • [TEIID-3759] - Missing Apache Olingo dependency in Teiid 8.12.0.Final
  • [TEIID-3780] - Hive: Convert "UseDatabaseMetaData: to be an translator import property
  • [TEIID-3781] - Queries are not killed even if the client sends a cancel request
Additionally we are working targeted enhancements in 8.12.x.  For 8.12.1 this includes:
  • [TEIID-3039] - OData V2: Add support for odata expand
  • [TEIID-3361] - Initial addition of source query details to the command log
  • [TEIID-3436] - OData V2: Add array type support to the odata translator
  • [TEIID-3778] - Mark hbase/phoenix as supporting limit
  • [TEIID-3791] - Upgrade groovy-all to be version 2.4.
We'll look to put out an 8.12.2 in a couple of weeks as more issues are worked/found.

Work has started on the Wildfly 9 support in Teiid 8.13.  If all goes well, then an 8.13 Alpha1 will be available in the next two weeks.

Thanks,
The Teiid Team


Thursday, October 22, 2015

Teiid 8.11.5 Released

Teiid 8.11 development has concluded with the release of 8.11.5, which is available from maven and the downloads page.  Important issues addressed in this release include:
  • [TEIID-3564] - float field gets converted to scientific notation when query is submitted to source
  • [TEIID-3707] - Wrong Data returned when a procedure is executed in the SELECT clause
  • [TEIID-3720] - DDLString Visitor not writing the OPTIONS value for Procedure parameters
  • [TEIID-3726] - CTEs combined with constant values yield an error message
  • [TEIID-3739] - Dynamic VDB that imports another VDB does not get redeployed if the imported VDB is redeployed
  • [TEIID-3756] - Order By clause specified in STRING_AGG function is skipped when pushed down to PostgreSQL
  • [TEIID-3777] - ORDER BY DESC is ignored in STRING_AGG function when DISTINCT is also specified
  • [TEIID-3705] - Build issue in security

From here we will start providing 8.12.x releases - starting with 8.12.1 in about a week.  If all goes well in approximately 2 weeks we'll provide an 8.13 Alpha with the initial Wildfly integration.

Thanks,
Steve

Thursday, October 15, 2015

Teiid 8.12 Final Released, Swagger support added

Keeping up the tradition of time boxed releases, the Teiid team is proud to announce 8.12.0 Final. We have resolved 147 issues (features, enhancements, bugs) in this release. You can downloads at http://teiid.jboss.org/downloads/

JBoss EAP & Teiid:
8.12/8.11 are based on the JBoss EAP 6.4.Alpha platform. The downloads page contains a consolidated single download file that contains  EAP 6.4 Alpha + Teiid 8.12.0 + Teiid Web-Console.  You also have choice of using Docker image if you choose to at Docker Hub.

Please note this is the LAST VERSION of Teiid that will be based on JBoss EAP.  8.13 and 9.0, we will be moving to WildFly. Any micro releases on 8.12 line like 8.12.1, 8.12.2 etc still be using JBoss EAP.

Highlights of 8.12
  • TEIID-3411 LDAP modeling can now better account for associations defined by multivalued attributes.
  • TEIID-3323 Vertica translator added.
  • TEIID-3515 TEIID-3530 Dependent join enhancements in hints and pushdown planning.
  • TEIID-2883 Actian Vector in Hadoop Translator added
  • TEIID-3595 TEIID-3594 Logging Enhancements for command and audit logging
  • TEIID-3546 IS DISTINCT FROM syntax support added for use in procedures.
  • TEIID-3521 Swagger Support for auto-generated REST web services
  • TEIID-3652 Additional OUTER JOIN planning to allow more flexibility in join ordering
  • TEIID-3668/TEIID-3618 OAuth Support with JWT Bearer Access Token and Salesforce SSO using OAuth2 (RefreshToken, JWT)
  • TEIID-3712 Date/Time Keyword Literal support was added in the parser.
  • TEIID-3722 Option to not widen comparisons to string was added via the system property org.teiid.widenComparisonToString
  • TEIID-3327 OSIsoft PI translator added for use with the PI JDBC driver.
  • TEIID-3727 Salesforce Translator added a translator and resource-adapter based on Salesforce Partner API 34
  • TEIID-3370 OData4 Translator added new translator to read/write from any compliant OData V4 source
Community Folks:
Once again we had great interactions with community in developing this release. We sincerely extend our appreciation to Albert Wong, Avinash Misra, Bram Gadeyne, Burak Serdar, Dalex, Don Krapohl, Gary Gregory, Guru Prasad, Jorge Herrera, John Muller, Mark Addleman, Mark Tawk, Michael Davies, Michal Sanitrak, Mike Higgins, Pranav K, Prashanthi Kairuppala, Salvatore R, Sathish Kumaran Vairavelu, Scott Wallace, and Tom Arnold.

What's Coming Next:

Lot's of Stuff :)

We are working on 8.13 version that is just going to be similar to 8.12 version in terms of features, but we will replace JBoss EAP 6.4 Alpha with WildFly 9 or 10. If community feels WildFly 10 is better please speak up.  We'll probably move to WildFly 10 during the Teiid 9.0 development regardless.

Also expect an 8.11.5 shortly as the last of the 8.11.x series.

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.

Friday, October 2, 2015

Teiid 8.12 CR1

After a small delay, we are pleased to release Teiid 8.12 CR1.  We were able to get quite a few issues resolved - to date there are 134 issues resolved.  As usual CR1 can be found in maven and on the downloads page.

Feature highlights since Beta3 include:
  • TEIID-3712 Date/Time Keyword Literal support was added in the parser.
  • TEIID-3722 Option to not widen comparisons to string was added via the system property org.teiid.widenComparisonToString
  • TEIID-3327 OSIsoft PI translator added for use with the PI JDBC driver.
  • TEIID-3727 Salesforce Translator added a translator and resource-adapter based on Salesforce Partner API 34

Expect a final release in approximately 2 weeks, followed shortly by an 8.11.5 release.  Please let us know if you find any issues as we will address anything critical prior to the final release.

Thanks again for all the community support,
Steve