[jira] [Comment Edited] (SOLR-12251) pk ids not sort when in deltaQuery

2018-04-21 Thread wzhonggo (JIRA) 

[ 
https://issues.apache.org/jira/browse/SOLR-12251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16446667#comment-16446667
 ] 

wzhonggo edited comment on SOLR-12251 at 4/21/18 7:29 AM:
--

Hi

I not search #SOLR-7952 before create this issue. This is my mistake.

I clone [lucene-solr|https://github.com/apache/lucene-solr] form github , 
change HashSet to LinkedHashSet , HashMap to LinkedHashMap. I reset version to 
7.1 branch and rebuild dataimporthandle.jar. Use new dataimporthandle.jar will 
correct. It is like 
[SOLR-7952.patch|https://issues.apache.org/jira/secure/attachment/12871122/SOLR-7952.patch]

 

I want to know why not use LinkedHashSet and LinkedHashMap. I am newer for solr.

Is there any other reason.

 

Thank you very much


was (Author: wzhonggo):
Hi

I not search #SOLR-7952 before create this issue. This is my mistake.

I clone [lucene-solr|https://github.com/apache/lucene-solr] form github , 
change HashSet to LinkedHashSet , HashMap to LinkedHashMap. I reset version to 
7.1 branch and rebuild dataimporthandle.jar. Use new dataimporthandle.jar will 
correct. It is like [SOLR-7952.patch|[^SOLR-7952.patch].]

 

I want to know why not use LinkedHashSet and LinkedHashMap. I am newer for solr.

Is there any other reason.

 

Thank you very much

> pk ids not sort when in deltaQuery 
> ---
>
> Key: SOLR-12251
> URL: https://issues.apache.org/jira/browse/SOLR-12251
> Project: Solr
>  Issue Type: Bug
>  Security Level: Public(Default Security Level. Issues are Public) 
>  Components: contrib - DataImportHandler
>Affects Versions: 7.1
> Environment: windows10
> Solr7.1
> JDK8
>  
>Reporter: wzhonggo
>Priority: Major
> Attachments: SOLR-12251.patch
>
>
> I use solr and mysql for search. 
>  
> {code:xml}
> // data-config.xml
> query="select * from score order by create_date asc"  
> deltaImportQuery="select * from score where id='${dih.delta.id}'" 
> deltaQuery="selectid from score where update_date > 
> '${dataimporter.last_index_time}' order by create_date asc "
> {code}
>  
>  Mysql has three rows data in *score* table
>  
> ||id||name||score||create_date||update_date||
> |UUID1|user1|60|2018-04-10|2018-04-10|
> |UUID2|user1|70|2018-04-11 |2018-04-11|
> |UUID3|user1|80|2018-04-12|2018-04-12|
> The expected results In solr doc
> ||Name||Score||CreateDate||UpdateDate||
> |user1|80|2018-04-12|2018-04-12|
>  
> Use full import it will correct , but use delta import will wrong.
> In the *org.apache.solr.handler.dataimport.DocBuilder* class ,  return not 
> LinkHashSet in 
> *collectDelta* method. 
>  
> Thanks.
>  
>  
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Commented] (SOLR-12251) pk ids not sort when in deltaQuery

2018-04-21 Thread wzhonggo (JIRA) 

[ 
https://issues.apache.org/jira/browse/SOLR-12251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16446667#comment-16446667
 ] 

wzhonggo commented on SOLR-12251:
-

Hi

I not search #SOLR-7952 before create this issue. This is my mistake.

I clone [lucene-solr|https://github.com/apache/lucene-solr] form github , 
change HashSet to LinkedHashSet , HashMap to LinkedHashMap. I reset version to 
7.1 branch and rebuild dataimporthandle.jar. Use new dataimporthandle.jar will 
correct. It is like [SOLR-7952.patch|[^SOLR-7952.patch].]

 

I want to know why not use LinkedHashSet and LinkedHashMap. I am newer for solr.

Is there any other reason.

 

Thank you very much

> pk ids not sort when in deltaQuery 
> ---
>
> Key: SOLR-12251
> URL: https://issues.apache.org/jira/browse/SOLR-12251
> Project: Solr
>  Issue Type: Bug
>  Security Level: Public(Default Security Level. Issues are Public) 
>  Components: contrib - DataImportHandler
>Affects Versions: 7.1
> Environment: windows10
> Solr7.1
> JDK8
>  
>Reporter: wzhonggo
>Priority: Major
> Attachments: SOLR-12251.patch
>
>
> I use solr and mysql for search. 
>  
> {code:xml}
> // data-config.xml
> query="select * from score order by create_date asc"  
> deltaImportQuery="select * from score where id='${dih.delta.id}'" 
> deltaQuery="selectid from score where update_date > 
> '${dataimporter.last_index_time}' order by create_date asc "
> {code}
>  
>  Mysql has three rows data in *score* table
>  
> ||id||name||score||create_date||update_date||
> |UUID1|user1|60|2018-04-10|2018-04-10|
> |UUID2|user1|70|2018-04-11 |2018-04-11|
> |UUID3|user1|80|2018-04-12|2018-04-12|
> The expected results In solr doc
> ||Name||Score||CreateDate||UpdateDate||
> |user1|80|2018-04-12|2018-04-12|
>  
> Use full import it will correct , but use delta import will wrong.
> In the *org.apache.solr.handler.dataimport.DocBuilder* class ,  return not 
> LinkHashSet in 
> *collectDelta* method. 
>  
> Thanks.
>  
>  
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

[jira] [Created] (SOLR-12251) pk ids not sort when in deltaQuery

2018-04-20 Thread wzhonggo (JIRA) 
wzhonggo created SOLR-12251:
---

 Summary: pk ids not sort when in deltaQuery 
 Key: SOLR-12251
 URL: https://issues.apache.org/jira/browse/SOLR-12251
 Project: Solr
  Issue Type: Bug
  Security Level: Public (Default Security Level. Issues are Public)
  Components: contrib - DataImportHandler
Affects Versions: 7.1
 Environment: windows10

Solr7.1

JDK8

 
Reporter: wzhonggo


I use solr and mysql for search. 

 
{code:xml}
// data-config.xml
query="select * from score order by create_date asc"  
deltaImportQuery="select * from score where id='${dih.delta.id}'" 
deltaQuery="selectid from score where update_date > 
'${dataimporter.last_index_time}' order by create_date asc "
{code}
 

 Mysql has three rows data in *score* table

 
||id||name||score||create_date||update_date||
|UUID1|user1|60|2018-04-10|2018-04-10|
|UUID2|user1|70|2018-04-11 |2018-04-11|
|UUID3|user1|80|2018-04-12|2018-04-12|

The expected results In solr doc
||Name||Score||CreateDate||UpdateDate||
|user1|80|2018-04-12|2018-04-12|

 

Use full import it will correct , but use delta import will wrong.

In the *org.apache.solr.handler.dataimport.DocBuilder* class ,  return not 
LinkHashSet in 

*collectDelta* method. 

 

Thanks.

 

 

 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org