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 insert them in to a summary table.
The query I came up with looks something like
INSERT OVERWRITE
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 =
Hooker mwhoo...@disqus.com
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 table
of events, and insert