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
