-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
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?