Thanks Alvaro. That worked.
On Tue, Jan 20, 2015 at 9:59 AM, harish singh
wrote:
> ok. So I am trying this query:
>
>
> http://cluster1.com:8983/solr/my_collection_shard4_replica1/select?q=*%3A*&rows=0&wt=json&indent=true&facet=true&facet.field=userName&fq=startTimeISO:[NOW-1DAY%20TO%20NOW]&fq=-
ok. So I am trying this query:
http://cluster1.com:8983/solr/my_collection_shard4_replica1/select?q=*%3A*&rows=0&wt=json&indent=true&facet=true&facet.field=userName&fq=startTimeISO:[NOW-1DAY%20TO%20NOW]&fq=-_query_:%22{!join%20from=%
userName%20to=%userName}startTimeISO:[NOW-30DAYS%20TO%20NOW-1DA
Hi,
In case your data looks like:
"id": "1",
"userName": "one",
"startTimeISO": "2015-01-20T17:24:32.888Z"
"id": "2",
"userName": "one",
"startTimeISO": "2015-01-16T17:24:50.208Z"
"id": "3",
"userName": "two",
"startTimeISO": "2015-01-20T17:25:06.109Z"
You could use the next query combination
Well, that is the problem I am facing. Just checking if there is a way to
compute the diff from 18th for the 19th.
One option is:
Get all the facets for 19th.
Get all facets for 18th.
Do a diff and Eliminate intersection.
But this isn't optimal as the number of facets returned but solr query can
b
On 1/20/2015 8:52 AM, harish singh wrote:
> 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
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 h
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
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 tod
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 q
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 recor
DAY-1DAYS TO NOW]
> > fl= id,userName, startTimeISO
> >
> >
> > Hope it helps.
> >
> >
> >
> >
> >
> > On Tue, Jan 20, 2015 at 5:09 AM, harish singh
> > wrote:
> >
> > > Hi,
> > >
> > > I have asked a
t; name bla doesnt appear in different documents. For example usin:
>
> query: userName:bla
> fq=startTimeISO:[NOW/DAY-1DAYS TO NOW]
> fl= id,userName, startTimeISO
>
>
> Hope it helps.
>
>
>
>
>
> On Tue, Jan 20, 2015 at 5:09 AM, harish singh
> wrote:
>
ked a question on Stackoverflow:
> http://stackoverflow.com/questions/28036051/solr-newly-observed-facets
>
> I searched the mailing list and found that not many reply there. So asking
> the same question here:
>
> have two fields in my solr index data: "userName" and &qu
Hi,
I have asked a question on Stackoverflow:
http://stackoverflow.com/questions/28036051/solr-newly-observed-facets
I searched the mailing list and found that not many reply there. So asking
the same question here:
have two fields in my solr index data: "userName" and "star
14 matches
Mail list logo
