solr field not found

Question

I am new to Solr and have managed to upload about 500K rows from my SQL DB (*pardon my crude attempt at angle-brackets :-):

[lst name="statusMessages"]
       [str name="Total Requests made to DataSource">1</str]
       [str name="Total Rows Fetched">499999</str]
       [str name="Total Documents Skipped">0</str]
       [str name="Full Dump Started">2012-08-21 22:30:55</str]    
       [str name="">Indexing completed. Added/Updated: 499999 documents. Deleted 0 documents.</str]
       [str name="Committed">2012-08-21 22:31:18</str]
       [str name="Total Documents Processed">499999</str]
       [str name="Time taken">0:0:23.321</str]
 [/lst]

The schema for the associated content is:

[field name="tid" type="int" indexed="true" stored="true" /] 
[field name="ReviewAuthor" type="text_general" indexed="false" stored="true" /]
[field name="ReviewTitle" type="text_general" indexed="false" stored="true" /]         
[field name="ReviewText" type="text_general" indexed="true" stored="true" /] 
[field name="ReviewRating" type="float" indexed="true" stored="true" /] 
[field name="VersionNumber" type="text_general" indexed="true" stored="true" /]

However when I attempt to query for ReviewText or ReviewRating, no results are returned. tid on the other had is retrieved but none of the associated other fields are returned. Just tid + id.

Any suggestions I could try? thank you in advance.

Ankur

score 0 · Accepted Answer · edited May 23 '17 at 12:04

0

First check out what was actually indexed using Luke.

Then, if you're still unable to solve the problem, report back the findings.

edited May 23 '17 at 12:04

Community

1
1

answered Aug 22 '12 at 07:21

Marko Bonaci

5,622
2
34
55

thank you very much for the tip on Luke. I was unable to query any fields besides ID And TID. so I exported the entire index out to XML and it seems like it only has the ID and TID field related data, none of the other content is in there. As I have listed above - it does not seem that DataImport reported any errors...is there something else I can look into? – ankur Aug 22 '12 at 19:11
Can you give me an example of ReviewText and ReviewRating content? – Marko Bonaci Aug 23 '12 at 09:46
Are you sure your query is correct? Have you executed it directly in your RDB? – Marko Bonaci Aug 23 '12 at 09:52
ReviewText = free text (think of a on Amazon.com or comments on Engadget) ReviewRating - 1 to 5 scale (contains int = 1 through 5) Could you please elaborate what RDB is? I have tried to use the admin tool and Luke - both of them only show ID and TID fields being loaded. – ankur Aug 23 '12 at 15:51
RDB - your relational database. – Marko Bonaci Aug 24 '12 at 07:27
Yes I have and the data is all accounted for. Just takes far too long and hence wanted to move it over to Solr... – ankur Aug 24 '12 at 14:21
so I just discovered my oversight :-( the database field name had a space in it and was therefore failing on import. an additional issue that might have contributed is that the data query fields did not match up with the schema definition for the field. up and running now though - thank you very much for the suggestions. – ankur Aug 24 '12 at 17:09
Apologies for losing track of this thread. Thank you again for the help. – ankur Apr 06 '13 at 17:05

solr field not found

1 Answers1