hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex Piyevsky (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2873) Qualifying a column name in an ORDER BY clause generates 'Error in semantic analysis'
Date Mon, 06 Jan 2014 01:46:50 GMT

    [ https://issues.apache.org/jira/browse/HIVE-2873?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13862718#comment-13862718
] 

Alex Piyevsky commented on HIVE-2873:
-------------------------------------

I will be out on vacation from March 26 to March 29, and will return to the office on April
1. During that time please contact Marina Sapozhnikova at (x4937) for MS SQL QA issues, Nataliya
Martynovich at (x3662) for general QA inqueries, or Maria Trofimova at (x3771) if you need
urgent help with a customer case.

Regards, Alex Piyevsky



> 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: Query Processor
>    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 was sent by Atlassian JIRA
(v6.1.5#6160)

Mime
View raw message