HBase - table's alias (... AS ...) is not "visible" in
SELECT caluse in IN predicate
------------------------------------------------------------------------------------
Key: TEIID-3770
URL:
https://issues.jboss.org/browse/TEIID-3770
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.7.1.6_2
Reporter: Juraj DurĂ¡ni
Assignee: Steven Hawkins
Fix For: 8.12.1, 8.13
Query:
SELECT INTKEY, BIGDECIMALVALUE FROM BQT1.SMALLA AS A WHERE BIGDECIMALVALUE *IN (SELECT
MAX(BIGDECIMALVALUE) FROM BQT1.SMALLA AS B WHERE _A_.INTKEY = B.INTKEY)* ORDER BY INTKEY
It seems like bug in Phoenix driver.