[jira] [Commented] (SOLR-4788) Multiple Entities DIH delta import: dataimporter.[entityName].last_index_time is empty
[
https://issues.apache.org/jira/browse/SOLR-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13701938#comment-13701938
]
ASF subversion and git services commented on SOLR-4788:
---
Commit 1500652 from sha...@apache.org
[ https://svn.apache.org/r1500652 ]
SOLR-4788: Multiple Entities DIH delta import:
dataimporter.[entityName].last_index_time is empty
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
Attachments: entitytest.patch, entitytest.patch, entitytest.patch,
entitytest.patch, entitytest.patch, SOLR-4788.patch
{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=configdihconfig.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: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Commented] (SOLR-4788) Multiple Entities DIH delta import: dataimporter.[entityName].last_index_time is empty
[
https://issues.apache.org/jira/browse/SOLR-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13701944#comment-13701944
]
Shalin Shekhar Mangar commented on SOLR-4788:
-
[~elyograg] - Can you please open a separate issue for the logging
configuration?
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
Attachments: entitytest.patch, entitytest.patch, entitytest.patch,
entitytest.patch, entitytest.patch, SOLR-4788.patch
{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=configdihconfig.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: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Commented] (SOLR-4788) Multiple Entities DIH delta import: dataimporter.[entityName].last_index_time is empty
[
https://issues.apache.org/jira/browse/SOLR-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13699108#comment-13699108
]
Bill Bell commented on SOLR-4788:
-
We are also running into this issue. Not sure how it happens yet though.
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
Attachments: entitytest.patch, entitytest.patch, entitytest.patch,
entitytest.patch, entitytest.patch
{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=configdihconfig.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: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Commented] (SOLR-4788) Multiple Entities DIH delta import: dataimporter.[entityName].last_index_time is empty
[
https://issues.apache.org/jira/browse/SOLR-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13674395#comment-13674395
]
Shawn Heisey commented on SOLR-4788:
Arun Rangarajan posted to solr-user that he was running into this problem on an
upgrade from 3.6.2 to 4.2.1, so now we know that it worked properly in the 3.x
versions.
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
Attachments: entitytest.patch, entitytest.patch, entitytest.patch,
entitytest.patch, entitytest.patch
{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=configdihconfig.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: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Commented] (SOLR-4788) Multiple Entities DIH delta import: dataimporter.[entityName].last_index_time is empty
[
https://issues.apache.org/jira/browse/SOLR-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13663406#comment-13663406
]
Shawn Heisey commented on SOLR-4788:
After I wrote that last comment, it occurred to me that the test might in fact
be doing what it's supposed to be doing - failing because of the bug. I can't
actually tell, because the logging config isn't right for the test that I
copied, so it's not right for my test. I'm going to see whether I can figure
out how to get log4j configured.
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
Attachments: entitytest.patch
{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=configdihconfig.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: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Commented] (SOLR-4788) Multiple Entities DIH delta import: dataimporter.[entityName].last_index_time is empty
[
https://issues.apache.org/jira/browse/SOLR-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13662253#comment-13662253
]
Shawn Heisey commented on SOLR-4788:
A review of all Solr issues that mention last_index_time turns up SOLR-4051
(via SOLR-1970) as a possible candidate for the commit that broke this
functionality. This assumes of course that it worked after the feature was
added by SOLR-783, which is probably a safe assumption.
SOLR-4051 says that it patches functionality that was introduced to 3.6. I
think that was added by SOLR-2382, so it might have been SOLR-2382 that broke
things.
If I get some time in the near future I will attempt to write a test that
illustrates the bug, and see if I can run that test on 3.6 as well. If anyone
out there can try a manual test on 3.6, that would save some time.
Side note: the code uses two constants for last_index_time - LAST_INDEX_TIME
and LAST_INDEX_KEY. Those should probably be combined.
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=configdihconfig.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: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Commented] (SOLR-4788) Multiple Entities DIH delta import: dataimporter.[entityName].last_index_time is empty
[
https://issues.apache.org/jira/browse/SOLR-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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=configdihconfig.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: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Commented] (SOLR-4788) Multiple Entities DIH delta import: dataimporter.[entityName].last_index_time is empty
[
https://issues.apache.org/jira/browse/SOLR-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13661496#comment-13661496
]
Bill Bell commented on SOLR-4788:
-
Has someone fixed this? I am not seeing a patch.
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=configdihconfig.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: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Commented] (SOLR-4788) Multiple Entities DIH delta import: dataimporter.[entityName].last_index_time is empty
[
https://issues.apache.org/jira/browse/SOLR-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13651992#comment-13651992
]
Eric commented on SOLR-4788:
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
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
{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=configdihconfig.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: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
