Are you committing after the run? Best Erick
On Fri, Nov 25, 2011 at 1:32 PM, Young, Cody <cody.yo...@move.com> wrote: > I don't see anything wrong so far other than a typo here (missing a p in > the second price): > <field column="lastbid_price" name="lastbid_rice" /> > > Can you see if there are any warnings in the log about documents not > being able to be created? > > Also, you should have a field type definition for text in your schema. > It will look something like > > <fieldtype name="text" class="solr.TextField" > positionIncrementGap="100"> > <analyzer type="index"> > > Can you send the full field type definition along as well? > > You can also try running a query like: > ?q=keyword_stock:[* TO *] > That will return any documents where keyword_stock is populated. > > Thanks, > Cody > > -----Original Message----- > From: jawedshamshedi [mailto:jawedshamsh...@gmail.com] > Sent: Thursday, November 24, 2011 9:42 PM > To: solr-user@lucene.apache.org > Subject: RE: Index a null text field > > Hi Cody, > > Thanks for the reply. > > Please find the detail of that I am doing. > > Yes, I am using dataimport handler and the code snippet of it from > solrconfig.xml is given below. > > <requestHandler name="/dataimport" > class="org.apache.solr.handler.dataimport.DataImportHandler"> > <lst name="defaults"> > <str name="config">data-config.xml</str> > </lst> > </requestHandler> > > The data-config.xml is give below. > > <dataConfig> > <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" > url="jdbc:mysql://localhost/database?zeroDateTimeBehavior=convertToNull" > user="username" password="password"/> > <document name="content"> > <entity name="auction" query="query(it's working file)"> > <field column="keyword" name="keyword_stock" /> > <field column="start_bidprice" > name="start_bidprice" /> > <field column="end_date" name="end_date" /> > <field column="start_date" name="start_date" /> > <field column="lastbid_price" > name="lastbid_rice" /> > > <field column="un_id" name="un_id" /> > > </entity> > </document> > </dataConfig> > > schema.xml > > > <fields> > > > <field name="un_id" type="string" indexed="true" stored="true" > required="true" /> > <field name="keyword_stock" type="text" indexed="true" > stored="true" /> > <field name="start_bidprice" type="tlong" indexed="true" > stored="true" /> > <field name="end_date" type="tdate" indexed="true" > stored="true" /> > <field name="start_date" type="tdate" indexed="true" > stored="true" /> > <field name="lastbid_price" type="tfloat" indexed="true" > stored="true" /> > > > </fields> > > > <uniqueKey>un_id</uniqueKey> > > > <defaultSearchField>ST_Name</defaultSearchField> > > he date type in mysql is given below. > > keyword text > start_bidprice float(12,2) > end_date datetime > start_bidprice float(12,2) > start_date datetime > > > for some fields that are simple float, there index are being created. I > also added this in data-config.xml's url > zeroDateTimeBehavior=convertToNull but no avail. > > Please help Thanks in advance. > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Index-a-null-text-field-tp3533636p353 > 5376.html > Sent from the Solr - User mailing list archive at Nabble.com. >
