Maybe if I were to say that the column user_id will become user_ids
that would clarify things?
user_id:2002+AND+created:[${**from}+TO+${until}]+data:more
becomes
user_id*s*:2002+AND+created:[${**from}+TO+${until}]+data:more
where I want 2002 to be an exact positive match on one of the user_ids
Right, a search for 442 would not match 1442.
-- Jack Krupansky
-Original Message-
From: z z
Sent: Friday, June 07, 2013 2:18 AM
To: solr-user@lucene.apache.org
Subject: Re: Schema Change: Int - String (i am the original poster, new
email address)
Maybe if I were to say
: Schema Change: Int - String
1) If I change one field's type in my schema, will that cause problems with
the index or searching? My data is pulled in chunks off of a mysql server
so one field in the currently indexed data is simply an int type field in
solr. I would like to change this to a string
3. Too hard to say from the way you have described it. Show us some sample
input.
Jack,
Here you go.
*Row X*
column1: data here
column2: more data here
...
user_id: 2002
*Row Y*
column1: data here
column2: more data here
...
user_id: 45
*Row Z*
column1: data here
column2: more data here
...
I want to query against one user_id in the string.
eg user_id:2002+AND+created:[${from}+TO+${until}]+data:more
So all of the records with a 2002 in user_id need to be returned and only
those records. If this can only be guaranteed by having user_id be an
integer, then that is fine, but I would
-Original Message-
From: z z
Sent: Thursday, June 06, 2013 11:31 PM
To: solr-user@lucene.apache.org
Subject: Re: Schema Change: Int - String (i am the original poster, new
email address)
3. Too hard to say from the way you have described it. Show us some sample
input.
Jack,
Here you go
eg user_id:2002+AND+created:[${from}+TO+${until}]+data:more
Expected results: return row XYZ but ignore this row:
column1: data here
column2: more data here
...
user_id: 45 15001 45664
*Row X*
column1: data here
column2: more data here
...
user_id: 2002
*Row Y*
column1: data here
Subject: Re: Schema Change: Int - String (i am the original poster, new
email address)
I want to query against one user_id in the string.
eg user_id:2002+AND+created:[${from}+TO+${until}]+data:more
So all of the records with a 2002 in user_id need to be returned and only
those records
The unique key is an auto-incremented int in the db. Sorry for having
given the impression that user_id is the unique key per document. This is
a table of events that are happening as users interact with our system.
It just so happens that we were inserting individual records for each user
really mean by user id.
-- Jack Krupansky
-Original Message-
From: z z
Sent: Friday, June 07, 2013 12:11 AM
To: solr-user@lucene.apache.org
Subject: Re: Schema Change: Int - String (i am the original poster, new
email address)
The unique key is an auto-incremented int in the db
by user id.
-- Jack Krupansky
-Original Message- From: z z
Sent: Friday, June 07, 2013 12:11 AM
To: solr-user@lucene.apache.org
Subject: Re: Schema Change: Int - String (i am the original poster, new
email address)
The unique key is an auto-incremented int in the db. Sorry
1) If I change one field's type in my schema, will that cause problems with
the index or searching? My data is pulled in chunks off of a mysql server
so one field in the currently indexed data is simply an int type field in
solr. I would like to change this to a string moving forward, but still
On 6/5/2013 11:25 PM, TwoFirst TwoLast wrote:
1) If I change one field's type in my schema, will that cause problems with
the index or searching? My data is pulled in chunks off of a mysql server
so one field in the currently indexed data is simply an int type field in
solr. I would like to
13 matches
Mail list logo