Re: Delta Import Functionality

[Ahmet Arslan]

Hi,

I think you need to select * in deltaImportQuery. You are just selecting one 
field for both delta*Query SQL sentences.



On Thursday, June 5, 2014 3:34 PM, ajay59 <ajay.gup...@wipro.com> wrote:
Hi,

We are using the SOLR 4.6 version and trying to implement Delta import
functionality .On implementing the delta import , the indexing is gettting
completed but not fetching the updated or newly inserted rows from the table
while executing the query.

Please suggest.

Below is the data config.xml:

<dataConfig>
    <document name="test1">
       <propertyWriter dateFormat="yyyy-MM-dd HH:mm:ss"
type="SimplePropertiesWriter" directory="data"
filename="dataimport.properties" locale="en_US" />
                      
          <entity name="new1" pk="objid"
                query="select * from manish_test"
                deltaQuery="select objid from manish_test where update_stamp 
&gt;
'${dataimport.last_index_time}'"
                deltaImportQuery="select objid from manish_test where objid =
'${dataimport.delta.objid}'">
                <field column="objid" name="objid" indexed="true" stored="true" 
/>        
             </entity>  
            
        
            

                    
            

    </document>
        
          
</dataConfig>




--
View this message in context: 
http://lucene.472066.n3.nabble.com/Delta-Import-Functionality-tp4140063.html
Sent from the Solr - User mailing list archive at Nabble.com.