Hi, Thanks for this tip, Paul. But what if this is not an error. Is this what transformers should be used for somehow? Thanks, Otis ---- Sematext :: http://sematext.com/ :: Solr - Lucene - Nutch Lucene ecosystem search :: http://search-lucene.com/
----- Original Message ---- > From: Noble Paul നോബിള് नोब्ळ् <noble.p...@gmail.com> > To: solr-user@lucene.apache.org > Sent: Sun, April 25, 2010 9:16:22 AM > Subject: Re: DIH: inner select fails when outter entity is null/empty > > do an onError="skip" on the inner entity On Fri, Apr 23, 2010 at 3:56 AM, > Otis Gospodnetic < > href="mailto:otis_gospodne...@yahoo.com">otis_gospodne...@yahoo.com> > wrote: > Hello, > > Here is a newbie DataImportHandler > question: > > Currently, I have entities with entities. There are > some > situations where a column value from the outer entity is null, and > when I try to use it in the inner entity, the null just gets replaced with > an > empty string. That in turn causes the SQL query in the inner entity > to > fail. > > This seems like a common problem, but I > couldn't find any solutions or mention in the FAQ ( > href="http://wiki.apache.org/solr/DataImportHandlerFaq" target=_blank > >http://wiki.apache.org/solr/DataImportHandlerFaq ) > > What is > the best practice to avoid or convert null values to something safer? > Would > this be done via a Transformer or is there a better mechanism for > this? > > I think the problem I'm describing is similar to what was > described here: > >http://search-lucene.com/m/cjlhtFkG6m > ... except I don't have the > luxury of rewriting the SQL selects. > > Thanks, > > Otis > ---- > Sematext :: > target=_blank >http://sematext.com/ :: Solr - Lucene - Nutch > Lucene > ecosystem search :: > >http://search-lucene.com/ > > -- > ----------------------------------------------------- Noble Paul | > Systems Architect| AOL | > >http://aol.com