Last element in array?

#1

Is it possible to retrieve the last element in an array?
I can do:
datasetpathlist[0]

but

datasetpathlist[array_length(datasetpathlist)]

gives me this error:

org.apache.calcite.rex.RexCall cannot be cast to org.apache.calcite.rex.RexLiteral.

#2

Hi @Joe This has been a request from others too but currently not in the product,

#3

try sublist([array],-1,1)[0]

#4

That worked, thank you! I don’t see sublist in the SQL reference – is there a list of undocumented functions somewhere?

#5

source code in github

#6

Wow - there’s a bunch: Search · implements simplefunction · GitHub