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
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 some cases now - x days until now). Best regards, Robin Verlangen *Software engineer* * * W http://www.robinverlangen.nl E ro...@us2.nl Disclaimer: The infor

Re: Hive ignoring buckets when using dynamic where

2012-09-20 Thread Bejoy KS
Hi Robin The result of 'bdate=to_date(unix_timestamp())' is evaluated during the runtime of the query. But the data that a query should process is determined initially before executing the map reduce jobs. That is the reason the query is running over whole data set. When you provide 'bdate='20