on hive server queries, make sure you don't include the trailing semicolon
";"
On Wed, Aug 31, 2011 at 7:34 PM, Ayon Sinha wrote:
> Hive CLI runs this query just fine:
> select department_type, count(*) as total_walkins, count(distinct user_id)
> as unique_walkers from userstore.walkin w join l
Hive CLI runs this query just fine:
select department_type, count(*) as total_walkins, count(distinct user_id) as
unique_walkers from userstore.walkin w join locations.locations loc on
w.location_id = loc.id where loc.chain_id = 56876135 and to_date (time_stamp)
>= '2011-08-07' and to_date (time
