Thank you everyone, I think COALESCE(duration, 0) and ISNULL will solve my
problem.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Replace-NULL-with-0-while-Indexing-tp4095059p4095678.html
Sent from the Solr - User mailing list archive at Nabble.com.
On 10/11/2013 3:02 PM, keshari.prerna wrote:
One of my indexing field have NULL values and i want it to be replaces with
0 while indexing itself. So that when i search after indexing it gives me 0
instead of NULL.
Most of your other replies have concentrated on the SQL side of things.
One men
You can also use
SELECT ISNULL(myColumn, 0 ) FROM myTable
Reference: http://www.w3schools.com/sql/sql_isnull.asp
--
View this message in context:
http://lucene.472066.n3.nabble.com/Replace-NULL-with-0-while-Indexing-tp4095059p4095550.html
Sent from the Solr - User mailing list archive at Nabb
Or you can use custom update preprocessor.
W dniu 11.10.2013 23:02, keshari.prerna pisze:
Hello,
One of my indexing field have NULL values and i want it to be replaces with
0 while indexing itself. So that when i search after indexing it gives me 0
instead of NULL.
This is my data-config.xml
What about using COALESCE in SQL?
like:
select COALESCE(duration, 0) as duration from mytable
On 11 October 2013 22:02, keshari.prerna wrote:
> Hello,
>
> One of my indexing field have NULL values and i want it to be replaces with
> 0 while indexing itself. So that when i search after indexin
