[ https://issues.apache.org/jira/browse/HIVE-9228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mariano Dominguez updated HIVE-9228: ------------------------------------ Affects Version/s: 0.13.1 > Problem with subquery using windowing functions > ----------------------------------------------- > > Key: HIVE-9228 > URL: https://issues.apache.org/jira/browse/HIVE-9228 > Project: Hive > Issue Type: Bug > Components: Query Processor > Affects Versions: 0.13.1 > Reporter: Aihua Xu > Assignee: Aihua Xu > Original Estimate: 96h > Remaining Estimate: 96h > > The following query with window functions failed. The internal query works > fine. > 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 end ) over (partition by > st_fips_cd, zip_cd_5) as CNT_ADVTG_LEN_RSDNC_CD_1, > row_number() over (partition by st_fips_cd, zip_cd_5 order by hh_surr_key > asc) as analytic_row_number3 > from hh_agg > where analytic_row_number2 = 1 > ) t; -- This message was sent by Atlassian JIRA (v6.3.4#6332)