hello.
i have a problem!
first example.
{
"id":"A",
"itemlist":{
{
"itemunique":55,
"itemtype":1,
"count":5
},
{
"itemunique":56,
"itemtype":2,
"count":5
},
}
}
select a.* from [Bucket] unnest itemlist a where a.itemtype = 1;
it’s able.
second example.
{
"id":"A",
"itemdic":{
{
55:{
"itemtype":1,
"count":5
},
56:{
"itemtype":2,
"count":5
},
}
}
select a.* from [Bucket] unnest itemdic a where a.itemtype = 1;
it’s impossible!! ToT
error message:
"errors": [
{
"code": 3000,
"msg": "Ambiguous reference to field itemtype."
}
how can i fix it??
dictionary type is necessary. please help me…