posexplode 和 lateral view

1、题

【转换】

原数据：

{

        "account_id": "1",

        "device_id": "1",

        "action_time": "2023-05-09 12:47:16",

        "data": {

                "type": "0",

                "goods": [

                        { "id": 25, "count": 1, "price": 200.00 },

                        { "id": 2, "count": 3, "price": 13.51 }

                 ]

        }

}

输出

实现

select
       get_json_object(json_data,'$.ac