Unable to fetch intermediate elements from json array

I am able to fetch single element from json array but when choosing extract multiple, I am facing error fetching data.
SELECT id, type, name, batters, topping, sublist(topping, 2, array_length(topping)) AS topping_1, ppu
FROM “@admin”.nested AS nested

ERROR: Unexpected error occurred

Dremio Version:

nested.zip (440 Bytes)


It seems like sublist and array_length are not a Dremio supported functions

Which database are these SQL functions used ?


I have attached the json file which is stored in admin namespace of Dremio.


I do not see any attachment