Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - hive sql error: Invalid Table Alias or Column Reference


Copy link to this message
-
hive sql error: Invalid Table Alias or Column Reference
Vijay 2009-08-21, 01:55
I have a simple query like this (identify hosts that have more than one
request):

select host, count(1) as cnt from accesslogs where cnt>1 group by host;

and it throws the error Invalid Table Alias or Column Reference cnt.

Is using column alias like this unsupported? Is there another way of
achieving the same query as above?