Hard to tell.
Did you try putting the child entity part of main query with subquery. Don't think that is the issue though but worth a try Select id, updated,( SELECT comment FROM ratings WHERE app = appParent.id) as comment FROM applications appParent limit 10 From: Jason Rutherglen [via Lucene] [mailto:ml-node+740680-1955771337-124...@n3.nabble.com] Sent: Wednesday, April 21, 2010 10:33 AM To: caman Subject: Re: Problem with DataImportHandler and embedded entities Caman, I'm storing it. This is what I see when DataImportHandler verbose is turned on. While the field names don't match, I am seeing that sub-queries are being performed, data is being returned. It's just not making it into the document. <lst name="verbose-output"> - <lst name="entity:applications"> - <lst name="document#1"> <str name="query">SELECT id, updated FROM applications limit 10</str> <str name="time-taken">0:0:0.9</str> <str>----------- row #1-------------</str> <int name="id">407</int> <date name="updated">2009-11-02T06:35:48Z</date> <str>---------------------------------------------</str> - <lst name="entity:added"> <str name="query">SELECT added FROM ratings WHERE app = 407</str> <str name="time-taken">0:0:0.8</str> </lst> </lst> On Wed, Apr 21, 2010 at 10:17 AM, caman <[hidden email] <http://n3.nabble.com/user/SendEmail.jtp?type=node&node=740680&i=0> > wrote: > > Are you storing the comment field or indexing it? > > <field .. Stored="false" ... > will not appear in the document. > > > > From: Jason Rutherglen [via Lucene] > [mailto:[hidden email] <http://n3.nabble.com/user/SendEmail.jtp?type=node&node=740680&i=1> ] > Sent: Wednesday, April 21, 2010 10:15 AM > To: caman > Subject: Problem with DataImportHandler and embedded entities > > > > I'm using the following data-config.xml with DataImportHandler. I've > never used embedded entities before however I'm not seeing the comment > show up in the document... I'm not sure what's up. > > <dataConfig> > <dataSource type="JdbcDataSource" name="ch" > driver="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1:3306/ch" > batchSize="-1" user="ch" password="ch_on_this"/> > <document name="ch"> > <entity name="applications" pk="id" dataSource="ch" > query="SELECT id, updated FROM applications limit 10"> > <entity name="comment" dataSource="ch" query="SELECT comment > FROM ratings WHERE app = ${applications.id}"> > <field name="comment" column="comment"/> > </entity> > </entity> > </document> > </dataConfig> > > > > _____ > > View message @ > http://n3.nabble.com/Problem-with-DataImportHandler-and-embedded-entities-tp > 740624p740624.html > To start a new topic under Solr - User, email > [hidden email] <http://n3.nabble.com/user/SendEmail.jtp?type=node&node=740680&i=2> > To unsubscribe from Solr - User, click > < (link removed) > yc3R1ZmZAZ21haWwuY29tfDQ3MjA2OHwtOTM0OTI1NzEx> here. > > > > > -- > View this message in context: http://n3.nabble.com/Problem-with-DataImportHandler-and-embedded-entities-tp 740624p740634.html > Sent from the Solr - User mailing list archive at Nabble.com. > _____ View message @ http://n3.nabble.com/Problem-with-DataImportHandler-and-embedded-entities-tp 740624p740680.html To start a new topic under Solr - User, email ml-node+472068-464289649-124...@n3.nabble.com To unsubscribe from Solr - User, click < (link removed) yc3R1ZmZAZ21haWwuY29tfDQ3MjA2OHwtOTM0OTI1NzEx> here. -- View this message in context: http://n3.nabble.com/Problem-with-DataImportHandler-and-embedded-entities-tp740624p740708.html Sent from the Solr - User mailing list archive at Nabble.com.
