From general-return-3372-apmail-lucene-general-archive=lucene.apache.org@lucene.apache.org Mon Jun 13 16:36:05 2011 Return-Path: X-Original-To: apmail-lucene-general-archive@www.apache.org Delivered-To: apmail-lucene-general-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 977F5658E for ; Mon, 13 Jun 2011 16:36:05 +0000 (UTC) Received: (qmail 19496 invoked by uid 500); 13 Jun 2011 16:36:05 -0000 Delivered-To: apmail-lucene-general-archive@lucene.apache.org Received: (qmail 19433 invoked by uid 500); 13 Jun 2011 16:36:04 -0000 Mailing-List: contact general-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: general@lucene.apache.org Delivered-To: mailing list general@lucene.apache.org Received: (qmail 19425 invoked by uid 99); 13 Jun 2011 16:36:04 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Jun 2011 16:36:04 +0000 X-ASF-Spam-Status: No, hits=2.3 required=5.0 tests=FREEMAIL_FROM,RFC_ABUSE_POST,SPF_SOFTFAIL,T_TO_NO_BRKTS_FREEMAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: softfail (nike.apache.org: transitioning domain of tvenki@hotmail.com does not designate 216.139.236.26 as permitted sender) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Jun 2011 16:35:57 +0000 Received: from ben.nabble.com ([192.168.236.152]) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1QWA6z-0006kH-4V for general@lucene.apache.org; Mon, 13 Jun 2011 09:35:37 -0700 Date: Mon, 13 Jun 2011 09:35:37 -0700 (PDT) From: venkat To: general@lucene.apache.org Message-ID: <1307982937128-3059461.post@n3.nabble.com> Subject: Apache Solr DataImportHandler and Terms MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org 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.