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.
