Apache Solr DataImportHandler and Terms

[venkat <tv...@hotmail.com>]

Hi, 

I am using Apache Solr and my use case is as follows : 

I am using the Data Import Handler to read two columns from the database and
create a index using Solr. 
The data-config.xml and the schema.xml file is attached for your reference. 

The columns first_name has some null and empty values in the database, i am
using the PRTNR_ID (maps to branch_id) in the schema, as the unique key
since this column is defined as the PK in the table. Solr is able to process
these files and index them, the issue is when i issue a terms query to
search for first names i do not get any results. The terms query that i
issue is given below for your reference: 
  
http://localhost:8553/solr/terms?terms.fl=firstname&terms.sort=index

I do not get any results with this query but if i issue the following query 

http://localhost:8553/solr/terms?terms.fl=branch_id&terms.sort=index i do
get results, does it mean that if Solr indexes any field that contains null
or empty values it is not searchable via the terms component. I would
sincerely appreciate if anyone can point out on what is wrong with my
approach here. 

Thanks and Kind Regards 
Venkat 
http://lucene.472066.n3.nabble.com/file/n3059461/schema.xml schema.xml 
http://lucene.472066.n3.nabble.com/file/n3059461/data-config.xml
data-config.xml 

--
View this message in context: http://lucene.472066.n3.nabble.com/Apache-Solr-DataImportHandler-and-Terms-tp3059461p3059461.html
Sent from the Lucene - General mailing list archive at Nabble.com.