[
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)
