[
https://issues.apache.org/jira/browse/PHOENIX-2351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14983431#comment-14983431
]
Alicia Ying Shu commented on PHOENIX-2351:
------------------------------------------
For example, in the test to get the values of columns
create table t1(id integer, a varchar(10));
create table t2(id integer, a varchar(10));
select t1.a, t2.a from t1, t2 where t1.id =t2.id;
You want to access column values as rs.getString("t1.a") and
rs.getString("t2.a"), not rs.getString("a").
> Phoenix query table alias name is not coming the output xml file
> ----------------------------------------------------------------
>
> Key: PHOENIX-2351
> URL: https://issues.apache.org/jira/browse/PHOENIX-2351
> Project: Phoenix
> Issue Type: Bug
> Reporter: Alicia Ying Shu
> Assignee: Alicia Ying Shu
> Attachments: PHOENIX-2351.patch
>
>
> Phoenix query table alias name is not coming the output xml file.
> From sqlline:
> !outputformat xmlattr
> SELECT /*+ SORTED_MERGE_JOIN */ * FROM LARGE_TABLE AS L INNER JOIN
> GIGANTIC_TABLE AS G ON L.UNSIG_ID=G.BIG_ID LIMIT 10000;
> When alias name is used in the query (in this example, table alias name is
> “L”) then the expected xml output need to have the alias name,
> Current output:
> <resultset>
> <result ID="0" UNSIG_ID="0" BIG_ID="0" UNSIG_LONG_ID="0" ...
> ......
> Expected output:
> <resultset>
> <result L.ID="0" UNSIG_ID="0" G.BIG_ID="0" UNSIG_LONG_ID="0" ...
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
