Hi,
I get unnecessary data when I run a self joining query.
Dataset
Key: post.1
Content:
{
"name": "post 1"
}
Key: like.1
Content:
{
"postId": "post.1"
}
Key: like.2
Content:
{
"postId": "post.1"
}
Query: select * from default default1 join default default2 on keys default1.postId
Output:
"results": [
{
"default1": {
"postId": "post.1"
},
"default2": {
"name": "post 1"
}
},
{
"default1": {
"postId": "post.1"
},
"default2": {
"name": "post 1"
}
}
],
How do I avoid having “default1” ?
I only want to get content from post.1 document.