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-tp3533636p3535376.html
Sent from the Solr - User mailing list archive at Nabble.com.
