[
https://issues.apache.org/jira/browse/PHOENIX-2351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14979345#comment-14979345
]
Alicia Ying Shu commented on PHOENIX-2351:
------------------------------------------
[~maryannxue] The problem is that in our internal testing we used to compare
the output column results in XML form and each output column name has its
associated alias/tableName. After PHOENIX-1560, the alias/tableName is gone. It
can have the side effect that a multi-table query's columns do not have their
alias/tableName qualifiers. I have a patch to add the alias/tableName back. But
want to double check about it.
> 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
>
> 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)
