array with elements and with out element

[pandu39]

Hi, I am unable to achieve below functionality on my data, any have suggestions?

i/p: { "details": {"ROW":[ {"company":"xyz", "domain":"123", "items":{"ROW":[{"shoes":"Nike","shirt":""},{"shoes":"Fila","shirt":""}]} }, {"company":"x", "domain":"12", "items":{"ROW":[]} } ] }, "send":"me" }

expected output from hive- send|company|domain|shoes|shirt me |xyz |123 |Nike |null me |xyz |123 |Fila |null me |x |12 |null |null

Actually I am unable to get third row in this case, first two rows are good but third row is missing while exploding array with openX serde