hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Thusoo <athu...@facebook.com>
Subject RE: Failed in prefix the column name with the table alias in the order_by clause
Date Fri, 02 Jul 2010 21:46:49 GMT
Definitely a bug.

I have filed

https://issues.apache.org/jira/browse/HIVE-1449

for this issue.

Thanks,
Ashish

________________________________
From: 何翔 [mailto:calvin.he.84@gmail.com]
Sent: Friday, July 02, 2010 4:09 AM
To: hive-user@hadoop.apache.org
Subject: Failed in prefix the column name with the table alias in the order_by clause

hive> SELECT L.key, sum(C.quantity) FROM TA L JOIN TB C ON L.key=C.key GROUP BY L.key ORDER
BY L.key;

FAILED: Error in semantic analysis: line 1:89 Invalid Table Alias or Column Reference L


In "ORDER BY L.key", Hive reports error because the key is prefixed with L.
"SELECT L.key, sum(quantity) FROM TA L JOIN TB C ON L.key=C.key1 GROUP BY L.key ORDER BY key"
is right.
Why?



Thanks.
Clyde

Mime
View raw message