Re: DeltaImport problem
Hi, Hi! thanks so much, I have the latest release. Now, it shows that the delta import is successful but when I query for the updated article I am expecting, it has not updated. It's like the index is not being updated with the changes...Any ideas? I have experienced the same issue with a build of solr-trunk (from about 2 months ago). The delta-import runs but the index doesn't seem to be updated - although the info suggests that the correct number of records have been indexed Kev
Re: DeltaImport problem
I got the build from 2009-09-12... :o( Any ideas what is wrong or how to fix? foamdino wrote: Hi, Hi! thanks so much, I have the latest release. Now, it shows that the delta import is successful but when I query for the updated article I am expecting, it has not updated. It's like the index is not being updated with the changes...Any ideas? I have experienced the same issue with a build of solr-trunk (from about 2 months ago). The delta-import runs but the index doesn't seem to be updated - although the info suggests that the correct number of records have been indexed Kev -- View this message in context: http://www.nabble.com/DeltaImport-problem-tp25471596p25488073.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: DeltaImport problem
What does the status command say after delta-import? does it say committed?
On Thu, Sep 17, 2009 at 2:50 PM, KirstyS kirst...@gmail.com wrote:
Hi! thanks so much, I have the latest release.
Now, it shows that the delta import is successful but when I query for the
updated article I am expecting, it has not updated. It's like the index is
not being updated with the changes...Any ideas?
thanks
Kirsty
Noble Paul നോബിള് नोब्ळ्-2 wrote:
http://people.apache.org/builds/lucene/solr/nightly/
On Wed, Sep 16, 2009 at 6:42 PM, KirstyS kirst...@gmail.com wrote:
mmm..can't seem to find the link..could you help?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
yeah, not yet released but going to be released pretty soon
On Wed, Sep 16, 2009 at 6:32 PM, KirstyS kirst...@gmail.com wrote:
I thought 1.4 was not released yet?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
I vaguely remember there was an issue with delta-import in 1.3. could
you try it out with Solr1.4
On Wed, Sep 16, 2009 at 6:14 PM, KirstyS kirst...@gmail.com wrote:
I hope this is the correct place to post this issue and if so, that
someone
can help.
I am using the DIH with Solr 1.3
My data-config.xml file looks like this:
dataSource
driver=net.sourceforge.jtds.jdbc.Driver
url=jdbc:jtds:sqlserver:{taken out for posting}
user={taken out for posting}
password={taken out for posting} /
entity name=article pk=CmsArticleId
query=Select a.CmsArticleId, a.CreatorId , LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb,
ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock) on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac
(nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on
aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId
is
null
deltaQuery=Select a.CmsArticleId, a.CreatorId ,
LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb,
ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock) on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac
(nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on
aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId
is
null
and (LastUpdateDate
'${dataimporter.last_index_time}'
OR a.CreationDate '${dataimporter.last_index_time}')
Have tried casting the dataimporter.last_index_time and the other
date
fields. To no avail. My Full Import works perfectly but I cannot get
the
command=delta-import to pick up the updated records. The
LastUpdateDate
is
being updated. When I run this in the debug interface with
delta-import
it
just never calls the delta import.
Please, if anyone knows what I am doing wrong???
Many thanks
Kirsty
--
View this message in context:
http://www.nabble.com/DeltaImport-problem-tp25471596p25471596.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/DeltaImport-problem-tp25471596p25471927.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/DeltaImport-problem-tp25471596p25472102.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/DeltaImport-problem-tp25471596p25487855.html
Sent from the Solr - User mailing list archive at Nabble.com
Re: DeltaImport problem
No, I don't see any commit...
I ran with this command
http://localhost:8080/solr/dataimport?command=delta-import
and these are the results
str name=commanddelta-import/str
str name=statusidle/str
str name=importResponse/
−
lst name=statusMessages
str name=Total Requests made to DataSource3/str
str name=Total Rows Fetched2/str
str name=Total Documents Skipped0/str
str name=Delta Dump started2009-09-17 11:42:14/str
str name=Identifying Delta2009-09-17 11:42:14/str
str name=Deltas Obtained2009-09-17 11:42:14/str
str name=Building documents2009-09-17 11:42:14/str
str name=Total Changed Documents2/str
str name=Time taken 0:0:0.172/str
/lst
−
str name=WARNING
This response format is experimental. It is likely to change in the future.
/str
Is it not supposed to default to commit?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
What does the status command say after delta-import? does it say
committed?
On Thu, Sep 17, 2009 at 2:50 PM, KirstyS kirst...@gmail.com wrote:
Hi! thanks so much, I have the latest release.
Now, it shows that the delta import is successful but when I query for
the
updated article I am expecting, it has not updated. It's like the index
is
not being updated with the changes...Any ideas?
thanks
Kirsty
Noble Paul നോബിള് नोब्ळ्-2 wrote:
http://people.apache.org/builds/lucene/solr/nightly/
On Wed, Sep 16, 2009 at 6:42 PM, KirstyS kirst...@gmail.com wrote:
mmm..can't seem to find the link..could you help?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
yeah, not yet released but going to be released pretty soon
On Wed, Sep 16, 2009 at 6:32 PM, KirstyS kirst...@gmail.com wrote:
I thought 1.4 was not released yet?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
I vaguely remember there was an issue with delta-import in 1.3.
could
you try it out with Solr1.4
On Wed, Sep 16, 2009 at 6:14 PM, KirstyS kirst...@gmail.com wrote:
I hope this is the correct place to post this issue and if so, that
someone
can help.
I am using the DIH with Solr 1.3
My data-config.xml file looks like this:
dataSource
driver=net.sourceforge.jtds.jdbc.Driver
url=jdbc:jtds:sqlserver:{taken out for posting}
user={taken out for posting}
password={taken out for posting} /
entity name=article pk=CmsArticleId
query=Select a.CmsArticleId, a.CreatorId ,
LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb,
ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock)
on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac
(nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on
aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId
is
null
deltaQuery=Select a.CmsArticleId, a.CreatorId ,
LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb,
ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock)
on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac
(nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on
aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId
is
null
and (LastUpdateDate
'${dataimporter.last_index_time}'
OR a.CreationDate '${dataimporter.last_index_time}')
Have tried casting the dataimporter.last_index_time and the other
date
fields. To no avail. My Full Import works perfectly but I cannot
get
the
command=delta-import to pick up the updated records. The
LastUpdateDate
is
being updated. When I run this in the debug interface with
delta-import
it
just never calls the delta import.
Please, if anyone knows what I am doing wrong???
Many thanks
Kirsty
--
View this message in context:
http://www.nabble.com/DeltaImport-problem-tp25471596p25471596.html
Sent from the Solr - User mailing list archive at Nabble.com
Re: DeltaImport problem
can you try the same command a commit=true ?
On Thu, Sep 17, 2009 at 3:15 PM, KirstyS kirst...@gmail.com wrote:
No, I don't see any commit...
I ran with this command
http://localhost:8080/solr/dataimport?command=delta-import
and these are the results
str name=commanddelta-import/str
str name=statusidle/str
str name=importResponse/
−
lst name=statusMessages
str name=Total Requests made to DataSource3/str
str name=Total Rows Fetched2/str
str name=Total Documents Skipped0/str
str name=Delta Dump started2009-09-17 11:42:14/str
str name=Identifying Delta2009-09-17 11:42:14/str
str name=Deltas Obtained2009-09-17 11:42:14/str
str name=Building documents2009-09-17 11:42:14/str
str name=Total Changed Documents2/str
str name=Time taken 0:0:0.172/str
/lst
−
str name=WARNING
This response format is experimental. It is likely to change in the future.
/str
Is it not supposed to default to commit?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
What does the status command say after delta-import? does it say
committed?
On Thu, Sep 17, 2009 at 2:50 PM, KirstyS kirst...@gmail.com wrote:
Hi! thanks so much, I have the latest release.
Now, it shows that the delta import is successful but when I query for
the
updated article I am expecting, it has not updated. It's like the index
is
not being updated with the changes...Any ideas?
thanks
Kirsty
Noble Paul നോബിള് नोब्ळ्-2 wrote:
http://people.apache.org/builds/lucene/solr/nightly/
On Wed, Sep 16, 2009 at 6:42 PM, KirstyS kirst...@gmail.com wrote:
mmm..can't seem to find the link..could you help?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
yeah, not yet released but going to be released pretty soon
On Wed, Sep 16, 2009 at 6:32 PM, KirstyS kirst...@gmail.com wrote:
I thought 1.4 was not released yet?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
I vaguely remember there was an issue with delta-import in 1.3.
could
you try it out with Solr1.4
On Wed, Sep 16, 2009 at 6:14 PM, KirstyS kirst...@gmail.com wrote:
I hope this is the correct place to post this issue and if so, that
someone
can help.
I am using the DIH with Solr 1.3
My data-config.xml file looks like this:
dataSource
driver=net.sourceforge.jtds.jdbc.Driver
url=jdbc:jtds:sqlserver:{taken out for posting}
user={taken out for posting}
password={taken out for posting} /
entity name=article pk=CmsArticleId
query=Select a.CmsArticleId, a.CreatorId ,
LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb,
ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock)
on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac
(nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on
aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId
is
null
deltaQuery=Select a.CmsArticleId, a.CreatorId ,
LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb,
ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock)
on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac
(nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on
aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId
is
null
and (LastUpdateDate
'${dataimporter.last_index_time}'
OR a.CreationDate '${dataimporter.last_index_time}')
Have tried casting the dataimporter.last_index_time and the other
date
fields. To no avail. My Full Import works perfectly but I cannot
get
the
command=delta-import to pick up the updated records. The
LastUpdateDate
is
being updated. When I run this in the debug interface with
delta-import
it
just never calls the delta import.
Please, if anyone knows what I am doing wrong???
Many thanks
Kirsty
--
View this message in context:
http://www.nabble.com/DeltaImport-problem
Re: DeltaImport problem
??? Many thanks Kirsty -- View this message in context: http://www.nabble.com/DeltaImport-problem-tp25471596p25471596.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/DeltaImport-problem-tp25471596p25471927.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/DeltaImport-problem-tp25471596p25472102.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/DeltaImport-problem-tp25471596p25487855.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/DeltaImport-problem-tp25471596p25488209.html Sent from the Solr - User mailing list archive at Nabble.com. -- - Noble Paul | Principal Engineer| AOL | http://aol.com -- - Noble Paul | Principal Engineer| AOL | http://aol.com
Re: DeltaImport problem
. The LastUpdateDate is being updated. When I run this in the debug interface with delta-import it just never calls the delta import. Please, if anyone knows what I am doing wrong??? Many thanks Kirsty -- View this message in context: http://www.nabble.com/DeltaImport-problem-tp25471596p25471596.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/DeltaImport-problem-tp25471596p25471927.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/DeltaImport-problem-tp25471596p25472102.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/DeltaImport-problem-tp25471596p25487855.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/DeltaImport-problem-tp25471596p25488209.html Sent from the Solr - User mailing list archive at Nabble.com. -- - Noble Paul | Principal Engineer| AOL | http://aol.com -- - Noble Paul | Principal Engineer| AOL | http://aol.com -- - Noble Paul | Principal Engineer| AOL | http://aol.com
DeltaImport problem
I hope this is the correct place to post this issue and if so, that someone
can help.
I am using the DIH with Solr 1.3
My data-config.xml file looks like this:
dataSource
driver=net.sourceforge.jtds.jdbc.Driver
url=jdbc:jtds:sqlserver:{taken out for posting}
user={taken out for posting}
password={taken out for posting} /
entity name=article pk=CmsArticleId
query=Select a.CmsArticleId, a.CreatorId , LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb, ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock) on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac (nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId is
null
deltaQuery=Select a.CmsArticleId, a.CreatorId , LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished, ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb, ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock) on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac (nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId is null
and (LastUpdateDate
'${dataimporter.last_index_time}'
OR a.CreationDate '${dataimporter.last_index_time}')
Have tried casting the dataimporter.last_index_time and the other date
fields. To no avail. My Full Import works perfectly but I cannot get the
command=delta-import to pick up the updated records. The LastUpdateDate is
being updated. When I run this in the debug interface with delta-import it
just never calls the delta import.
Please, if anyone knows what I am doing wrong???
Many thanks
Kirsty
--
View this message in context:
http://www.nabble.com/DeltaImport-problem-tp25471596p25471596.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: DeltaImport problem
I vaguely remember there was an issue with delta-import in 1.3. could
you try it out with Solr1.4
On Wed, Sep 16, 2009 at 6:14 PM, KirstyS kirst...@gmail.com wrote:
I hope this is the correct place to post this issue and if so, that someone
can help.
I am using the DIH with Solr 1.3
My data-config.xml file looks like this:
dataSource
driver=net.sourceforge.jtds.jdbc.Driver
url=jdbc:jtds:sqlserver:{taken out for posting}
user={taken out for posting}
password={taken out for posting} /
entity name=article pk=CmsArticleId
query=Select a.CmsArticleId, a.CreatorId , LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb, ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock) on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac (nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId is
null
deltaQuery=Select a.CmsArticleId, a.CreatorId , LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished, ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb, ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock) on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac (nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId is null
and (LastUpdateDate
'${dataimporter.last_index_time}'
OR a.CreationDate '${dataimporter.last_index_time}')
Have tried casting the dataimporter.last_index_time and the other date
fields. To no avail. My Full Import works perfectly but I cannot get the
command=delta-import to pick up the updated records. The LastUpdateDate is
being updated. When I run this in the debug interface with delta-import it
just never calls the delta import.
Please, if anyone knows what I am doing wrong???
Many thanks
Kirsty
--
View this message in context:
http://www.nabble.com/DeltaImport-problem-tp25471596p25471596.html
Sent from the Solr - User mailing list archive at Nabble.com.
--
-
Noble Paul | Principal Engineer| AOL | http://aol.com
Re: DeltaImport problem
I thought 1.4 was not released yet?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
I vaguely remember there was an issue with delta-import in 1.3. could
you try it out with Solr1.4
On Wed, Sep 16, 2009 at 6:14 PM, KirstyS kirst...@gmail.com wrote:
I hope this is the correct place to post this issue and if so, that
someone
can help.
I am using the DIH with Solr 1.3
My data-config.xml file looks like this:
dataSource
driver=net.sourceforge.jtds.jdbc.Driver
url=jdbc:jtds:sqlserver:{taken out for posting}
user={taken out for posting}
password={taken out for posting} /
entity name=article pk=CmsArticleId
query=Select a.CmsArticleId, a.CreatorId , LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb,
ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock) on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac
(nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on
aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId is
null
deltaQuery=Select a.CmsArticleId, a.CreatorId ,
LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb,
ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock) on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac
(nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on
aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId is
null
and (LastUpdateDate
'${dataimporter.last_index_time}'
OR a.CreationDate '${dataimporter.last_index_time}')
Have tried casting the dataimporter.last_index_time and the other date
fields. To no avail. My Full Import works perfectly but I cannot get the
command=delta-import to pick up the updated records. The LastUpdateDate
is
being updated. When I run this in the debug interface with delta-import
it
just never calls the delta import.
Please, if anyone knows what I am doing wrong???
Many thanks
Kirsty
--
View this message in context:
http://www.nabble.com/DeltaImport-problem-tp25471596p25471596.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/DeltaImport-problem-tp25471596p25471927.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: DeltaImport problem
yeah, not yet released but going to be released pretty soon
On Wed, Sep 16, 2009 at 6:32 PM, KirstyS kirst...@gmail.com wrote:
I thought 1.4 was not released yet?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
I vaguely remember there was an issue with delta-import in 1.3. could
you try it out with Solr1.4
On Wed, Sep 16, 2009 at 6:14 PM, KirstyS kirst...@gmail.com wrote:
I hope this is the correct place to post this issue and if so, that
someone
can help.
I am using the DIH with Solr 1.3
My data-config.xml file looks like this:
dataSource
driver=net.sourceforge.jtds.jdbc.Driver
url=jdbc:jtds:sqlserver:{taken out for posting}
user={taken out for posting}
password={taken out for posting} /
entity name=article pk=CmsArticleId
query=Select a.CmsArticleId, a.CreatorId , LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb,
ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock) on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac
(nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on
aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId is
null
deltaQuery=Select a.CmsArticleId, a.CreatorId ,
LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb,
ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock) on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac
(nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on
aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId is
null
and (LastUpdateDate
'${dataimporter.last_index_time}'
OR a.CreationDate '${dataimporter.last_index_time}')
Have tried casting the dataimporter.last_index_time and the other date
fields. To no avail. My Full Import works perfectly but I cannot get the
command=delta-import to pick up the updated records. The LastUpdateDate
is
being updated. When I run this in the debug interface with delta-import
it
just never calls the delta import.
Please, if anyone knows what I am doing wrong???
Many thanks
Kirsty
--
View this message in context:
http://www.nabble.com/DeltaImport-problem-tp25471596p25471596.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/DeltaImport-problem-tp25471596p25471927.html
Sent from the Solr - User mailing list archive at Nabble.com.
--
-
Noble Paul | Principal Engineer| AOL | http://aol.com
Re: DeltaImport problem
mmm..can't seem to find the link..could you help?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
yeah, not yet released but going to be released pretty soon
On Wed, Sep 16, 2009 at 6:32 PM, KirstyS kirst...@gmail.com wrote:
I thought 1.4 was not released yet?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
I vaguely remember there was an issue with delta-import in 1.3. could
you try it out with Solr1.4
On Wed, Sep 16, 2009 at 6:14 PM, KirstyS kirst...@gmail.com wrote:
I hope this is the correct place to post this issue and if so, that
someone
can help.
I am using the DIH with Solr 1.3
My data-config.xml file looks like this:
dataSource
driver=net.sourceforge.jtds.jdbc.Driver
url=jdbc:jtds:sqlserver:{taken out for posting}
user={taken out for posting}
password={taken out for posting} /
entity name=article pk=CmsArticleId
query=Select a.CmsArticleId, a.CreatorId , LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb,
ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock) on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac
(nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on
aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId is
null
deltaQuery=Select a.CmsArticleId, a.CreatorId ,
LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb,
ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock) on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac
(nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on
aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId is
null
and (LastUpdateDate
'${dataimporter.last_index_time}'
OR a.CreationDate '${dataimporter.last_index_time}')
Have tried casting the dataimporter.last_index_time and the other date
fields. To no avail. My Full Import works perfectly but I cannot get
the
command=delta-import to pick up the updated records. The LastUpdateDate
is
being updated. When I run this in the debug interface with delta-import
it
just never calls the delta import.
Please, if anyone knows what I am doing wrong???
Many thanks
Kirsty
--
View this message in context:
http://www.nabble.com/DeltaImport-problem-tp25471596p25471596.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/DeltaImport-problem-tp25471596p25471927.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/DeltaImport-problem-tp25471596p25472102.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: DeltaImport problem
http://people.apache.org/builds/lucene/solr/nightly/
On Wed, Sep 16, 2009 at 6:42 PM, KirstyS kirst...@gmail.com wrote:
mmm..can't seem to find the link..could you help?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
yeah, not yet released but going to be released pretty soon
On Wed, Sep 16, 2009 at 6:32 PM, KirstyS kirst...@gmail.com wrote:
I thought 1.4 was not released yet?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
I vaguely remember there was an issue with delta-import in 1.3. could
you try it out with Solr1.4
On Wed, Sep 16, 2009 at 6:14 PM, KirstyS kirst...@gmail.com wrote:
I hope this is the correct place to post this issue and if so, that
someone
can help.
I am using the DIH with Solr 1.3
My data-config.xml file looks like this:
dataSource
driver=net.sourceforge.jtds.jdbc.Driver
url=jdbc:jtds:sqlserver:{taken out for posting}
user={taken out for posting}
password={taken out for posting} /
entity name=article pk=CmsArticleId
query=Select a.CmsArticleId, a.CreatorId , LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb,
ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock) on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac
(nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on
aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId is
null
deltaQuery=Select a.CmsArticleId, a.CreatorId ,
LastUpdatedBy,
LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
ArticleTypeId,
a.StrapHead, ShortHeading, HomePageBlurb,
ByLine,
ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
c.CategoryId, AncestralName, CategoryName,
CategoryDisplayName, ParentCategoryId, c.SiteId
from Category c (nolock)
inner join CmsArticleCollection ac (nolock) on
c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
inner join CmsArticleArticleCollection aac
(nolock)
on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
inner join CmsArticle a (nolock) on
aac.CmsArticleId
= a.CmsArticleId
where (a.LiveEdit is null or a.LiveEdit = 0)
and aac.SourceCmsArticleArticleCollectionId is
null
and (LastUpdateDate
'${dataimporter.last_index_time}'
OR a.CreationDate '${dataimporter.last_index_time}')
Have tried casting the dataimporter.last_index_time and the other date
fields. To no avail. My Full Import works perfectly but I cannot get
the
command=delta-import to pick up the updated records. The LastUpdateDate
is
being updated. When I run this in the debug interface with delta-import
it
just never calls the delta import.
Please, if anyone knows what I am doing wrong???
Many thanks
Kirsty
--
View this message in context:
http://www.nabble.com/DeltaImport-problem-tp25471596p25471596.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/DeltaImport-problem-tp25471596p25471927.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/DeltaImport-problem-tp25471596p25472102.html
Sent from the Solr - User mailing list archive at Nabble.com.
--
-
Noble Paul | Principal Engineer| AOL | http://aol.com
