You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by stockii <st...@googlemail.com> on 2011/01/28 17:06:05 UTC

field=string with value: 0, 1 and 2

Hello-


i am using shard-requests over several cores.
each core has his own index and own schema. but every core have the field
"status" !

regularly the status is 0 or 1. but one core can have the status: 0, 1 OR 2

--> the status field type i used is "string" but string make the cores (with
only 0 and 1 values) to boolean: true and false. the core wich can have
status 2 only indexing the value "0" "1" "2" ...

so i cannot filter with shard request over these cores, because solr cannor
find if you using status:true, when the field is "1" .......

how can i say to solr that he index the 0,1 values as integer and not
boolean ??? (fieldtype int shows the same behaviour)

?? thx


-----
------------------------------- System
----------------------------------------

One Server, 12 GB RAM, 2 Solr Instances, 7 Cores, 
1 Core with 31 Million Documents other Cores < 100.000

- Solr1 for Search-Requests - commit every Minute  - 4GB Xmx
- Solr2 for Update-Request  - delta every 2 Minutes - 4GB Xmx
-- 
View this message in context: http://lucene.472066.n3.nabble.com/field-string-with-value-0-1-and-2-tp2367038p2367038.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: field=string with value: 0, 1 and 2

Posted by stockii <st...@googlemail.com>.
i found the problem.

DIH or i think the JDBC-Driver casting 0 and 1 to boolean, if the field in
database from type (tinyint(1)).

iam using tow fields with type of tinyint(1) and tinyint(2) -.-

-----
------------------------------- System
----------------------------------------

One Server, 12 GB RAM, 2 Solr Instances, 7 Cores, 
1 Core with 31 Million Documents other Cores < 100.000

- Solr1 for Search-Requests - commit every Minute  - 4GB Xmx
- Solr2 for Update-Request  - delta every 2 Minutes - 4GB Xmx
-- 
View this message in context: http://lucene.472066.n3.nabble.com/field-string-with-value-0-1-and-2-tp2367038p2389508.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: field=string with value: 0, 1 and 2

Posted by stockii <st...@googlemail.com>.
i think DIH is the problem !? 

when i am using "int" as type for the fields, solr NumberFormatException
occurs - For input string: "false"


-----
------------------------------- System
----------------------------------------

One Server, 12 GB RAM, 2 Solr Instances, 7 Cores, 
1 Core with 31 Million Documents other Cores < 100.000

- Solr1 for Search-Requests - commit every Minute  - 4GB Xmx
- Solr2 for Update-Request  - delta every 2 Minutes - 4GB Xmx
-- 
View this message in context: http://lucene.472066.n3.nabble.com/field-string-with-value-0-1-and-2-tp2367038p2367053.html
Sent from the Solr - User mailing list archive at Nabble.com.