Hi Shushant, Druid is definitely not intended for OLTP processing. It's generally meant for storing, querying, and analyzing event streams. Check out http://druid.io/ for some more info about what Druid is good at.
On Sat, Aug 18, 2018 at 10:19 PM Shushant Arora <shushantaror...@gmail.com> wrote: > 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? >