Extracting map elements

1

Hello

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.

2

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.