phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2579) Columns with table alias do not work in some derived table queries
Date Tue, 12 Jan 2016 15:52:39 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-2579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15094119#comment-15094119
] 

Hudson commented on PHOENIX-2579:
---------------------------------

SUCCESS: Integrated in Phoenix-master #1065 (See [https://builds.apache.org/job/Phoenix-master/1065/])
PHOENIX-2579 Columns with table alias do not work in some derived table (maryannxue: rev 12d58a0758dbd280950237a797ce3937edf87c18)
* phoenix-core/src/main/java/org/apache/phoenix/compile/SubselectRewriter.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/DerivedTableIT.java


> Columns with table alias do not work in some derived table queries
> ------------------------------------------------------------------
>
>                 Key: PHOENIX-2579
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2579
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.4.0, 4.6.0, 4.5.2
>            Reporter: Ziyang Zhao
>            Assignee: Maryann Xue
>             Fix For: 4.7.0
>
>         Attachments: PHOENIX-2579.patch
>
>
> Used a table without schema and without catalog
> table name: TESTTABLE
> num (DECIMAL(12, 2))
> 100.25
> 200.25
> 300.25
> 400.25
> Did a query:
> select A.num from (select * from testtable) A;
> And got the following error messages:
> Error: error while executing SQL "select A.col3 from (select * from T3CODEBASE_TABLE)
A": response code 500 (state=,code=0)
> java.sql.SQLException: error while executing SQL "select A.col3 from (select * from T3CODEBASE_TABLE)
A": response code 500
>         at org.apache.calcite.avatica.Helper.createException(Helper.java:39)
>         at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:111)
>         at org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:120)
>         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)
> Caused by: java.lang.RuntimeException: response code 500
>         at org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:45)
>         at org.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:195)
>         at org.apache.calcite.avatica.remote.RemoteMeta.prepareAndExecute(RemoteMeta.java:157)
>         at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:474)
>         at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:108)
>         ... 7 more



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message