Drilling with JS

Hey everybody,

when I look at my mongoDb I can't see any info to correlate events. Suppose I have a custom event with two fields: foo and bar and I want to get the number of events where foo = 1 && bar == 2. How do I do that with data that is structured like this:

{ 
    "_id" : "TIMESTAMP_2019:12_P", 
    "d" : {
        "10" : {
            "1" : {
                "c" : NumberInt(1)
            }
        }
    }, 
    "m" : "2019:12", 
    "s" : "foo"
}
{ 
    "_id" : "DURATION_2019:12_I", 
    "d" : {
        "10" : {
            "2" : {
                "c" : NumberInt(1)
            }
        }
    }, 
    "m" : "2019:12", 
    "s" : "bar"
}

The "drill" module seems to be able to do it, generating queries like

{"event":"event","dbFilter":{"sg.foo":{"$in":[1]},"sg.bar":{"$in":[2]},"byVal":""}
0

Comments

3 comments
  • In the standard aggregated data model, you cannot correlate them, data can be viewed only from a single property perspective (which is encoded in _id)
    for multi-field correlation you must use drill

    0
    Comment actions Permalink
  • Thanks for the reply!

    for multi-field correlation you must use drill

    Do you mean "to do this programatically you need to be a enterprise customer" or "even if you are a enterprise customer you can only do this using drill".

    0
    Comment actions Permalink
  • Community edition only has aggregated data, so all segments are stored separately, and there is no way to tie them together.
    While Enterprise edition stores granular data and you can query that data almost any way you like.
    So I guess, yes, to do this even programmatically, you need to be an enterprise customer (mostly for the drill feature)

    0
    Comment actions Permalink

Please sign in to leave a comment.