RE: Indexing boolean value

[kirsty <ki...@gmail.com>]

Michael Griffiths wrote:
> 
> Copyfield copies the field so you can have multiple versions. Useful to
> dump all fields into one "super" field you can search on, for perf
> reasons.
> 
> If the column isn't being indexed, I'd suggest the problem is in DIH. No
> suggestions as to why, I'm afraid.
> 
> -----Original Message-----
> From: PeterKerk [mailto:vetteparty@hotmail.com] 
> Sent: Wednesday, August 04, 2010 4:22 PM
> To: solr-user@lucene.apache.org
> Subject: RE: Indexing boolean value
> 
> 
> Hi,
> 
> I tried that already, so that would make this:
> 
> <field name="official" type="integer" indexed="true" stored="true"/>
> <copyField source="official" dest="text" />
> 
> (still not sure what copyField does though)
> 
> But even that wont work. I also dont see the officallocation columns
> indexed in the documents:
> http://localhost:8983/solr/db/select/?q=*%3A*&version=2.2&start=0&rows=10&indent=on
> 
> 
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Indexing-boolean-value-tp1023708p1023811.html
> Sent from the Solr - User mailing list archive at Nabble.com.
> 
> 
> 
> 


Hi there,
Has anyone managed to figure this out? I am hitting the same problem.

Thanks
Kirsty
-- 
View this message in context: http://lucene.472066.n3.nabble.com/Indexing-boolean-value-tp1023708p1405001.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: Indexing boolean value

[Lance Norskog <go...@gmail.com>]

It is possible that the DIH JDBC interface does not handle the MySQL 'bit' type.

In general, it is easiest to make a DB view for your DIH query. It
lets you see what the DHH gets, and the DIH syntax is easier.. You can
throw in a translator function there to turn a 'bit' into an integer.

On Thu, Sep 2, 2010 at 1:00 AM, kirsty <ki...@gmail.com> wrote:
>
>
> Michael Griffiths wrote:
>>
>> Copyfield copies the field so you can have multiple versions. Useful to
>> dump all fields into one "super" field you can search on, for perf
>> reasons.
>>
>> If the column isn't being indexed, I'd suggest the problem is in DIH. No
>> suggestions as to why, I'm afraid.
>>
>> -----Original Message-----
>> From: PeterKerk [mailto:vetteparty@hotmail.com]
>> Sent: Wednesday, August 04, 2010 4:22 PM
>> To: solr-user@lucene.apache.org
>> Subject: RE: Indexing boolean value
>>
>>
>> Hi,
>>
>> I tried that already, so that would make this:
>>
>> <field name="official" type="integer" indexed="true" stored="true"/>
>> <copyField source="official" dest="text" />
>>
>> (still not sure what copyField does though)
>>
>> But even that wont work. I also dont see the officallocation columns
>> indexed in the documents:
>> http://localhost:8983/solr/db/select/?q=*%3A*&version=2.2&start=0&rows=10&indent=on
>>
>>
>> --
>> View this message in context:
>> http://lucene.472066.n3.nabble.com/Indexing-boolean-value-tp1023708p1023811.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
>>
>>
>
>
> Hi there,
> Has anyone managed to figure this out? I am hitting the same problem.
>
> Thanks
> Kirsty
> --
> View this message in context: http://lucene.472066.n3.nabble.com/Indexing-boolean-value-tp1023708p1405001.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>



-- 
Lance Norskog
goksron@gmail.com