hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashish Thusoo (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-1449) Table aliases in order by clause lead to semantic analysis failure
Date Fri, 02 Jul 2010 21:44:49 GMT
Table aliases in order by clause lead to semantic analysis failure
------------------------------------------------------------------

                 Key: HIVE-1449
                 URL: https://issues.apache.org/jira/browse/HIVE-1449
             Project: Hadoop Hive
          Issue Type: Bug
          Components: Query Processor
            Reporter: Ashish Thusoo
            Assignee: Ashish Thusoo
             Fix For: 0.7.0


A simple statement of the form

select a.account_id, count(1) from tmp_ash_test2 a group by a.account_id order by a.account_id;

throws a sematic analysis exception

where as

select a.account_id, count(1) from tmp_ash_test2 a group by a.account_id order by account_id;

works fine (the second query does not have the table alias a in the order by clause.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message