[
https://issues.apache.org/jira/browse/PHOENIX-927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13965970#comment-13965970
]
alex kamil edited comment on PHOENIX-927 at 4/10/14 11:13 PM:
--------------------------------------------------------------
[~maryannxue] , I checked the primary use case with joins and it works as
expected, many thanks,
now if I try to do a simple nested select (using derived table) without JOIN it
throws this error:
jdbc:phoenix:localhost> SELECT a.col1 FROM (SELECT rk, col1 FROM table1 WHERE
col1 LIKE 'foo%' AND col300 IS NOT NULL) AS a ;
java.lang.ClassCastException: org.apache.phoenix.parse.DerivedTableNode cannot
be cast to org.apache.phoenix.parse.NamedTableNode
at
org.apache.phoenix.compile.FromCompiler.getResolverForQuery(FromCompiler.java:157)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:262)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:253)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:199)
at
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:922)
at sqlline.SqlLine$Commands.execute(SqlLine.java:3673)
at sqlline.SqlLine$Commands.sql(SqlLine.java:3584)
at sqlline.SqlLine.dispatch(SqlLine.java:821)
at sqlline.SqlLine.begin(SqlLine.java:699)
at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
at sqlline.SqlLine.main(SqlLine.java:424)
also a nested query like this doesn't work
SELECT col1 FROM table1 where col3 > (SELECT count(col300) FROM table2)
Error: ERROR 602 (42P00): Syntax error. Missing "LPAREN" at line 1, column 31.
(state=42P00,code=602)
was (Author: alexdl):
[~maryannxue] , I checked the primary use case with joins and it works as
expected, many thanks,
now if I try to do a simple nested select (using derived table) without JOIN it
throws this error:
jdbc:phoenix:localhost> SELECT a.col1 FROM (SELECT rk, col1 FROM table1 WHERE
col1 LIKE 'foo%' AND col300 IS NOT NULL) AS a ;
java.lang.ClassCastException: org.apache.phoenix.parse.DerivedTableNode cannot
be cast to org.apache.phoenix.parse.NamedTableNode
at
org.apache.phoenix.compile.FromCompiler.getResolverForQuery(FromCompiler.java:157)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:262)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:253)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:199)
at
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:922)
at sqlline.SqlLine$Commands.execute(SqlLine.java:3673)
at sqlline.SqlLine$Commands.sql(SqlLine.java:3584)
at sqlline.SqlLine.dispatch(SqlLine.java:821)
at sqlline.SqlLine.begin(SqlLine.java:699)
at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
at sqlline.SqlLine.main(SqlLine.java:424)
> Support derived tables in joins
> -------------------------------
>
> Key: PHOENIX-927
> URL: https://issues.apache.org/jira/browse/PHOENIX-927
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Maryann Xue
> Assignee: Maryann Xue
> Labels: enhancement
> Fix For: 3.0.0, 4.0.0, 5.0.0
>
> Original Estimate: 240h
> Remaining Estimate: 240h
>
> Support grammar like:
> SELECT a.col1, b.col2, c.col3 FROM
> (SELECT rk, col1 FROM table1 WHERE col1 LIKE 'foo%' AND col300 IS NULL) AS a
> JOIN (SELECT rk, col2 FROM table2 WHERE col2 LIKE 'bar%') AS b ON a.rk=b.rk
> JOIN (SELECT rk, col3 FROM table3 ) AS c ON a.rk=c.rk;
--
This message was sent by Atlassian JIRA
(v6.2#6252)
