Extracting map elements


I’ve just started using Dremio and it is a great tool - I can’t figure one thing out though and I’m probably being stupid. In this guide there’s a section on extracting a map element https://www.dremio.com/tutorials/data-curation-with-dremio/

How do you extract all map elements in one go - it’s painful to do this individually and in my dataset some rows have additional map elements as well.

Appreciate any advice.

You’ll be able to try kvgen() when 1.5 ships later this month. Meanwhile, you can do things manually, though I know that’s not a lot of fun.