Window Functions - NTH VALUE

1

Hi,

FIRST_VALUE and LAST_VALUE are available in Dremio but not mentioned in Documentation about LAST_VALUE. Is there any way that I can use Nth_VALUE in Dremio ?

Thanks

2

@Maziha

I just tried an example on Hive and Mysql, Dremio did not recognize the function, if your backend is RDBMS, you can try using external query

Thanks
Bali