CODEWITHSUNDEEP
sqlhadoophivebigdata
Avramescu Cristian
Avramescu Cristian

Reputation: 67

HIve Create Json Array that not contains duplicate

I want to create an array of jsons that not contain duplicate . I had used LATERAL VIEW EXPLODE to break the initial Array , and now i want to group the string json i received and create merged jsons based on a key. For example if i have : Col1 : 

{"key" : ke , "value" : 1 }
{"key" : ke , "value" : 2 }
{"key" : ke1 , "value" : 5 }

I would like to have

{"key" : ke , "value" : 3 }
{"key" : ke1 , "value" : 5 }

Can you help me?

Upvotes: 1

Views: 245

Answers (1)

David דודו Markovitz
David דודו Markovitz

Reputation: 44921

select      concat('{"key":"',jt.key,'","value":',sum(jt.value),'}')

from        mytable t
            lateral view json_tuple(Col1, 'key', 'value') jt as key,value

group by    jt.key
;

Upvotes: 1

Related Questions