You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by Swapna Swapna <ta...@gmail.com> on 2016/05/05 00:54:34 UTC

Question on FIRST_VALUE

HI,

Can anyone please help me to clarify this function signature:

*FIRST_VALUE (expression
<https://phoenix.apache.org/language/index.html#expression> ) WITHIN GROUP
( ORDER BY expression
<https://phoenix.apache.org/language/index.html#expression>)*

In addition to the below example queries we have:

FIRST_VALUE(name) WITHIN GROUP (ORDER BY salary DESC)

FIRST_VALUE(ID=1 OR NAME='Hi') WITHIN GROUP (ORDER BY salary DESC)

 Can I pass multiple columns to this function like the below:

FIRST_VALUE(id, name) // multi-columns

Regards

Swapna