[teiid-issues] [JBoss JIRA] (TEIID-3770) HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate
[
https://issues.jboss.org/browse/TEIID-3770?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3770:
---------------------------------------
There's not much more we can do with this issue. We can either not pushdown
correlated subqueries, or just accept that phoenix has bugs in this area and address it
further if it becomes a customer issue. Since this produces as exception it's safe to
just take the latter approach for now.
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.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)