hbutani/SQLWindowing — Issue #7: where clause not working
Author: achaubal
Created: 2012-02-02 18:08:37+00:00
State: open

Hey Harish,

I am running a query which has a final **where** clause

from \
partition by acct_no
order by acct_no, my_date asc
with
RowNumber(cv_tot_bal) as tot_rank, Count(cv_tot_bal) as tot_count
select
acct_no, my_date, cv_tot_bal, tot_rank, tot_count
Where < tot_rank in ( tot_count/2 +1), (tot_count+1)/2) >
into path='ma_7_2011_08'

the query runs and the create table hive job compeltes successfully. But the next windowing Job never runs and there is no indication in the window as well, no error.
Without the **where* clause the query runs fine.

Is my **where** syntax ok?

i am trying to do a median.

ameet