[ https://issues.apache.org/jira/browse/HIVE-4662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15190613#comment-15190613 ]
Jesus Camacho Rodriguez commented on HIVE-4662: ----------------------------------------------- [~ashutoshc], I have just added them. However, second one (row_number) should be executed over full partition, right? Thus, finally I added: {noformat} select row_number() over (partition by si, bo order by i, f desc range between unbounded preceding and unbounded following) from over10k limit 100; {noformat} Observe that both ends are unbounded. > 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 > Assignee: Jesus Camacho Rodriguez > Attachments: HIVE-4662.01.patch, HIVE-4662.01.patch, HIVE-4662.patch > > > 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.3.4#6332)