Re: SOLR DIH importing MySQL "text" column as a BLOB

2011-03-16 Thread Jayendra Patil
Hi Kaushik, If the field is being treated as blobs, you can try using the FieldStreamDataSource mapping. This handles the blob objects to extract contents from it. This feature is available only after Solr 3.1, I suppose. http://lucene.apache.org/solr/api/org/apache/solr/handler/dataimport/FieldS

Re: SOLR DIH importing MySQL "text" column as a BLOB

2011-03-16 Thread Gora Mohanty
On Wed, Mar 16, 2011 at 9:50 PM, Kaushik Chakraborty wrote: > The query's there in the data-config.xml. And the query's fetching as > expected from the database. [...] Doh! Sorry, had missed that somehow. So, the relevant part is: SELECT ... p.message as solr_post_message, What is the field typ

Re: SOLR DIH importing MySQL "text" column as a BLOB

2011-03-16 Thread Kaushik Chakraborty
The query's there in the data-config.xml. And the query's fetching as expected from the database. Thanks, Kaushik On Wed, Mar 16, 2011 at 9:21 PM, Gora Mohanty wrote: > On Wed, Mar 16, 2011 at 2:29 PM, Stefan Matheis > wrote: > > Kaushik, > > > > i just remembered an ML-Post few weeks ago ..

Re: SOLR DIH importing MySQL "text" column as a BLOB

2011-03-16 Thread Gora Mohanty
On Wed, Mar 16, 2011 at 2:29 PM, Stefan Matheis wrote: > Kaushik, > > i just remembered an ML-Post few weeks ago .. same problem while > importing geo-data > (http://lucene.472066.n3.nabble.com/Solr-4-0-Spatial-Search-How-to-tp2245592p2254395.html) > - the solution was: > >> CAST( CONCAT( lat, ','

Re: SOLR DIH importing MySQL "text" column as a BLOB

2011-03-16 Thread Stefan Matheis
Kaushik, i just remembered an ML-Post few weeks ago .. same problem while importing geo-data (http://lucene.472066.n3.nabble.com/Solr-4-0-Spatial-Search-How-to-tp2245592p2254395.html) - the solution was: > CAST( CONCAT( lat, ',', lng ) AS CHAR ) at that time i search a little bit for the reason

SOLR DIH importing MySQL "text" column as a BLOB

2011-03-15 Thread Kaushik Chakraborty
I've a column for posts in MySQL of type `text`, I've tried corresponding `field-type` for it in Solr `schema.xml` e.g. `string, text, text-ws`. But whenever I'm importing it using the DIH, it's getting imported as a BLOB object. I checked, this thing is happening only for columns of type `text` an