Re: Query fails for certain conditions in the while clause

2015-01-29 Thread murali parimi
please ignore. Wrong thread! On Jan 29, 2015, at 09:33 PM, Mostafa T wrote: would you elaborate please On Thu, Jan 29, 2015 at 5:50 PM, murali parimi 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

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 try to run a nested query. > In the

Re: Query fails for certain conditions in the while clause

2015-01-29 Thread murali parimi
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 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

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