Spark Scala-更新/添加Json对象中的新列并使用新的数据框值更新

问题描述

我想用另一个json对象的内容更新现有json对象中的对象数组.

I want to update an array of objects within an existing json object with the content from another json object.

初始对象:

{
    "user": "gT35Hhhre9m",
    "date": "2016-01-29",
    "status": "OK",
    "reason": "some reason",
    "content": [
        {
            "foo": 123,
            "bar": "val1"
        }
    ]
}

补充对象:

{
    "id": "gT35Hhhre9m"
}

合并后对象结构:

{
    "user": "gT35Hhhre9m",
    "date": "2016-01-29",
    "status": "OK",
    "reason": "some reason",
    "content": [{
        "foo": 123,
        "bar": "val1"
        "id": "gT35Hhhre9m"
    }]
}

推荐答案

不要将数据帧视为JSON是窍门.

Not thinking dataframe as JSON is the trick.