> Sent: Monday, June 4, 2012 8:01:26 PM
> Subject: Need help running query over "yesterday". getting "No partition
> predicate found" errors
>
> Hello,
>
>
> I'm trying to construct a query which will do some simple counts over a
> table of events, and
From: "Matthew Hooker"
To: user@hive.apache.org
Sent: Monday, June 4, 2012 8:01:26 PM
Subject: Need help running query over "yesterday". getting "No partition
predicate found" errors
Hello,
I'm trying to construct a query which will do some simple counts over a t
Hello,
I'm trying to construct a query which will do some simple counts over a
table of events, and insert them in to a summary table.
The query I came up with looks something like
INSERT OVERWRITE TABLE activity
PARTITION(date_utc)
select count(1) views,
from impressions
where dt >= date_sub(to