hello,
athena supports array. however QS does not support.
for example, when I run below, it shows me an error: column types in your data source are supported
“select t.test2
from tax_table t1
cross join unnest(tax_table_listoflist_dec21) as t(test2)”
Can you pls share what is the alternative way? I followed “SELECT — Presto 0.284 Documentation” but it is not working
Hello @JLLLL, is there a particular reason you are wanting to run the unnest function from QuickSight? Would you be able to build the view from Athena, unnest the json, and then query that for your dataset? I haven’t attempted to do this from QuickSight before, but if it isn’t supported it is likely that running the function from Athena would be your best bet.
Hello @JLLLL, I will mark my above response as the solution, but if you have further questions about this, please let me know!