lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kaushik Chakraborty <kaych...@gmail.com>
Subject Re: SOLR DIH importing MySQL "text" column as a BLOB
Date Wed, 16 Mar 2011 16:20:47 GMT
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 <gora@mimirtech.com> wrote:

> On Wed, Mar 16, 2011 at 2:29 PM, Stefan Matheis
> <matheis.stefan@googlemail.com> 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, ',', lng ) AS CHAR )
> >
> > at that time i search a little bit for the reason and afaik there was
> > a bug in mysql/jdbc which produces that binary output under certain
> > conditions
> [...]
>
> As Stefan mentions, there might be a way to solve this.
>
> Could you show us the query in DIH that you are using
> when you get this BLOB, i.e., the SELECT statement
> that goes to the database?
>
> It might also be instructive for you to try that same
> SELECT directly in a mysql interface.
>
> Regards,
> Gora
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message