[
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)
