问一下大佬们,Doris从取KAFKA中同步数据,JSON嵌套的咋取的?

提问者:帅平 问题分类:数据库
问一下大佬们,Doris从取KAFKA中同步数据,JSON嵌套的咋取的?例如:
{
	"title": "新建自定义创意_视频_20220701_13:07_1",
	"status": "40",
	"creative_id": 24429097708,
	"ad_id": 1703740483,
	"advertiser_id": 14189793,
	"image_id": "https://p2.a.yximgs.com/upic/2022/07/01/11/BMjAyMjA3MDExMTAxNTVfMjY1NDQzMjEwNl83ODAzNjE0Njc5Nl8xXzM\u003d_B6fee7eb0dfed0b6e625b69b63098ce58.jpg?tag\u003d1-1656656592-unknown-0-j9rgn56ew1-22a92428176bc283\u0026clientCacheKey\u003d3xitbssmynk3pie.jpg\u0026di\u003db7e4099e\u0026bp\u003d10000",
	"video_id": "5241908569980742362",
	"creative_create_time": "2022-07-04 14:40:32",
	"creative_modify_time": "2022-07-27 15:27:54",
	"image_mode": "1",
	"expose_tag": "",
	"new_expose_tag": [],
	"is_dynamic_creative": false,
	"reject_message": "已删除",
	"splash_pictures": [],
	"splash_photos": [],
	"display_info": {
		"description": "哈珠太阳能路灯生产厂家,一手货源,无中间商赚差价,欢迎咨询!",
		"action_bar_text": "了解详情"
	}
}
1 个回答
走过的路
走过的路
可以参考我i下图的取值方式:
发布于:1年前 (2023-09-02) IP属地:四川省
我来回答