Re: Need help running query over yesterday. getting No partition predicate found errors

2012-06-05 Thread Matthew Hooker
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

Need help running query over yesterday. getting No partition predicate found errors

2012-06-04 Thread Matthew Hooker
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 =

Re: Need help running query over yesterday. getting No partition predicate found errors

2012-06-04 Thread Mark Grover
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