Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
4.2, 4.3
-
None
-
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:34OR
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:14solr-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
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
Attachments
Attachments
Issue Links
- relates to
-
SOLR-4848 contrib tests do not configure log4j
- Open
Same issue
solr-spec
4.1.0.2013.01.16.17.21.36
solr-impl
4.1.0 1434440 - sarowe - 2013-01-16 17:21:36
lucene-spec
4.1.0