lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karol Sikora <karol.sik...@laboratorium.ee>
Subject Re: Replace NULL with 0 while Indexing
Date Sat, 12 Oct 2013 15:13:09 GMT
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 and duration is the field which has null values.
>
> <dataConfig>
>    <dataSource type="JdbcDataSource"
>                driver="com.mysql.jdbc.Driver"
>                 url="jdbc:mysql://trdbadhoc/test_results"
>                responseBuffering="adaptive"
>                batchSize="-1"
>                user="results"
>                password="resultsloader"/>
>     <document>
>    	<entity name="Test_Syndrome"
>          pk="id"
>        query="SELECT TS.id AS id, TET.type AS error_type, TS.syndrome AS
> syndrome, S.start_date, SE.session_id AS sessionid,
>          S.duration, TL.logfile, J.job_number AS job, cluster,
>          S.hostname, platform FROM Test_Syndrome AS TS
>          STRAIGHT_JOIN Session_Errors AS SE ON (SE.test_syndrome_id = TS.id)
>          STRAIGHT_JOIN Session AS S ON (S.id = SE.session_id)
>          STRAIGHT_JOIN Test_Run AS TR ON (TR.session_id = SE.session_id)
>          STRAIGHT_JOIN  Test_Log AS TL ON (TL.id = TR.test_log_id)
>          STRAIGHT_JOIN  Job AS J ON (J.id = TL.job_id)
>          STRAIGHT_JOIN  Cluster AS C ON (C.id = J.cluster_id)
>          STRAIGHT_JOIN  Platform ON (TR.platform_id = Platform.id)
>          STRAIGHT_JOIN Test_Error_Type TET ON (SE.test_error_type_id =
> TET.id)">
>        
>        <Field column="id" name="id"/>
>         <Field column="error_type" name="error_type"/>
>         <Field column="syndrome" name="syndrome"/>
>         <Field column="sessionid" name="sessionid"/>
>         <Field column="duration" name="duration"/>
>         <Field column="logfile" name="logfile"/>
>         <Field column="job" name="job"/>
>          <Field column="cluster" name="cluster"/>
>         <Field column="hostname" name="hostname"/>
>         <Field column="platform" name="platform"/>
>        
>      </entity>
>    </document>
> </dataConfig>
>
> Please help.
>
> Thanks & Regards,
> Prerna
>
>
>
>
>
> --
> View this message in context: http://lucene.472066.n3.nabble.com/Replace-NULL-with-0-while-Indexing-tp4095059.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>

-- 
  
Karol Sikora
Kierownik Informatyczny Projektu CBN - Interfejs 2.0
+48 781 493 788

Laboratorium EE
ul. Mokotowska 46A/23 | 00-543 Warszawa |
www.laboratorium.ee | www.laboratorium.ee/facebook


Mime
View raw message