Skip to main content

7.1 Pre-release

By
7.1 Alpha1 is now available. Even though 7.0 was just released, we have been working hard to pack more features and fixes into 7.1. What is already available:

  • SQL Support
    • Added NULLS FIST/LAST handling - including pushdown support.
    • Added enhanced numeric stat aggregate functions STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP, with pushdown and aggregate decomposition.
    • Added support for the boolean aggregate functions ANY, SOME, EVERY.
    • Added support for using boolean value expression as both criteria and expressions, e.g. "... where boolean_value" or "select x = 1 as boolean_value ...".
    • Changed named procedure syntax to accept param=>value, rather than param=value.
  • Parallel Source Queries - reestablished parallel execution of source queries within a query plan along with a prioritized work system to help prevent resource contention.
  • SHOW Statement - added client handling for the SHOW statement to retrieve query plan information and see execution property values.

    • ODBC access and many caching improvements will be coming shortly.

    The Teiid Team

    Comments

    Post a Comment

    Popular posts from this blog

    Access Teiid from node.js

    By
    Are you writing a "node.js" application and would like to access Teiid VDB from it? If "yes", this is currently possible using NPM package "pg" .  Since, Teiid supports the PG transport, you can use this PostgreSQL client for "node.js" for accessing the Teiid. For example if you have VDB called "northwind" deployed on your Teiid server, and it has table called "customers" and you are using default configuration such as user = 'user' password = 'user' host = 127.0.0.1 port = 35432 then you can use following to write simple access program to Teiid var pg = require('pg'); var connectionString = "pg://user:user@localhost:35432/northwind" pg.connect(connectionString, function(err, client) { client.query('SELECT CustomerID, ContactName, ContactTitle FROM Customers', function(err, result) { console.log(result.rows) }); }); If you want ...
    11 comments
    Read more

    Teiid 8.13.2 Released

    By
    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 + ...
    3 comments
    Read more

    Teiid 8.13.3 Released

    By
    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 bee...
    10 comments
    Read more