Hi,
I am a newbie to Solr and have been trying to learn using
DataImportHandler.
I have a query in data-config.xml that fetches about 5 records when i fire
it in SQL Query manager.
However, when Solr does a full import, it is skipping 4 records and only
importing 1 record.
What could be the reason for that. ?
My data-config.xml looks like this -
<dataConfig>
<dataSource type="JdbcDataSource"
name="GeoService"
driver="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://10.168.50.104/ZipCodeLookup"
user="sa"
password="psiuser"/>
<document>
<entity name="city"
query="select ll.cityId as id, ll.zip as zipCode, c.cityName as
cityName, st.stateName as state, ct.countryName as country from latlonginfo
ll,city c, state st, country ct where ll.cityId = c.cityID and
c.stateID=st.stateID and st.countryID = ct.countryID
order by ll.areacode"
dataSource="GeoService">
<field column="zipCode" name="zipCode"/>
<field column="cityName" name="cityName"/>
<field column="state" name="state"/>
<field column="country" name="country"/>
</entity>
</document>
</dataConfig>
My fields definition in schema.xml looks as below -
<field name="CityName" type="text_general" indexed="true" stored="true" />
<field name="zipCode" type="text_general" indexed="true" stored="true"/>
<field name="state" type="text_general" indexed="true" stored="true" />
<field name="country" type="text_general" indexed="true" stored="true" />
One observation I made was the 1 record that is being indexes is the last
record in the result set. I have verified that there are no duplicate
records being retreived.
For eg, if the result set from Database is -
zipcode CityName state country
------- --------- ----- -------
91324 Northridge CA USA
91325 Northridge CA USA
91327 Northridge CA USA
91328 Northridge CA USA
91329 Northridge CA USA
91330 Northridge CA USA
The record being indexed is the last record all the time.
Any suggestions are welcome.
Thanks,
Anand
