i need to import data from sql server and cassandra
first, get user ids from sql server
then get one user's characters from cassandra by user id
last, save the users characters doc into solr
one user have multi charcters
and i need to save the doc like
1040.txt
row uniqueid=10031016578048 passportid=1040 character=Ranea/
row uniqueid=10031016578049 passportid=1040 character=assinissa/
row uniqueid=1005101793120 passportid=1040 character=AmmSmashYous/
row uniqueid=1005101793121 passportid=1040 character=Dangless/
row uniqueid=1007102768032 passportid=1040 character=sees/
row uniqueid=10131031905 passportid=1040 character=Loopz/
row uniqueid=10131031907 passportid=1040 character=MyLongName/
row uniqueid=10141031680 passportid=1040 character=Rawr/
row uniqueid=10261043118 passportid=1040 character=Firebald/
row uniqueid=10191054480 passportid=1040 character=salt/
19734880.txt
row uniqueid=10091011208112 passportid=19734880 character=3Negreteo
/
row uniqueid=10091011208113 passportid=19734880 character=3BlaKin /
field uniqueid is character id
field passportid is user id
field character is character name
i write the DIH config like the following
dataConfig
dataSource name=mssql
driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://localhost:1433;databaseName=pw_account;
/
dataSource name=url type=URLDataSource /
dataSource name=reader type=FieldReaderDataSource /
document
entity name=user dataSource=mssql
query=SELECT top 100 id FROM pw_account..account
entity name=line dataSource=url
processor=LineEntityProcessor
url=http://localhost/${user.id}.txt;
format=text encoding=UTF-8 connectionTimeout=5000
readTimeout=10
entity name=xml dataSource=reader
processor=XPathEntityProcessor
dataField=line.rawLine forEach=/row
rootEntity=false
field column=id name=id xpath=/row/@uniqueid /
field column=character name=character
xpath=/row/@character /
field column=passportid name=passportid
xpath=/row/@passportid /
/entity
/entity
/entity
/document
/dataConfig
but it doesn't work
i got the result in csv format like this
id,passportid,character
1,1040,Ranea
2,,
3,,
4,,
only user_1040 's first character's is imported, and the imported ids are
all wrong
how to write the correct DIH config?
regards
--
View this message in context:
http://lucene.472066.n3.nabble.com/how-to-import-product-of-entity-date-with-DIH-tp3990694.html
Sent from the Solr - User mailing list archive at Nabble.com.
