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 huenzhao <hu...@126.com> on 2009/08/20 06:12:21 UTC
【solr DIH】A problem about solr delta-imports
Hi all,
There is a problem when I use solr delta-imports to update the index. I have
added the "last_modified" column in the table. After I use the "full-import"
command to index the database data, the "dataimport.properties" file
contains nothing, and when I use the "delta-import" command to update index,
the solr list all the data in database not the lasted data. My
db-data-config.xml:
<dataConfig>
<dataSource driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/funguide" user="root" password="root"/>
<document name="shopinfo">
<entity name="shop" pk="shop_id" query="select
shop_id,title,description,tel,address,longitude,latitude from shop"
deltaQuery="select shop_id from shop where last_modified >
'${dataimporter.last_index_time}'">
<field column="shop_id" name="id" />
<field column="title" name="title" />
<field column="description" name="description" />
<field column="tel" name="tel" />
<field column="address" name="address" />
<field column="longitude" name="longitude" />
<field column="latitude" name="latitude" />
</entity>
</document>
</dataConfig>
Anyboby know how to solve the problem? Thanks!
enzhaohoo@gmail.com
--
View this message in context: http://www.nabble.com/%E3%80%90solr-DIH%E3%80%91A-problem-about-solr-delta-imports-tp25055788p25055788.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: 【solr DIH】A problem about solr delta-imports
Posted by huenzhao <hu...@126.com>.
The version is 1.3.
After I used the full-import, the tomcat log show that the solr did not call
the SolrWriter class.
Do you know the solution of this bug?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
>
> which version of solr are you using? .Solr1.3 had a bug with this.
>
> On Thu, Aug 20, 2009 at 9:42 AM, huenzhao<hu...@126.com> wrote:
>>
>> Hi all,
>>
>> There is a problem when I use solr delta-imports to update the index. I
>> have
>> added the "last_modified" column in the table. After I use the
>> "full-import"
>> command to index the database data, the "dataimport.properties" file
>> contains nothing, and when I use the "delta-import" command to update
>> index,
>> the solr list all the data in database not the lasted data. My
>> db-data-config.xml:
>>
>> <dataConfig>
>> <dataSource driver="com.mysql.jdbc.Driver"
>> url="jdbc:mysql://localhost:3306/funguide" user="root" password="root"/>
>> <document name="shopinfo">
>> <entity name="shop" pk="shop_id" query="select
>> shop_id,title,description,tel,address,longitude,latitude from shop"
>> deltaQuery="select shop_id from shop where last_modified >
>> '${dataimporter.last_index_time}'">
>>
>> <field column="shop_id" name="id" />
>> <field column="title" name="title" />
>> <field column="description" name="description" />
>> <field column="tel" name="tel" />
>> <field column="address" name="address" />
>> <field column="longitude" name="longitude" />
>> <field column="latitude" name="latitude" />
>>
>> </entity>
>> </document>
>> </dataConfig>
>>
>> Anyboby know how to solve the problem? Thanks!
>>
>> enzhaohoo@gmail.com
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/%E3%80%90solr-DIH%E3%80%91A-problem-about-solr-delta-imports-tp25055788p25055788.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
>
>
>
> --
> -----------------------------------------------------
> Noble Paul | Principal Engineer| AOL | http://aol.com
>
>
--
View this message in context: http://www.nabble.com/%E3%80%90solr-DIH%E3%80%91A-problem-about-solr-delta-imports-tp25055788p25056379.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: 【solr DIH】A problem about solr delta-imports
Posted by Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>.
which version of solr are you using? .Solr1.3 had a bug with this.
On Thu, Aug 20, 2009 at 9:42 AM, huenzhao<hu...@126.com> wrote:
>
> Hi all,
>
> There is a problem when I use solr delta-imports to update the index. I have
> added the "last_modified" column in the table. After I use the "full-import"
> command to index the database data, the "dataimport.properties" file
> contains nothing, and when I use the "delta-import" command to update index,
> the solr list all the data in database not the lasted data. My
> db-data-config.xml:
>
> <dataConfig>
> <dataSource driver="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost:3306/funguide" user="root" password="root"/>
> <document name="shopinfo">
> <entity name="shop" pk="shop_id" query="select
> shop_id,title,description,tel,address,longitude,latitude from shop"
> deltaQuery="select shop_id from shop where last_modified >
> '${dataimporter.last_index_time}'">
>
> <field column="shop_id" name="id" />
> <field column="title" name="title" />
> <field column="description" name="description" />
> <field column="tel" name="tel" />
> <field column="address" name="address" />
> <field column="longitude" name="longitude" />
> <field column="latitude" name="latitude" />
>
> </entity>
> </document>
> </dataConfig>
>
> Anyboby know how to solve the problem? Thanks!
>
> enzhaohoo@gmail.com
>
>
> --
> View this message in context: http://www.nabble.com/%E3%80%90solr-DIH%E3%80%91A-problem-about-solr-delta-imports-tp25055788p25055788.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
>
--
-----------------------------------------------------
Noble Paul | Principal Engineer| AOL | http://aol.com