Hi community, I have a mapType (list of key value pairs) in my parquetFile and it queries fine like
select "table".map from table
How can I get the value by the key from mapType field? currenlty documentation https://docs.dremio.com/sql-reference/sql-functions/nested-data.html describes only FLATTEN function which definitely is not enough.
so given mapType is (a -> 1, b ->2) how can I achieve something like its implemeted for JSON?
select "table".map.a, "table".map.b from "table"?