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 <aboxfortheotherst...@gmail.com> 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:ml-node+740624-966329660-124...@n3.nabble.com] > 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 > 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-tp740624p740634.html > Sent from the Solr - User mailing list archive at Nabble.com. >
