[SOLR-4788] Multiple Entities DIH delta import: dataimporter.[entityName].last_index_time is empty

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.2, 4.3
• Fix Version/s: 4.4, 6.0
• Component/s: contrib - DataImportHandler

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

• Assignee: Shalin Shekhar Mangar
• Reporter: chakming wong
• Created: 06/May/13 07:47
• Updated: 09/May/16 18:51
• Resolved: 08/Jul/13 11:25

Description

conf/dataimport.properties

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

conf/solrconfig.xml

<?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>
...

conf/dihconfig.xml

<?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>

 

In above setup, dataimporter.entity1.last_index_time is empty string and cause the sql query having error

Issue Links

• relates to: SOLR-4848 contrib tests do not configure log4j