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:
4.2.1
nested.zip (440 Bytes)