[
https://issues.apache.org/jira/browse/PHOENIX-2351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14983223#comment-14983223
]
Maryann Xue commented on PHOENIX-2351:
--------------------------------------
Hi, [~aliciashu], the tableName / alias is not gone, it is still available in
the ExpressionProjector. The columnName in ExpressionProjector is the pure
column name. I removed this to avoid name conflict and changed some data
structure in ExpressionProjector to adapt this. So you should work on how to
output the table name information from ExpressionProjector instead of reversing
part of the changes I made in PHOENIX-1560.
> 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)
