Yes I got that. But I am still stuck at this point. Consider it like this:
I do not know what are the usernames in all the documents.
I only know there is time associated with each record.
So Say, I have usernames "a", "b", "c", "d" present in my data for the 18th
of January.
And for the 19th, I have usernames "a", "b","c", "d", "e".
Then my query for newly observed username for today over last two days
should return me "e"
Keep in my I can query only using "starttimeIso".
On Tue, Jan 20, 2015, 1:20 AM Alvaro Cabrerizo <topor...@gmail.com> wrote:
> Hi Harish,
>
> What I was requesting you in my previous mail was to try (yourself) to
> understand your data using specific queries. Apart from that, remember that
> facet is doing over indexed data thus if you have two documents with nameA
> as "user A" and nameB as "user B", and they are tokenized.... you will have
> 3 different facets (not two): *user*, *A* and *B*.
>
> Regards.
>
> On Tue, Jan 20, 2015 at 10:05 AM, harish singh <harish.sing...@gmail.com>
> wrote:
>
> > I am not querying for a specific usernames.
> > Each day, there will be many usernames observed at different times.
> > But there might be some usernames that were never seen in the last 30
> days,
> > but they were observed today.
> > That is the main challenge I am having.
> >
> > How to identify which usernames from today were not seen in the last 30
> > days.
> >
> > On Tue, Jan 20, 2015, 1:02 AM Alvaro Cabrerizo <topor...@gmail.com>
> wrote:
> >
> > > Ok,
> > >
> > > Thus as commented before, in case your starttimeISO is single-value you
> > > only need to add the range clause: startTimeISO:["2015-01-19T00:
> > > 00:00.000Z" TO "2015-01-20T00:00:00.000Z"]". There is no need to add
> both
> > > NOT A AND B as the documents that satisfy B will automatically satisfy
> A.
> > >
> > > If you query:
> > >
> > > q: username:bla
> > >
> > > How many documents do you have? where they observed at different
> > > starttimeISO (I mean maybe you have different documents with similar
> > names
> > > that where observed in different times?
> > >
> > > Regards.
> > >
> > >
> > >
> > >
> > >
> > > On Tue, Jan 20, 2015 at 9:45 AM, harish singh <
> harish.sing...@gmail.com>
> > > wrote:
> > >
> > > > Every entry in the document has a username, starttimeISO and uuid
> > (which
> > > is
> > > > not starttimeiso)
> > > >
> > > > So every record has a starttimeISO which is the time when the
> username
> > > was
> > > > seen.
> > > >
> > > > The document looks like this:
> > > > {
> > > > Uuid: xxx
> > > > StartTimeISO: 2015-01-18T00:00:00.000Z
> > > > Username: abc
> > > > }
> > > >
> > > > There are multiple records in the document.
> > > > Indexing is applied on "username" and "starttimeiso" fields.
> > > >
> > >
> >
>
