Fwd: Exception with the window function

forwarded message: > From: Aihua Xu > Subject: Exception with the window function > Date: January 5, 2015 at 6:51:01 AM PST > To: user@hive.apache.org > > Hi folks, > > I’m working on the HIVE-9228 > (https://issues.apache.org/jira/browse/HIVE-9228) with the followi

Exception with the window function

Hi folks, I’m working on the HIVE-9228 (https://issues.apache.org/jira/browse/HIVE-9228) with the following window query throwing ArrayOutOfBoundExcption. select st_fips_cd, zip_cd_5, hh_surr_key from ( select st_fips_cd, zip_cd_5, hh_surr_key, count( case when advtg_len_rsdnc_cd = '1' then 1 e