Hyunsik Choi created TAJO-14:
--------------------------------
Summary: The ambiguous column error occurs when orderby clause
includes an alias name of select list.
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
