[
https://issues.apache.org/jira/browse/TAJO-14?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyunsik Choi updated TAJO-14:
-----------------------------
Summary: The ambiguous column error occurs when an alias name is used as a
sort key. (was: The ambiguous column error occurs when orderby clause includes
an alias name of select list.)
> The ambiguous column error occurs when an alias name is used as a sort key.
> ---------------------------------------------------------------------------
>
> Key: TAJO-14
> URL: https://issues.apache.org/jira/browse/TAJO-14
> Project: Tajo
> Issue Type: Bug
> Components: parser
> Reporter: Hyunsik Choi
> Assignee: Hyunsik Choi
> Fix For: 0.2-incubating
>
>
> For example, see the below query. The column reference 'revenue' is an alias
> name defined in select list. In this case, QueryAnalyzer concludes that
> 'revenue' is ambiguous.
> {noformat}
> tajo> select l_orderkey, sum(l_extendedprice*(1-l_discount)) as revenue,
> o_orderdate, o_shippriority from customer, orders, lineitem where
> c_mktsegment = 'BUILDING' and c_custkey = o_custkey and l_orderkey =
> o_orderkey and o_orderdate < '1995-03-15' and l_shipdate > '1995-03-15' group
> by l_orderkey, o_orderdate, o_shippriority order by revenue desc, o_orderdate
> ERROR: column name revenue is ambiguous
> tajo>
> {noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
