Combine rows with json string and map

[Buntu Dev]

I'm looking for ideas on how to go about merging columns from 2 tables. In
one of the table I got a json string column that needs to be added to the
map<string, string> column of other table.

json string: {"type": "fruit", "name":"apple"}
map: {'type' -> 'fruit', 'f' -> 'foo', 'b' -> 'bar'}

The resulting map field after combine the two columns will be:
 {'type' -> 'fruit', 'f' -> 'foo', 'b' -> 'bar', 'name' -> 'apple'}


How do I go about handling this? Thanks!