Loading...

XML

Word

Printable

Release Note Text:

Hide
~~TEIID-3779~~ - There are a host of Phoenix issues that Teiid is currently not working around for HBase access. If you hit any of these, please let us know so that we can work with the Phoenix community to get it resolved. Generally Phoenix has issues with subquery evaluation and certain datatypes, such as char and timestamp.
* ~~TEIID-3772~~ ~~TEIID-3769~~ ~~TEIID-3766~~ are not likely to occur and generate an exception.
* ~~TEIID-3774~~ is unlikely but can return inaccurate results.
* ~~TEIID-3768~~ affects correlated subquery comparison using an aggregate of a char value and can return inaccurate results.

Show
TEIID-3779 - There are a host of Phoenix issues that Teiid is currently not working around for HBase access. If you hit any of these, please let us know so that we can work with the Phoenix community to get it resolved. Generally Phoenix has issues with subquery evaluation and certain datatypes, such as char and timestamp. * TEIID-3772 TEIID-3769 TEIID-3766 are not likely to occur and generate an exception. * TEIID-3774 is unlikely but can return inaccurate results. * TEIID-3768 affects correlated subquery comparison using an aggregate of a char value and can return inaccurate results.

Hbase has a number of issues with their sql handling / driver. Adding a parent issue to track all of known issues.

incorporates

TEIID-3766 HBase - using timestamp value with ALL (quantified comparison predicate) throws IllegalArgumentException

TEIID-3768 HBase - Phoenix does not evaluate query correctly

TEIID-3769 Teiid throws exception while reading result from HBase (Phoenix JDBC driver)

TEIID-3770 HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate

TEIID-3774 HBase - Phoenix driver evalues 'HAVING MIN/MAX/AVG(x) = null' to true

TEIID-3765 HBase - Phoenix does not support scalar subquery

TEIID-3772 HBase - Phoenix returns more than one result for subquery which should return only one row

(2 incorporates)