lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sureshadapa <sureshad...@gmail.com>
Subject Re: Need help with delta import
Date Thu, 19 Sep 2013 05:05:36 GMT
I am using below configuration file and The problem is I do not see any solr
documents committed into Solr Core Selector 'db'

When i run full-import,Is give me message.
Indexing completed. Added/Updated: 0 documents. Deleted 0 documents.
Requests: 1, Fetched: 8, Skipped: 0, Processed: 0

When i run delta-import,It gives me message.
Requests: 0, Fetched: 0, Skipped: 0, Processed: 0

solrconfig.xml
==========
<luceneMatchVersion>4.4</luceneMatchVersion>
<requestHandler name="/dataimport"
class="org.apache.solr.handler.dataimport.DataImportHandler">
    <lst name="defaults">
    	<str name="config">db1-data-config.xml</str>
    </lst>
  </requestHandler>

schema.xml
========
<schema name="db" version="1.1">
   <field name="solrp_id" type="sint" indexed="true" stored="true"
required="true" /> 
   <field name="solrp_name" type="string" indexed="true" stored="true" />
   <field name="solrp_phone" type="text" indexed="true" stored="true" />
   <field name="solrp_email" type="text" indexed="true" stored="true"/>
   <field name="solrp_smsno" type="text" indexed="true" stored="true"/>
   
 
 <uniqueKey>solrp_id</uniqueKey>


db1-data-config.xml
=================
<dataConfig>
<dataSource autoCommit="true" batchSize="-1" encoding="UTF-8"
convertType="true" type="JdbcDataSource" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/suresh" user="suresh"
password="suresh123"/>
    <document>
        <entity name="list" pk="PROVIDERSID" query="select
providersid,name,phone,email,smsno from providers" 
        deltaImportQuery="select providersid,name,phone,email,smsno from
providers where PROVIDERSID==${dih.delta.PROVIDERSID}"
        deltaquery="select providersid,name,phone,email,smsno from providers
where modtime=='${dih.last_index_time}'">
            <field column="PROVIDERSID" name="solrp_id" />
            <field column="NAME" name="solrp_name" />
            <field column="PHONE" name="solrp_phone" />
            <field column="EMAIL" name="solrp_email" />
            <field column="SMSNO" name="solrp_smsno" />
        </entity>
    </document>
</dataConfig>



--
View this message in context: http://lucene.472066.n3.nabble.com/Need-help-with-delta-import-tp4025003p4090999.html
Sent from the Solr - User mailing list archive at Nabble.com.

Mime
View raw message