Hello,
I am a newbie in this Solr world and I am getting surprised because I try to
do searches, both with the browser interface and by using a Java client and
the expected results do not appear.
The issue is:
1) I have set up an entity called "via" in my data-config.xml with 5 fields.
I do the full-import and it indexes
1.5M records:
<entity name="via" query="select TVIA, NVIAC, CMUM, CVIA, CPRO from
INE_VIAS">
<field column="TVIA" name="TVIA" />
<field column="NVIAC" name="NVIAC" />
<field column="CMUM" name="CMUM" />
<field column="CVIA" name="CVIA" />
<field column="CPRO" name="CPRO" />
</entity>
2) These 5 fields are mapped in the schema.xml, this way:
<field name="TVIA" type="text_general" indexed="true" stored="true" />
<field name="NVIAC" type="text_general" indexed="true" stored="true" />
<field name="CMUM" type="text_general" indexed="true" stored="true" />
<field name="CVIA" type="string" indexed="true" stored="true" />
<field name="CPRO" type="int" indexed="true" stored="true" />
3) I try to do a search for "Alcala street in Madrid":
NVIAC:ALCALA AND CPRO:28 AND CMUM:079
But it does just get two results (none of them, the desired one):
<doc><str name="CMUM">079</str><int name="CPRO">28</int><str
name="CVIA">45363</str><str name="NVIAC">ALCALA
GAZULES</str><str name="TVIA">CALLE</str></doc>
<doc><str name="CMUM">079</str><int name="CPRO">28</int><str
name="CVIA">08116</str><str name="NVIAC">ALCALA
GUADAIRA</str><str name="TVIA">CALLE</str></doc>
4) When I do the indexing by delimiting the entity search:
<entity name="via" query="select TVIA, NVIAC, CMUM, CVIA, CPRO from INE_VIAS
WHERE NVIAC LIKE '%ALCALA%'">
The full import does 913 documents and I do the same search, but this time I
get the desired result:
<doc><str name="CMUM">079</str><int name="CPRO">28</int><str
name="CVIA">00132</str><str name="NVIAC">ALCALA</str><str
name="TVIA">CALLE</str></doc>
Anyone can help me with that? I don't know why it does not work as expected
when I do the full-import of the whole lot of streets.
Thanks a lot in advance.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Not-getting-the-expected-search-results-tp3684974p3684974.html
Sent from the Solr - User mailing list archive at Nabble.com.
