Open pandu39 opened 6 years ago
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
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