[
https://issues.apache.org/jira/browse/SOLR-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
chakming wong updated SOLR-4788:
--------------------------------
Description:
{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
was:
{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*
> 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
> Reporter: chakming wong
>
> {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]
