Hi I have a requirement where I have a large scale data and each record has a mandatory visitorId field and one or more optional dimension and records of same visitorId can come after few days time gap.So I have records in system like visitorId1,Timestamp1,Dim1=val1 visitorId1,Timestamp1+20days,Dim2=val2
Now I have a requirement to count distinct visitorIds where Dim1=val1 and Dim2=val2(i.,e any row of same visitor has Dim1=val1 and any row of same vsisitor has Dim2=val2). Can I do grpupBy visitorId and filter on 2 dimensions Dim=val1 and Dim2=val2 both being in separate row and count on visitorId . Since druid needs Timestamp in each event so I used currentTs for that. Will this return result as 1. Or druid is not for OLTP processimg?
