fatih created SOLR-6558:
---------------------------
Summary: solr does not insert the first line in the csv file
Key: SOLR-6558
URL: https://issues.apache.org/jira/browse/SOLR-6558
Project: Solr
Issue Type: Bug
Components: Build, clients - java, contrib - DataImportHandler
Affects Versions: 4.7.2
Environment: 4.7.2 solr , windows 7 and java version is 1.7.0_25
Reporter: fatih
Fix For: 4.7.2
link for stackoverflow as well
http://stackoverflow.com/questions/26000623/solr-does-not-insert-the-first-line-in-the-csv-file
When a csv file is uploaded over curl command as below
C:\>curl
"http://localhost:8983/solr/update/csv?commit=true&stream.file=C:\dev\tools\solr-4.7.2\data.txt&stream.contentType=text/csv&header=false&fieldnames=id,cat,pubyear_i,title,author,
series_s,sequence_i&skipLines=0"
and data.txt content is as below
book1,fantasy,2000,A Storm of Swords,George R.R. Martin,A Song of Ice and
Fire,3
book2,fantasy,2005,A Feast for Crows,George R.R. Martin,A Song of Ice and
Fire,4
book3,fantasy,2011,A Dance with Dragons,George R.R. Martin,A Song of Ice
and Fire,5
book4,sci-fi,1987,Consider Phlebas,Iain M. Banks,The Culture,1
book5,sci-fi,1988,The Player of Games,Iain M. Banks,The Culture,2
book6,sci-fi,1990,Use of Weapons,Iain M. Banks,The Culture,3
book7,fantasy,1984,Shadows Linger,Glen Cook,The Black Company,2
book8,fantasy,1984,The White Rose,Glen Cook,The Black Company,3
book9,fantasy,1989,Shadow Games,Glen Cook,The Black Company,4
book10,sci-fi,2001,Gridlinked,Neal Asher,Ian Cormac,1
book11,sci-fi,2003,The Line of Polity,Neal Asher,Ian Cormac,2
book12,sci-fi,2005,Brass Man,Neal Asher,Ian Cormac,3
first data in data.txt file is not being inserted to Solr which its id is
"book1". Can someone please tell why?
http://localhost:8983/solr/query?q=id:book1
{
"responseHeader":{
"status":0,
"QTime":1,
"params":{
"q":"id:book1"}},
"response":{"numFound":0,"start":0,"docs":[]
}}
Solr logs already tells that book1 is being added.
15440876 [searcherExecutor-5-thread-1] INFO org.apache.solr.core.SolrCore
û [collection1] Registered new searcher Searcher@177fcdf1[collection1]
main{StandardDirectoryReader(segments_1g:124:nrt _z(4.7):C12)}
15440877 [qtp84034882-11] INFO
org.apache.solr.update.processor.LogUpdateProcessor û [collection1]
webapp=/solr path=/update
params={fieldnames=id,cat,pubyear_i,title,author,series_s,sequence_i&skipLines=0&commit=true&stream.con
tentType=text/csv&header=false&stream.file=C:\dev\tools\solr-4.7.2\data.txt}
{add=[?book1 (1480070032327180288), book2 (1480070032332423168), book3
(1480070032335568896), book4 (1480070032337666048), book5
(1480070032339763200), b
ook6 (1480070032341860352), book7 (1480070032343957504), book8
(1480070032347103232), book9 (1480070032349200384), book10
(1480070032351297536), ... (12 adds)],commit=} 0 92
If I ask for all data then below you can also see book1 is still missing
http://localhost:8983/solr/query?q=id:book*&sort=pubyear_i+desc&fl=id,title,pubyear_i&rows=15
{
"responseHeader":{
"status":0,
"QTime":1,
"params":{
"fl":"id,title,pubyear_i",
"sort":"pubyear_i desc",
"q":"id:book*",
"rows":"15"}},
"response":{"numFound":11,"start":0,"docs":[
{
"id":"book3",
"pubyear_i":2011,
"title":["A Dance with Dragons"]},
{
"id":"book2",
"pubyear_i":2005,
"title":["A Feast for Crows"]},
{
"id":"book12",
"pubyear_i":2005,
"title":["Brass Man"]},
{
"id":"book11",
"pubyear_i":2003,
"title":["The Line of Polity"]},
{
"id":"book10",
"pubyear_i":2001,
"title":["Gridlinked"]},
{
"id":"book6",
"pubyear_i":1990,
"title":["Use of Weapons"]},
{
"id":"book9",
"pubyear_i":1989,
"title":["Shadow Games"]},
{
"id":"book5",
"pubyear_i":1988,
"title":["The Player of Games"]},
{
"id":"book4",
"pubyear_i":1987,
"title":["Consider Phlebas"]},
{
"id":"book7",
"pubyear_i":1984,
"title":["Shadows Linger"]},
{
"id":"book8",
"pubyear_i":1984,
"title":["The White Rose"]}]
}}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
