hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shouguo Li <the1plum...@gmail.com>
Subject Re: Query behaving differently from CLI vs HiveServer
Date Thu, 01 Sep 2011 19:18:59 GMT
on hive server queries, make sure you don't include the trailing semicolon
";"


On Wed, Aug 31, 2011 at 7:34 PM, Ayon Sinha <ayonsinha@yahoo.com> 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 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_stamp) <= '2011-08-13' and
> w.did_succeed=1 group by department_type;
>
> But giving this to Hive server gives:
>
> Query returned non-zero code: 11, cause: FAILED: Parse Error: line 1:0
> cannot recognize input 'and'
>
> -Ayon
> See My Photos on Flickr <http://www.flickr.com/photos/ayonsinha/>
> Also check out my Blog for answers to commonly asked questions.<http://dailyadvisor.blogspot.com>
>

Mime
View raw message