hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Buntu Dev <>
Subject Combine rows with json string and map
Date Tue, 23 Feb 2016 22:38:22 GMT
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!

View raw message