Re: Hive ignoring buckets when using dynamic where

2012-09-21 Thread Robin Verlangen
rg/docs/r0.9.0/language_manual/var_substitution.html >> >> http://kickstarthadoop.blogspot.in/2011/10/include-values-during-execution-time-in.html >> >> >> Regards, >> Bejoy KS >> >> ---------- >> *From:* Robin Verlangen

Re: Hive ignoring buckets when using dynamic where

2012-09-20 Thread Jamie Olson
doop.blogspot.in/2011/10/include-values-during-execution-time-in.html > > > Regards, > Bejoy KS > > -- > *From:* Robin Verlangen > *To:* user@hive.apache.org; Bejoy KS > *Sent:* Thursday, September 20, 2012 7:30 PM > *Subject:* Re: Hive ig

Re: Hive ignoring buckets when using dynamic where

2012-09-20 Thread Bejoy KS
: Robin Verlangen To: user@hive.apache.org; Bejoy KS Sent: Thursday, September 20, 2012 7:30 PM Subject: Re: Hive ignoring buckets when using dynamic where Hi Bejoy, Thank you for your reply. Is there any way to fix my problem? I want to have a query that has a dynamic range, from now (and in

Re: Hive ignoring buckets when using dynamic where

2012-09-20 Thread Robin Verlangen
> *From:* Robin Verlangen > *To:* user@hive.apache.org > *Sent:* Thursday, September 20, 2012 5:06 PM > *Subject:* Hive ignoring buckets when using dynamic where > > Hi there, > > We're working on some queries that use buckets to improve

Re: Hive ignoring buckets when using dynamic where

2012-09-20 Thread Bejoy KS
titions.     Regards, Bejoy KS From: Robin Verlangen To: user@hive.apache.org Sent: Thursday, September 20, 2012 5:06 PM Subject: Hive ignoring buckets when using dynamic where Hi there, We're working on some queries that use buckets to improve performan

Hive ignoring buckets when using dynamic where

2012-09-20 Thread Robin Verlangen
Hi there, We're working on some queries that use buckets to improve performance with like 1000x. However we ran into a problem. When we use a fixed hardcoded date it works fine: SELECT * FROM standard_feed WHERE bdate='2012-09-01' *Starts a job with 6 mappers, 2 reducers* When we use it dynamica