下面是沙发底座文档`
{
"docId": "1111212",
"user": {
"id": "5050017",
"name": "string",
"type": "string"
},
"books": {
"1": {
"id": "1",
"name": "Book1",
"author":{
"id":"A1",
"name":"name"
}
}
"2": {
"id": "2",
"name": "Book2",
"author":{
"id":"A2",
"name":"name"
}
}
}
}
'我需要使用选择查询获取所有书籍名称我尝试了此操作
SELECT b.books.*.name FROM bucket_name b where meta().id like '%books_details%' OFFSET 0 LIMIT 10
我能够得到所有的json键下的书籍,但不是字段下的每个Map。
SELECT OBJECT_NAMES(b.books)FROM bucket_name b where meta().id like '%books_details%' OFFSET 0 LIMIT 10
1条答案
按热度按时间qnzebej01#