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 <kirst...@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:vettepa...@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 goks...@gmail.com
