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 vighnesh <sv...@gmail.com> on 2011/10/11 11:36:02 UTC

is it possible to write delta query without using timestamp column?

hello everyone

is it possible to write delta querys without using timestamp column in
database table?


Thanks in advance.






Regards
Vighnesh

--
View this message in context: http://lucene.472066.n3.nabble.com/is-it-possible-to-write-delta-query-without-using-timestamp-column-tp3412105p3412105.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: is it possible to write delta query without using timestamp column?

Posted by Erik Hatcher <er...@gmail.com>.

Try here for more details: http://wiki.apache.org/solr/DataImportHandler#Using_delta-import_command

Any query can be put into deltaQuery - whatever makes the most sense for your database, to select the id's that need updating.  Then deltaImportQuery is used to pick up the details of the data to be updated/added.

I'm no DIH expert here.  It's very tricky to work with, IMO.  But maybe a little fiddling is all it'll take to get what you need.

	Erik

On Oct 11, 2011, at 07:20 , vighnesh wrote:

> thanks erik,
> 
> but  give me any examples on writing delta query without using timestamp
> column.
> and explain me briefly.
> 
> 
> 
> 
> thanx in advance.
> 
> --
> View this message in context: http://lucene.472066.n3.nabble.com/is-it-possible-to-write-delta-query-without-using-timestamp-column-tp3412105p3412270.html
> Sent from the Solr - User mailing list archive at Nabble.com.

Re: is it possible to write delta query without using timestamp column?

Posted by vighnesh <sv...@gmail.com>.

thanks erik,

but  give me any examples on writing delta query without using timestamp
column.
and explain me briefly.




thanx in advance.

--
View this message in context: http://lucene.472066.n3.nabble.com/is-it-possible-to-write-delta-query-without-using-timestamp-column-tp3412105p3412270.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: is it possible to write delta query without using timestamp column?

Posted by Erik Hatcher <er...@gmail.com>.

Yes.  But the query will best work if you have some "delta" criteria. Otherwise you might as well do a full import.  

   Erik

On Oct 11, 2011, at 5:36, vighnesh <sv...@gmail.com> wrote:

> hello everyone
> 
> is it possible to write delta querys without using timestamp column in
> database table?
> 
> 
> Thanks in advance.
> 
> 
> 
> 
> 
> 
> Regards
> Vighnesh
> 
> --
> View this message in context: http://lucene.472066.n3.nabble.com/is-it-possible-to-write-delta-query-without-using-timestamp-column-tp3412105p3412105.html
> Sent from the Solr - User mailing list archive at Nabble.com.