I’m going to make a table on the Mongolian DB chart.
When the same data and the same query are applied to Atlas and Data Lake, different results are obtained.
Can you tell me why?
Below is the query applied to the query bar.
[
{$group:{ '_id':{
uid:'$uid',date:'$date'
}
,'methods':{
'$addToSet':'$urlmethod'
}
}},
{$project:{
_id:1,methods:1,appuser:{$setDifference:[["POST_/v0.1/measure","POST_/v0.1/exercise"],{$ifNull:['$methods',[]]}]}
}},
{$set:{
exercise:{$cond:[{$in:["POST_/v0.1/measure",{$ifNull:['$appuser',[]]}]},1,0]}
}},
{$set:{
measure:{$cond:[{$in:["POST_/v0.1/exercise",{$ifNull:['$appuser',[]]}]},1,0]}
}},
{$set:{
all:{$cond:[{$eq:[{$size:{$ifNull:['$appuser',[]]}},0]},1,0]}
}},
{$set:{
notall:{$cond:[{$eq:[{$size:{$ifNull:['$appuser',[]]}},2]},1,0]}
}}
]
