teiid Changelog

What's new in teiid 8.10.0 Final

Mar 3, 2015

Highlights:
TEIID-2694 REST Service - Generated REST web services now support larger binary payloads.
Compatibility Issues:
TEIID-2694 In the autogenerated web service, if a procedure is designed for POST method, and one of its IN/INOUT parameters is either a LOB or VARBINARY then that service can only invoked using "multipart/form-data". This allows user to send large binary files for processing in Teiid

New in teiid 8.10.0 CR 2 (Feb 19, 2015)

Highlights:
TEIID-3192 Salesforce Connectivity - connectivity was converted to the partner api provided by Salesforce rather than utilizing CXF. Please log an issue if you were utilizing features from the CXF config.
TEIID-3046 Recursive Common Table Expression - engine and push down support was added.
TEIID-3163 TEIID-3167 Text Table Enhancements - to support a general no trim option and to use a different row delimiter.
TEIID-991 SybaseIQ Translator - for use with SybaseIQ 15.1 and later.
TEIID-2882 PrestoDB Translator - for use with PrestoDB 0.85 and later.
TEIID-1091 Additional SQL/XML Support - XMLEXISTS, XMLTEXT, and XMLCAST were added.
TEIID-3216 Update Support for Google Spreadsheets
TEIID-2384 Geospatial Support - contributed by Tom Arnold. Adds a geometry type and several functions. See the reference for more.
TEIID-2816 Hbase Support - based upon the Phoenix JDBC Drirver.
TEIID-3043 Docker Image - can now be produced by the build.
Compatibility Issues:
Support for named parameter syntax using param=value has been deprecated, since it is ambiguous with a comparison predicate boolean value expression. param=>value should be used instead.
decodeinteger/decodestring have been deprecated. A CASE expression should be used instead.
TEIID-2267 The custom appenders for command and audit logging has been changed, now they need to be developed for java.util.logging based Handler.
TEIID-1979 The resource adaptors are now deployed through modules, and have shorter names as identifiers. Connection Factories created with previous versions must be re-configured.
TEIID-2326 By default imported vdb internal materialized views will shared with the importing vdb.
TEIID-2344 non-available JDBC sources in partial results mode or source with connection factories that require an ExecutionContext to obtain a connection will require manual setting of the database version metadata property. The affected sources are: db2, derby, oracle, postgresql, sqlserver, sybase, teiid
TEIID-2477 Most of the JDBC translator static String version constants were replaced by org.teiid.translator.jdbc.Version constants. Use the .toString() method to obtain a version string if needed.
TEIID-2527 The admin method assignToModel has been deprecated. See the updateSource, addSource, and removeSource methods instead.
TEIID-2904 The createMetadataProcessor method on JDBCExcutionFactory has been deprecated. Use getMetadataProcessor instead.
TEIID-3159 The SAP Netweaver Gateway translator (sap-nw-gateway) has been renamed to just SAP Gateway (sap-gateway). Usage of sap-nw-gateway is deprecated.

New in teiid 8.9.0 CR 1 (Oct 17, 2014)

Highlights:
TEIID-3009 WITH project minimization - common table expressions will have their project columns minimized.
TEIID-3038 geoSpatial support for MongoDB translator
TEIID-3050 Increased Insert Performance with sources that support batching or insert with iterator.
TEIID-3044 Function Metadata is available through system tables and DatabaseMetaData.
TEIID-1910 TeiidPlatform for EclipseLink integration is now provided via the teiid-eclipselink-platform jar in maven.
TEIID-3119 Performance improvements in grouping and duplicate removal as well as general improvements to memory management.
TEIID-3156 Collation aware prevention of order by pushdown via the collationLocale translator property and the org.teiid.requireTeiidCollation system property.
Compatibility Issues:
Support for named parameter syntax using param=value has been deprecated, since it is ambiguous with a comparison predicate boolean value expression. param=>value should be used instead.
decodeinteger/decodestring have been deprecated. A CASE expression should be used instead.
TEIID-2267 The custom appenders for command and audit logging has been changed, now they need to be developed for java.util.logging based Handler.
TEIID-1979 The resource adaptors are now deployed through modules, and have shorter names as identifiers. Connection Factories created with previous versions must be re-configured.
TEIID-2326 By default imported vdb internal materialized views will shared with the importing vdb.
TEIID-2344 non-available JDBC sources in partial results mode or source with connection factories that require an ExecutionContext to obtain a connection will require manual setting of the database version metadata property. The affected sources are: db2, derby, oracle, postgresql, sqlserver, sybase, teiid
TEIID-2477 Most of the JDBC translator static String version constants were replaced by org.teiid.translator.jdbc.Version constants. Use the .toString() method to obtain a version string if needed.
TEIID-2527 The admin method assignToModel has been deprecated. See the updateSource, addSource, and removeSource methods instead.
TEIID-2904 The createMetadataProcessor method on JDBCExcutionFactory has been deprecated. Use getMetadataProcessor instead.
TEIID-3159 The SAP Netweaver Gateway translator (sap-nw-gateway) has been renamed to just SAP Gateway (sap-gateway). Usage of sap-nw-gateway is deprecated.

New in teiid 8.9.0 Beta 2 (Sep 24, 2014)

New in teiid 8.9.0 Beta 1 (Sep 9, 2014)

New in teiid 8.9.0 Alpha 2 (Aug 23, 2014)

New in teiid 8.8.1 (Aug 14, 2014)

New in teiid 8.9.0 Alpha 1 (Aug 7, 2014)

New in teiid 8.8.0 Alpha 1 (May 15, 2014)

Bug:
Teiid JDBC-ODBC bridge metada import fails from MS Access 2013
BigInteger and BigDecimal datatypes are converted into string in MongoDB translator
Extra unique constraint in dynamic vdb schema
SCROLL keyword for DECLARE CURSOR not being parsed correctly
Datastax: fail to access PortfolioDemo (demo schema that provided by Datastax)
OData skipToken not properly honored
OData inline count is not correct when used with skip/top
Issues with applying row based security
SQL naming issue with several layers of inline views
Enhanced sort join produces duplicate results
getIndexInfo is not correct
disableLocalTxn only works at connection time
NPE with a join and a dup_remove child
DB2: doesn't work with composite key
Teiid selects incorrect source when conformed table is included in SQL JOIN
NullPointerException using webservice translator against a webservice that's missing 'Content-Type' in the response header
Revert Salesforce DDL Option keys
Class cast exception with source batched update command
Enhancement:
makedep makenotdep hints should allow for more complicated scenarios
common table (with) push down improvements
add another log context VDBLifeCycleListener
Allow dependent join pushdown to be chosen by the planner
More incremental join when a limit is present
Cassandra: update to cassandra driver to version 2.X
Provide ability define "execution properties" as VDB properties
Perform equi-join full outer joins in a streaming manner
OData improvements
Change Apache POI version to 3.10
getIndexInfo should return statistical information
Do not schema-qualify the DDL constraint references if they are within the current schema
rate limit the creation of scrollable results
Feature Request"
Add an impala translator
Use Oauth SAML Grant Type
Use Oauth SAML Bearer Assertion Flow
Add support for Presto DB
Support ParAccel as a data source
Support for Amazon Elastic MapReduce
Allow the projection raising (or order pushing) logic to work with non-simple ordering expressions
Combining multiple 'in' criteria can prevent pushing criteria to database
Provide ability to write command and audit logging to database
Crypto exception with client/server running on different java versions
Quality Risk:
Allow for backwards compatibility with multiple security domains per transport
support older designer metadata for ws translator invoke
Sub-task:
HIVE2: Teiid didn't translate the SQL correctly for numeric field

New in teiid 8.7.0 (Apr 17, 2014)

New in teiid 8.7.0 CR 1 (Apr 5, 2014)

New in teiid 8.7.0 Beta 2 (Mar 14, 2014)

New in teiid 8.4.0 (Jun 26, 2013)

New in teiid 8.0.0 (May 3, 2012)

DDL Based View Definitions - Define virtual tables, procedures and functions for Dynamic VDBs using DDL.
MetadataRepository - Pluggable metadata facility for any VDB and models inside it.
CallableStatement Named Parameters - you can now use CallableStatement named parameter get/set methods.
New Translator capabilities
translators may indicate which convert functions they support
restrict non-join comparisons to only literals.
return ReusableExecution instances for processing nodes that issue multiple queries.
translators may indicate support for dependent join handling
Continuous Asynch Queries to process plans in a streamed window fashion the TeiidStatement/TeiidPreparedStatement methods now take a RequestOptions object to specify continuous mode. See the Client and Developers Guides for more.
Texttable selectors - can be used to selectively parse only record lines matching a given selector string. Selectors may also be used for column values to join data from other records positionally.
Enhanced Comparison Support - see the Admin Guide more.
Comparable LOBs - the system property org.teiid.comparableLobs can be set to use CLOB and BLOB values in comparison/sorting/grouping operations.
Padded Comparison - the system property org.teiid.padSpace can be set to effectively right pad strings to the same length for comparison.
Collation Support - the system property org.teiid.collationLocale can be set to use a different collation than the Java UTF-16 default.
VARBINARY type support - the Teiid VARBINARY type can now be used to support source BINARY and VARBINARY types.
Greenplum Translator - for use with the Greenplum database.
Enhanced parse/format pushdown - added more built-in support and extension points for parse/format function pushdown. Added parse/format timestamp handling for SQLServer, Sybase, Oracle, and PostgreSQL.
User Defined Aggregates - user defined aggregate functions can be defined via extension metadata, DDL, or connector metadata.
SET PAYLOAD statement - SET PAYLOAD can be used to set a name value pair on a session scoped payload that will be sent with requests.
ENCRYPT REQUESTS - encryptRequests may be used as a connection/datasource property when not using SSL to indicate that request messages and any associated payload should be encrypted.

New in teiid 7.6.0 CR 1 (Nov 17, 2011)

Procedure language features - Added support for compound/block statements, BEGIN [[NOT] ATOMIC], loop/block labels, and the leave statement. See the reference for more.
File Enhancements - the file translator can now optionally (via the ExceptionIfFileNotFound property) throw an exception if the path refers to a file that doesn't exist. The file resource adapter can be configured to map file names and can prevent parent path .. references. See the Admin Guide or the file-ds.xml template for more.
TEXTTABLE Enhancements - TEXTTABLE can now parse fixed width files that do not use a row delimiter and can optionally produce fixed values that haven't been trimmed.
Temp table transactions - Internal materialized views and temp table usage from a session and within procedures can take advantage of greater transaction support.
Buffering Improvements - Added the ability to inline memory based or small lobs and added tracking of the memory held by soft references. Also switched to a concurrent LFRU algorithm that significantly reduces writes and read misses with temporary tables. Added a memory buffer to better handle file storage. The memory buffer may be optional be configured as off-heap for better large memory performance - see the Admin Guide for more. Overhead is now tracked to help prevent memory errors when dealing with 10s of millions or more of batches/pages. Serialization and disk utilization were also improved.
GSSAPI - both the Teiid JDBC client/server and the ODBC pg backend can now support GSSAPI for single sign-on.
Server-side Query Timeouts - default query timeouts can be configured at both the VDB (via the query-timeout VDB property) and entire server (via the teiid-jboss-beans.xml queryTimeout property).
Native Queries - added the ability to specify native query SQL for JDBC physical tables and stored procedures via extension metadata.
View removal hint - the NO_UNNEST hint now also applies to from clause views and subqueries. It will instruct the planner to not perform view flattening.
Non-blocking statement execution - Teiid JDBC extensions TeiidStatement and TeiidPreparedStatement can be used to submit queries against embedded connections with a callback to process results in a non-blocking manner.
NON_STRICT limit hint - the NON_STRICT hint can be used with unordered limits to tell the optimizer to not inhibit push operations even if the results will not be consistent with the logical application of the limit.
Source Hints - user and transformation queries can specify a meta source hint, e.g. SELECT /*+ sh my-oracle:'leading' */ * FROM TBL. The hint information will be passed to the passed to the translator. The Oracle translator will by default treat the source hint as an Oracle hint.
Hive Translator - Hive translator has been added as technology preview.

New in teiid 7.6.0 Beta 2 (Nov 14, 2011)

Procedure language features - Added support for compound/block statements, BEGIN [[NOT] ATOMIC], loop/block labels, and the leave statement. See the reference for more.
File Enhancements - the file translator can now optionally (via the ExceptionIfFileNotFound property) throw an exception if the path refers to a file that doesn't exist. The file resource adapter can be configured to map file names and can prevent parent path .. references. See the Admin Guide or the file-ds.xml template for more.
TEXTTABLE Enhancements - TEXTTABLE can now parse fixed width files that do not use a row delimiter and can optionally produce fixed values that haven't been trimmed.
Temp table transactions - Internal materialized views and temp table usage from a session and within procedures can take advantage of greater transaction support.
Buffering Improvements - Added the ability to inline memory based or small lobs and added tracking of the memory held by soft references. Also switched to a concurrent LFRU algorithm that significantly reduces writes and read misses with temporary tables. Added a memory buffer to better handle file storage. The memory buffer may be optional be configured as off-heap for better large memory performance - see the Admin Guide for more. Overhead is now tracked to help prevent memory errors when dealing with 10s of millions or more of batches/pages. Serialization and disk utilization were also improved.
GSSAPI - both the Teiid JDBC client/server and the ODBC pg backend can now support GSSAPI for single sign-on.
Server-side Query Timeouts - default query timeouts can be configured at both the VDB (via the query-timeout VDB property) and entire server (via the teiid-jboss-beans.xml queryTimeout property).
Native Queries - added the ability to specify native query SQL for JDBC physical tables and stored procedures via extension metadata.
View removal hint - the NO_UNNEST hint now also applies to from clause views and subqueries. It will instruct the planner to not perform view flattening.
Non-blocking statement execution - Teiid JDBC extensions TeiidStatement and TeiidPreparedStatement can be used to submit queries against embedded connections with a callback to process results in a non-blocking manner.
NON_STRICT limit hint - the NON_STRICT hint can be used with unordered limits to tell the optimizer to not inhibit push operations even if the results will not be consistent with the logical application of the limit.
Source Hints - user and transformation queries can specify a meta source hint, e.g. SELECT /*+ sh my-oracle:'leading' */ * FROM TBL. The hint information will be passed to the passed to the translator. The Oracle translator will by default treat the source hint as an Oracle hint.

New in teiid 7.4.0 (May 13, 2011)

Virtual procedure out params - virtual procedures can now have RETURN/OUT/INOUT parameters to return values.
OLAP - OLAP translator is now part of Teiid kit using OLAP4J
Multi-source procedures - multi-source handling was expanded to cover stored procedure execution. See the Reference for more.
Function Support - additional system functions were made available.
uuid was added to generate type 4 UUIDs and the Hibernate dialect was updated to support the GUIDGenerator.
array_get was added to extract values from java.sql.Array or java array values.
array_length was added to get the length of java.sql.Array or java array values.
ARRAYTABLE - the ARRAYTABLE table function was added to simplify array value extraction into a tabular format.
Ingres - Ingres database translator is now available to use as supported source under Teiid.
Optional Join Enhancements - the optional join hint no longer requires the use of ANSI joins and can will not remove optional bridging tables that are used by two other tables that are required.
InterSystems Cache - InterSystems Cache database translator is now available to use as supported source under Teiid.
userRequestSourceConcurrency - was added to control the number of concurrent source queries allowed for each user request.
Memory Management Improvements - maxReserveBatchColumns and maxProcessingBatchesColumns will be default be determined automatically and will more reliably prevent memory issues. See the admin guide for more.
Subquery optimization control - added the MJ and NO_UNNEST hints and the org.teiid.subqueryUnnestDefault system property to control the optimization of subqueries to traditional joins or to a merge join implementation of a semijoin or antijoin.
Local connection threads - local connection calling threads will be used to process work rather than using an engine thread. This helps decouple the configuration of maxThreads.
Dependent Join Improvements - several major improvements were made to increase performance and develop better plans.
Improved Planning - the decision to create a dependent join is now considered earlier in planning and is much more effective for dependent joins involving multiple unrelated independent tables.
IN predicate splitting - the planner can now split large dependent IN predicates into multiple IN predicates, which is controlled by the translator property MaxDepdendentInPredicates. This allows for much larger dependent joins to be performed as a single query.
Dependent query parallelization - when multiple dependent queries are still required, then they will be run in parallel (up to MaxUserSourceRequestConcurrency), rather than sequentially.
Cost based back-off - for cost based dependent joins if the number of independent values is too large, then the join will be performed as normal.
Enhanced Sort Join - the partitioned merge join was replaced with an enhanced sort join. The enhanced sort join will use the actual row counts from each side of the relation to perform a index based join if one side is small enough, a partial sort of the larger side and a repeated merge join if the tuples are unbalanced but one side is not small enough to form an index, or a standard sort merge join if the tuples are balanced.
JDK1.5 JDBC Client JAR - A retro-translated Teiid client JDBC jar now available to use with JDK 1.5 VM. Note only the JDBC API is supported, not the Admin API, or retrieving query plans as XML.
Security Improvements - UDF and pushdown functions can now be protected with data roles. Also the CommandContext can provide the Subject for custom security checks in UDFs.
Cache Invalidation - Prepared plan and result set caches can have a maxStaleness value, which will invalidate entries based upon metadata and data changes respectively. See the Admin Guide for more.
Runtime-updates of Metadata - Alter statements have been added to change view/procedure/INSTEAD OF trigger (update procedure) definitions have been added. A create statement was also added to add INSTEAD OF trigger (update procedures) to views. System procedures were added to set extension metadata and stat values. By default all effects of metadata updates happen only on running vdbs across the cluster. To make the changes persistent see the Developers Guide Runtime Updates section.

teiid Changelog

What's new in teiid 8.10.0 Final

New in teiid 8.10.0 CR 2 (Feb 19, 2015)

New in teiid 8.9.0 CR 1 (Oct 17, 2014)

New in teiid 8.9.0 Beta 2 (Sep 24, 2014)

New in teiid 8.9.0 Beta 1 (Sep 9, 2014)

New in teiid 8.9.0 Alpha 2 (Aug 23, 2014)

New in teiid 8.8.1 (Aug 14, 2014)

New in teiid 8.9.0 Alpha 1 (Aug 7, 2014)

New in teiid 8.8.0 Alpha 1 (May 15, 2014)

New in teiid 8.7.0 (Apr 17, 2014)

New in teiid 8.7.0 CR 1 (Apr 5, 2014)

New in teiid 8.7.0 Beta 2 (Mar 14, 2014)

New in teiid 8.4.0 (Jun 26, 2013)

New in teiid 8.0.0 (May 3, 2012)

New in teiid 7.6.0 CR 1 (Nov 17, 2011)

New in teiid 7.6.0 Beta 2 (Nov 14, 2011)

New in teiid 7.4.0 (May 13, 2011)

New in teiid 7.3.0 Alpha 2 (Dec 27, 2010)

New in teiid 7.3.0 Alpha 1 (Dec 15, 2010)

New in teiid 7.2.0 CR 1 (Oct 30, 2010)

New in teiid 7.2.0 Beta 1 (Oct 20, 2010)