[ https://issues.apache.org/jira/browse/HIVE-4662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13793652#comment-13793652 ]
N Campbell commented on HIVE-4662: ---------------------------------- not just first value select c1, c2, sum ( c3 ) over ( partition by c1 order by c2, c3 ) from t > first_value can't have more than one order by column > ---------------------------------------------------- > > Key: HIVE-4662 > URL: https://issues.apache.org/jira/browse/HIVE-4662 > Project: Hive > Issue Type: Bug > Components: SQL > Affects Versions: 0.11.0 > Reporter: Frans Drijver > > In the current implementation of the first_value function, it's not allowed > to have more than one (1) order by column, as so: > {quote} > select distinct > first_value(kastr.DEWNKNR) over ( partition by kastr.DEKTRNR order by > kastr.DETRADT, kastr.DEVPDNR ) > from RTAVP_DRKASTR kastr > ; > {quote} > Error given: > {quote} > FAILED: SemanticException Range based Window Frame can have only 1 Sort Key > {quote} -- This message was sent by Atlassian JIRA (v6.1#6144)