I think it's working, it was the lack of the seemingly innocuous
sub-entity pk="application_id". After adding that I'm seeing some
data returned.
On Wed, Apr 21, 2010 at 10:44 AM, Jason Rutherglen
<jason.rutherg...@gmail.com> wrote:
> Something's off, for each row, it's performing the following 5
> sub-queries. Weird. Below is the updated data-config.xml (compared
> to the original email I changed the field from comment to added).
>
> <lst name="document#5">
> <str>----------- row #1-------------</str>
> <int name="id">876</int>
> <date name="updated">2009-11-02T06:36:28Z</date>
> <str>---------------------------------------------</str>
> -
> <lst name="entity:added">
> <str name="query">SELECT added FROM ratings WHERE app = 876</str>
> <str name="query">SELECT added FROM ratings WHERE app = 876</str>
> <str name="query">SELECT added FROM ratings WHERE app = 876</str>
> <str name="query">SELECT added FROM ratings WHERE app = 876</str>
> <str name="query">SELECT added FROM ratings WHERE app = 876</str>
> <str name="time-taken">0:0:0.0</str>
> <str name="time-taken">0:0:0.0</str>
> <str name="time-taken">0:0:0.0</str>
> <str name="time-taken">0:0:0.0</str>
> <str name="time-taken">0:0:0.0</str>
> <str>----------- row #1-------------</str>
> <date name="added">2010-01-26T18:08:53Z</date>
> <str>---------------------------------------------</str>
> <str>----------- row #2-------------</str>
> <date name="added">2010-01-27T20:16:20Z</date>
> <str>---------------------------------------------</str>
> <str>----------- row #3-------------</str>
> <date name="added">2010-01-29T00:02:40Z</date>
> <str>---------------------------------------------</str>
> <str>----------- row #4-------------</str>
> <date name="added">2010-02-01T16:59:42Z</date>
> <str>---------------------------------------------</str>
> </lst>
> </lst>
>
> <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 * FROM
> ratings WHERE app = ${applications.id}">
> <field name="comment" column="comment"/>
> <field name="added" column="added"/>
> </entity>
> </entity>
> </document>
> </dataConfig>
>
> On Wed, Apr 21, 2010 at 10:41 AM, caman <aboxfortheotherst...@gmail.com>
> wrote:
>>
>> 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.
>>
>
