[ https://issues.apache.org/jira/browse/PHOENIX-2452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor reassigned PHOENIX-2452: ------------------------------------- Assignee: Maryann Xue Please dup out if another one already filed. > Error: Does not support non-standard or non-equi correlated-subquery > conditions. > -------------------------------------------------------------------------------- > > Key: PHOENIX-2452 > URL: https://issues.apache.org/jira/browse/PHOENIX-2452 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.6.0 > Reporter: Suhas Nalapure > Assignee: Maryann Xue > > java.sql.SQLFeatureNotSupportedException: Does not support non-standard or > non-equi correlated-subquery conditions. > Steps to re-produce: > ------------------------------------------------------------------------------------------ > 0: jdbc:phoenix:localhost:2181> create table temp (id bigint not null primary > key, cumsum bigint ); > No rows affected (0.74 seconds) > 0: jdbc:phoenix:localhost:2181> upsert into temp values(1,5); > 1 row affected (0.102 seconds) > 0: jdbc:phoenix:localhost:2181> upsert into temp values(3, 10); > 1 row affected (0.016 seconds) > 0: jdbc:phoenix:localhost:2181> upsert into temp values(6, 12); > 1 row affected (0.003 seconds) > 0: jdbc:phoenix:localhost:2181> upsert into temp values(7, 17); > 1 row affected (0.008 seconds) > 0: jdbc:phoenix:localhost:2181> upsert into temp values(10, 19); > 1 row affected (0.011 seconds) > 0: jdbc:phoenix:localhost:2181> select t1.id, t2.id, t1.cumsum, t2.cumsum, > t1.cumsum - t2.cumsum from temp t1, temp t2 where t2.id = (select max(id) > from temp where id < t1.id) and t1.cumsum > t2.cumsum ; > Error: Does not support non-standard or non-equi correlated-subquery > conditions. (state=,code=0) > java.sql.SQLFeatureNotSupportedException: Does not support non-standard or > non-equi correlated-subquery conditions. > at > org.apache.phoenix.compile.SubqueryRewriter$JoinConditionExtractor.leaveBooleanNode(SubqueryRewriter.java:479) > at > org.apache.phoenix.compile.SubqueryRewriter$JoinConditionExtractor.visitLeave(SubqueryRewriter.java:499) > at > org.apache.phoenix.compile.SubqueryRewriter$JoinConditionExtractor.visitLeave(SubqueryRewriter.java:405) > at > org.apache.phoenix.parse.ComparisonParseNode.accept(ComparisonParseNode.java:47) > at > org.apache.phoenix.compile.SubqueryRewriter.visitLeave(SubqueryRewriter.java:207) > at > org.apache.phoenix.compile.SubqueryRewriter.visitLeave(SubqueryRewriter.java:70) > at > org.apache.phoenix.parse.ComparisonParseNode.accept(ComparisonParseNode.java:47) > at > org.apache.phoenix.parse.CompoundParseNode.acceptChildren(CompoundParseNode.java:64) > at org.apache.phoenix.parse.AndParseNode.accept(AndParseNode.java:47) > at > org.apache.phoenix.parse.ParseNodeRewriter.rewrite(ParseNodeRewriter.java:48) > at > org.apache.phoenix.compile.SubqueryRewriter.transform(SubqueryRewriter.java:84) > at > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:375) > at > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:354) > at > org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:260) > at > org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:255) > at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > at > org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:254) > at > org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1382) > at sqlline.Commands.execute(Commands.java:822) > at sqlline.Commands.sql(Commands.java:732) > at sqlline.SqlLine.dispatch(SqlLine.java:808) > at sqlline.SqlLine.begin(SqlLine.java:681) > at sqlline.SqlLine.start(SqlLine.java:398) > at sqlline.SqlLine.main(SqlLine.java:292) -- This message was sent by Atlassian JIRA (v6.3.4#6332)