Release Notes - Teiid - Version 10.0 - HTML format

Quality Risk

  • [TEIID-3347] - Most subplans do not show node stats
  • [TEIID-4051] - Swagger metadata includes internal java constructs
  • [TEIID-4178] - OData and Rest wars use different conventions
  • [TEIID-4375] - Allow bind values to be used for limit/offset in pushdown queries
  • [TEIID-4978] - Document issue with SQLAlchemy/Superset and table names containing .
  • [TEIID-4999] - Archetypes should not use Teiid packages
  • [TEIID-5003] - Deprecate BatchedCommand, use BulkCommand instead

Enhancement

  • [TEIID-2052] - Add Problem/Resolution to query problem using the query plan
  • [TEIID-2703] - Refactor value retrieval to class based
  • [TEIID-2869] - Support consuming REST based service that is secured by SAML
  • [TEIID-3280] - Embedded Teiid | VDB scoped translators
  • [TEIID-3298] - invokeHttp procedure should support returning HTTP Response Code
  • [TEIID-3537] - Use array binding for postgresql dependent join
  • [TEIID-3560] - support common table expression with insert/update/delete
  • [TEIID-3660] - Add support for unnesting anti semijoins
  • [TEIID-3683] - Enhance the formula for caculating core size
  • [TEIID-3738] - Add multi-tenant functionality
  • [TEIID-4099] - Improve with clause performance with incremental materialization
  • [TEIID-4452] - Pushdown SQL/XML
  • [TEIID-4498] - Generalize subquery batch processing
  • [TEIID-4572] - Grouping by and faceted search for Solr tranlator
  • [TEIID-4577] - Upgrade CXF to 3.1.8, which resolves password obfuscation issue
  • [TEIID-4591] - support UPDATE SQL JOIN / FROM
  • [TEIID-4624] - Integrate with Debezium for Result set cache invalidation
  • [TEIID-4625] - Consider consolidating/managing materialization status tables
  • [TEIID-4691] - Consider replacing JGroups based custom replication with native
  • [TEIID-4750] - Map to BigInteger in more circumstances
  • [TEIID-4790] - Support solr authentication
  • [TEIID-4798] - Support Full CRUD operations with SFDC Bulk API
  • [TEIID-4904] - Add support for identify security to the infinispan connector
  • [TEIID-4918] - Enhance infinispan support for muti-threaded puts or using putAll
  • [TEIID-4941] - [RFE] Display a more informative error message when a query takes too long and times out
  • [TEIID-4943] - Allow translators to declare if copied criteria should be included
  • [TEIID-4946] - Support function SUBSTRING_INDEX in MySQL5ExecutionFactory
  • [TEIID-4956] - Support AuotFailOver on Embedded based connections
  • [TEIID-4963] - JDBC LocalProfile should not bind with jboss-modules
  • [TEIID-4992] - Add OSDQ set functions
  • [TEIID-4993] - for each row trigger forcing txn to start
  • [TEIID-4994] - For materialization, use "Ignore return values" option to improve performance
  • [TEIID-4995] - Investigate use of org.apache.poi.ss.usermodel.DataFormatter in Excel translator
  • [TEIID-5000] - Allow for importing excel timestamp columns

Feature Request

  • [TEIID-147] - Support for JAVA Stored Procedures
  • [TEIID-219] - Add a way to limit or suppress queries that exceed a threshold Cost-Based Optimizer value
  • [TEIID-245] - Update costing metadata at runtime
  • [TEIID-1096] - Allow cost analysis tool to work against custom connectors
  • [TEIID-1131] - Document/expand sequence support
  • [TEIID-2542] - Utilize Teiid internal resultset buffering as a materialization mechanism to Infinspan
  • [TEIID-2578] - add/remove schema elements
  • [TEIID-2819] - Use Oauth SAML Bearer Assertion Flow
  • [TEIID-2894] - Add support for the row lock query(SELECT FOR UPDATE) to the source database
  • [TEIID-3157] - Allow streaming without an intermediate copy
  • [TEIID-3439] - Add support for aliases with .
  • [TEIID-3454] - Dependent Join optimizations for Netezza and Hive
  • [TEIID-3494] - TABLE() can execute in parallel
  • [TEIID-3522] - Provide Data Aggregation Extension to OData V4
  • [TEIID-3868] - Add a json type with search support
  • [TEIID-4012] - Implement XA transaction support for Teiid ODBC
  • [TEIID-4250] - Add translator to support Google Cloud Bigtable
  • [TEIID-4356] - Add asort of connection test for "connection definitions" of resource adapters
  • [TEIID-4438] - Crate ability to filter include/exclude tables during the import across all translators
  • [TEIID-4464] - Support Salesforce Bulk API for updates and deletes
  • [TEIID-4525] - postgresql translator - remove all nulls & non printable characters
  • [TEIID-4526] - Integrate with Debezium for CDC for maintaining materialized views
  • [TEIID-4558] - Query Plan Analyzer
  • [TEIID-4565] - Add objects table to system schema
  • [TEIID-4711] - Add multiple operator supports to Impala translator (case insensitive ilike, iregex, etc))
  • [TEIID-4760] - optional object name manipulations while executing IMPORT FOREIGN SCHEMA
  • [TEIID-4784] - Provide functionality to perform RENAME table in DDL scripts
  • [TEIID-4863] - Run teiid embedded via Spring Boot
  • [TEIID-4888] - Support for SetQueryLimit

Bug

  • [TEIID-3075] - OSGi bundle versions hardcoded
  • [TEIID-3883] - Properly project generated keys
  • [TEIID-4523] - CXF is not used by Salesforce BulkConnection
  • [TEIID-4854] - Google translator fails to update timestamp value reformatted after update
  • [TEIID-4884] - Google spreadsheet throws Error when getting batch 401:Unauthorized
  • [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-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-4955] - add cassandra failed message in server start up
  • [TEIID-4957] - Setting Connection Type on VDB of a Domain Managed server gets set back to default after server restart
  • [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-4976] - criteria duplicated when criteria includes the same columns as dependent join criteria
  • [TEIID-4980] - arche-type parent not available in maven
  • [TEIID-4982] - Wrong exception thrown getDataSource()
  • [TEIID-4983] - Couchbase tests rely on unpredictable order
  • [TEIID-4986] - Couchbase import nested array handling
  • [TEIID-4987] - SOAP12 WSDL procedure ignored during metadata import
  • [TEIID-4988] - Oracle - table alias is not used in whole query
  • [TEIID-4989] - Impala - Select * fails with reserved words in query
  • [TEIID-4990] - Embedded Teiid with JPA layer Transaction Management detection
  • [TEIID-4996] - Teiid embedded with Solr (exception max boolean clauses)
  • [TEIID-5001] - TextTable usage in UNION/UNION ALL queries with JOINs fails with "No value was available" or NPE errors

Task

  • [TEIID-2834] - Use FunctionMethod metadata internally for built-in aggregates
  • [TEIID-4474] - Re-license under a more permissive license
  • [TEIID-4500] - Make documents to capable of building outside the GitBooks
  • [TEIID-4781] - upgrade MongoDB Java Driver
  • [TEIID-4894] - Remove xml document models
  • [TEIID-4910] - Update build to utilize a maven docker plugin
  • [TEIID-4944] - Remove misc deprecated code
  • [TEIID-4952] - release notes is not having tokens replaced

Sub-task

  • [TEIID-3529] - Add pushdown support for regexp_replace
  • [TEIID-4208] - Increase plan parallelism
  • [TEIID-4536] - Support create schema with multiple statements
  • [TEIID-4537] - Store ddl as fully qualified
  • [TEIID-4538] - Enforce authorizations
  • [TEIID-4539] - Reduce memory footprint of DatabaseStore
  • [TEIID-4540] - Make admin methods the same for ddl vdbs
  • [TEIID-4911] - Teiid embedded support Spring boot
  • [TEIID-4916] - Ensure modules have only a single or compatible licenses
  • [TEIID-4922] - Re-license other root projects
  • [TEIID-4924] - Push Teiid artifacts to maven central
  • [TEIID-4929] - Add a User Guide for teiid spring boot starter
  • [TEIID-4939] - Enhance translator auto-detect and ddl deployment
  • [TEIID-4940] - Create a sample to demonstrate use Spring datasource and transaction manager

Edit/Copy Release Notes

The text area below allows the project release notes to be edited and copied to another document.