I am trying to extract keys and values from a map type but the way it is deserialized in dremio as:
{ map: [ { “key”: “key1”, “value”: “value1” }, {“key”: “key2”, “value”: “value2”}] }
instead of
{“key1”: “value1”, “key2”: “value2”}
is challenging to work with because it requires unnesting the inner map array which is not ideal. Is there any way to produce the second representation instead?