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.