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 <g...@mimirtech.com> wrote: > On Wed, Mar 16, 2011 at 2:29 PM, Stefan Matheis > <matheis.ste...@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 >