You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Koji Sekiguchi (JIRA)" <ji...@apache.org> on 2010/11/30 17:44:12 UTC
[jira] Resolved: (SOLR-2252) when child entity is the root in
nested entities, delta-import doesn't work
[ https://issues.apache.org/jira/browse/SOLR-2252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Koji Sekiguchi resolved SOLR-2252.
----------------------------------
Resolution: Fixed
Assignee: Koji Sekiguchi
trunk: Committed revision 1040608.
branch_3x: Committed revision 1040629.
> when child entity is the root in nested entities, delta-import doesn't work
> ---------------------------------------------------------------------------
>
> Key: SOLR-2252
> URL: https://issues.apache.org/jira/browse/SOLR-2252
> Project: Solr
> Issue Type: Bug
> Components: contrib - DataImportHandler
> Affects Versions: 1.4.1
> Reporter: Koji Sekiguchi
> Assignee: Koji Sekiguchi
> Priority: Minor
> Fix For: 3.1, 4.0
>
> Attachments: SOLR-2252.patch, SOLR-2252.patch
>
>
> sample data-config.xml:
> {code}
> <dataConfig>
> <dataSource driver="org.postgresql.Driver"
> url="jdbc:postgresql://localhost/exercise" user="solr" password="solr" />
> <document>
> <entity name="team" query="select * from team" pk="team_id" rootEntity="false"
> deltaQuery="select team_id from team where last_modified > '${dih.last_index_time}'"
> deltaImportQuery="select * from team where team_id='${dih.delta.team_id}'">
> <field column="team_name" name="team"/>
> <field column="team_yard" name="yard"/>
> <entity name="team_athlete" pk="team_id" rootEntity="false"
> query="select athlete_id from team_athlete where team_athlete.team_id=${team.team_id}"
> deltaQuery="select distinct team_id from team_athlete where last_modified > '${dih.last_index_time}'"
> deltaImportQuery="select athlete_id from team_athlete where team_athlete.team_id=${dih.delta.team_id}"
> parentDeltaQuery="select team_id from team where team_id=${team_athlete.team_id}">
> <entity name="athlete" pk="athlete_id" rootEntity="true"
> query="select athlete_name from athlete where athlete_delflag='N' AND athlete.athlete_id=${team_athlete.athlete_id}"
> deletedPkQuery="select athlete_id from athlete where athlete_delflag='Y' AND last_modified > '${dih.last_index_time}'"
> deltaQuery="select athlete_id from athlete where athlete_delflag='N' AND last_modified > '${dih.last_index_time}'"
> deltaImportQuery="select athlete_name from athlete where athlete_delflag='N' AND athlete.athlete_id=${dih.delta.athlete_id}"
> parentDeltaQuery="select team_id from team_athlete where athlete_id=${athlete.athlete_id}">
> <field column="athlete_name" name="name"/>
> </entity>
> </entity>
> </entity>
> </document>
> </dataConfig>
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org