我对我们正在进行的项目有一个问题...
我尝试将此JSON提取到Google Big Query中,但无法从JSON输入中获取JSON投票对象字段。 我已尝试在模式中使用“record”和“string”类型。
{
"votes": {
"funny": 10,
"useful": 10,
"cool": 10
},
"user_id": "OlMjqqzWZUv2-62CSqKq_A",
"review_id": "LMy8UOKOeh0b9qrz-s1fQA",
"stars": 4,
"date": "2008-07-02",
"text": "This is what this 4-star bar is all about.",
"type": "review",
"business_id": "81IjU5L-t-QQwsE38C63hQ"
}
我无法从以下JSON中填充类别和街区JSON数组的表格。这些输入的模式应该是什么?不幸的是,文档在这种情况下没有提供太多帮助,或者可能我没有看对地方。
{
"business_id": "Iu-oeVzv8ZgP18NIB0UMqg",
"full_address": "3320 S Hill St\nSouth East LA\nLos Angeles, CA 90007",
"schools": [
"University of Southern California"
],
"open": true,
"categories": [
"Medical Centers",
"Health and Medical"
],
"neighborhoods": [
"South East LA"
]
}
我能够获取常规字段,但只有这些... 非常感谢您的帮助!