You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by 于浩 <yu...@gmail.com> on 2011/08/31 03:13:53 UTC
Why I can't take an full-import with entity name?
I am using solr1.3,I updated solr index throgh solr delta import every two
hours. but the delta import is database connection wasteful.
So i want to use full-import with entity name instead of delta import.
my db-data-config.xml file:
<entity name="article" pk="Article_ID" query="select
Article_ID,Article_Title,Article_Abstract from Article_Detail">
<field name="Article_ID" column="Article_ID" />
</entity>
<entity name="delta_article" pk="Article_ID" rootEngity="false"
query="select Article_ID,Article_Title,Article_Abstract from Article_Detail
where Article_ID>'${dataimporter.request.minID}' and Article_ID
<='{dataimporter.request.maxID}'
">
<field name="Article_ID" column="Article_ID" />
</entity>
then I uses
http://192.168.1.98:8081/solr/db_article/dataimport?command=full-import&entity=delta_article&commit=true&clean=false&maxID=1000&minID=10
but the solr will finish nearyly instant,and there is no any record
imported. but what the fact is there are many records meets the condtion of
maxID and minID.
the tomcat log:
信息: [db_article] webapp=/solr path=/dataimport
params={maxID=6737277&clean=false&commit=true&entity=delta_article&command=full-import&minID=6736841}
status=0 QTime=0
2011-8-29 19:00:03 org.apache.solr.handler.dataimport.DataImporter
doFullImport
信息: Starting Full Import
2011-8-29 19:00:03 org.apache.solr.handler.dataimport.SolrWriter
readIndexerProperties
信息: Read dataimport.properties
2011-8-29 19:00:03 org.apache.solr.handler.dataimport.SolrWriter
persistStartTime
信息: Wrote last indexed time to dataimport.properties
2011-8-29 19:00:03 org.apache.solr.handler.dataimport.DocBuilder commit
信息: Full Import completed successfully
some body who can help or some advices?
Re: Why I can't take an full-import with entity name?
Posted by Pulkit Singhal <pu...@gmail.com>.
Can you monitor the DB side to see what results it returned for that query?
2011/8/30 于浩 <yu...@gmail.com>:
> I am using solr1.3,I updated solr index throgh solr delta import every two
> hours. but the delta import is database connection wasteful.
> So i want to use full-import with entity name instead of delta import.
>
> my db-data-config.xml file:
> <entity name="article" pk="Article_ID" query="select
> Article_ID,Article_Title,Article_Abstract from Article_Detail">
> <field name="Article_ID" column="Article_ID" />
> </entity>
> <entity name="delta_article" pk="Article_ID" rootEngity="false"
> query="select Article_ID,Article_Title,Article_Abstract from Article_Detail
> where Article_ID>'${dataimporter.request.minID}' and Article_ID
> <='{dataimporter.request.maxID}'
> ">
> <field name="Article_ID" column="Article_ID" />
> </entity>
>
>
> then I uses
> http://192.168.1.98:8081/solr/db_article/dataimport?command=full-import&entity=delta_article&commit=true&clean=false&maxID=1000&minID=10
> but the solr will finish nearyly instant,and there is no any record
> imported. but what the fact is there are many records meets the condtion of
> maxID and minID.
>
>
> the tomcat log:
> 信息: [db_article] webapp=/solr path=/dataimport
> params={maxID=6737277&clean=false&commit=true&entity=delta_article&command=full-import&minID=6736841}
> status=0 QTime=0
> 2011-8-29 19:00:03 org.apache.solr.handler.dataimport.DataImporter
> doFullImport
> 信息: Starting Full Import
> 2011-8-29 19:00:03 org.apache.solr.handler.dataimport.SolrWriter
> readIndexerProperties
> 信息: Read dataimport.properties
> 2011-8-29 19:00:03 org.apache.solr.handler.dataimport.SolrWriter
> persistStartTime
> 信息: Wrote last indexed time to dataimport.properties
> 2011-8-29 19:00:03 org.apache.solr.handler.dataimport.DocBuilder commit
> 信息: Full Import completed successfully
>
>
> some body who can help or some advices?
>