Is there someway to reverse a list?
I have a dataset from json files on an object store. There is a list of items that I would like to reverse. I would expect the below to work, but it doesn’t. “list_of_items_reversed” is NULL for every row. In fact I get NULL anytime I use a negative number for the third arg in SUBLIST:
SELECT list_of_items,
SUBLIST( list_of_items, -1, -ARRAY_LENGTH(list_of_items)) AS list_of_items_reversed
FROM data_table
Dremio Build: 4.2.1-202004111451200819-0c3ecaea