hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex Piyevsky (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-2873) Qualifying a column name in an ORDER BY clause generates 'Error in semantic analysis'
Date Thu, 15 Mar 2012 18:54:37 GMT
Qualifying a column name in an ORDER BY clause generates 'Error in semantic analysis'
-------------------------------------------------------------------------------------

                 Key: HIVE-2873
                 URL: https://issues.apache.org/jira/browse/HIVE-2873
             Project: Hive
          Issue Type: Bug
          Components: JDBC
    Affects Versions: 0.7.1
         Environment: Linux Kernel-2.6.18-glibc-2.5 x86_64 64bit
            Reporter: Alex Piyevsky


When I run the following SELECT:

SELECT T1.f03int, SUM(T1.f05double) FROM b774winx86qa07_tmix91
T1 GROUP BY T1.f03int ORDER BY T1.f03int;

It generates 

:  (10) [42000] Query returned non-zero code: 10, cause: FAILED: Error in 
: semantic analysis: line 1:94 Invalid Table Alias or Column Reference T1

If I remove T1 qualifier from the ORDER BY clause (ORDER BY f03int) data is returned correctly.
 Please advise, am I using incorrect syntax?  What is the proper syntax convetion for using
a table qualifier with ORDER BY

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message