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 <[email protected]> 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:[email protected]]
> 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
> [email protected]
> 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.
>
