Re: Query fails for certain conditions in the while clause

2015-01-29 Thread Mostafa T
would you elaborate please On Thu, Jan 29, 2015 at 5:50 PM, murali parimi < muralikrishna.par...@icloud.com> wrote: > My bad. The tables are Bucketed on the same join key. > > Sent from my iPhone > > On Jan 29, 2015, at 9:38 AM, Mostafa T wrote: > > Hello, > I t

Query fails for certain conditions in the while clause

2015-01-29 Thread Mostafa T
Hello, I try to run a nested query. In the where clause in the inner query if I include all of the expressions hereunder, it fails. WHERE query_id = 6028 AND created_at_basic_date >= 20141230 AND created_at_basic_date <= 20150126 However if I included only the query_id or one or both of the dates