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 sahid <sa...@neteck-fr.com> on 2009/10/20 15:02:17 UTC

Solr and bitwise comparaison

Hello,

I have a problem :)

I search to make a request in solr similaire are "SELECT COUNT(*) FROM
InscriptionNew WHERE choices & 17 > 0;" into mysql.
it is possible, you have an idea ?

Thanks

-- 
~sahid

Re: Solr and bitwise comparaison

Posted by Chris Hostetter <ho...@fucit.org>.

: I search to make a request in solr similaire are "SELECT COUNT(*) FROM
: InscriptionNew WHERE choices & 17 > 0;" into mysql.
: it is possible, you have an idea ?

bitmask operations in DB queries like that are usually a result of using a 
single physical column to store many logical boolean columns -- either out 
of space concerns or as a way to pre-allocate boolean fields for later use 
without needing to add columns.

In Solr: just use a BoolField for each bit.




-Hoss