[
https://issues.apache.org/jira/browse/SOLR-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13661673#comment-13661673
]
Shawn Heisey commented on SOLR-4788:
------------------------------------
[~billnbell] I started looking into the code for a user on IRC. I got
incredibly lost and never did find the problem. I'm willing to take another
look, but I'll need guidance, and whoever could guide me would probably be able
to find the problem faster than I can.
> Multiple Entities DIH delta import: dataimporter.[entityName].last_index_time
> is empty
> --------------------------------------------------------------------------------------
>
> Key: SOLR-4788
> URL: https://issues.apache.org/jira/browse/SOLR-4788
> Project: Solr
> Issue Type: Bug
> Affects Versions: 4.2, 4.3
> Environment: solr-spec
> 4.2.1.2013.03.26.08.26.55
> solr-impl
> 4.2.1 1461071 - mark - 2013-03-26 08:26:55
> lucene-spec
> 4.2.1
> lucene-impl
> 4.2.1 1461071 - mark - 2013-03-26 08:23:34
> OR
> solr-spec
> 4.3.0
> solr-impl
> 4.3.0 1477023 - simonw - 2013-04-29 15:10:12
> lucene-spec
> 4.3.0
> lucene-impl
> 4.3.0 1477023 - simonw - 2013-04-29 14:55:14
> Reporter: chakming wong
> Assignee: Shalin Shekhar Mangar
>
> {code:title=conf/dataimport.properties|borderStyle=solid}entity1.last_index_time=2013-05-06
> 03\:02\:06
> last_index_time=2013-05-06 03\:05\:22
> entity2.last_index_time=2013-05-06 03\:03\:14
> entity3.last_index_time=2013-05-06 03\:05\:22
> {code}
> {code:title=conf/solrconfig.xml|borderStyle=solid}<?xml version="1.0"
> encoding="UTF-8" ?>
> ...
> <requestHandler name="/dataimport"
> class="org.apache.solr.handler.dataimport.DataImportHandler">
> <lst name="defaults">
> <str name="config">dihconfig.xml</str>
> </lst>
> </requestHandler>
> ...
> {code}
> {code:title=conf/dihconfig.xml|borderStyle=solid}<?xml version="1.0"
> encoding="UTF-8" ?>
> <dataConfig>
> <dataSource name="source1"
> type="JdbcDataSource" driver="com.mysql.jdbc.Driver"
> url="jdbc:mysql://*:*/*"
> user="*" password="*"/>
> <document name="strings">
> <entity name="entity1" pk="id" dataSource="source1"
> query="SELECT * FROM table_a"
> deltaQuery="SELECT table_a_id FROM table_b WHERE
> last_modified > '${dataimporter.entity1.last_index_time}'"
> deltaImportQuery="SELECT * FROM table_a WHERE id =
> '${dataimporter.entity1.id}'"
> transformer="TemplateTransformer">
> <field> ...
> ...
> ... </field>
> </entity>
> <entity name="entity2">
> ...
> ...
> </entity>
> <entity name="entity3">
> ...
> ...
> </entity>
> </document>
> </dataConfig>
> {code}
> In above setup, *dataimporter.entity1.last_index_time* is *empty string* and
> cause the sql query having error
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
