Druid as a OLTP solution


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



Now I have a requirement to count distinct visitorIds where Dim1=val1 and 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?