The column strategy is a community effort, it can manipulate SQL statement where clauses with timestamp filter.
I do not have enough knowledge about column strategy. You are correct, at node restart, a river does not know from where to restart. There is no method to resolve this within river logic. Jörg On Mon, Apr 20, 2015 at 2:11 PM, GWired <garrettcjohn...@gmail.com> wrote: > I can't look at the feeder setup now but I could in the future. > > Is my SQL statement incorrect? > > Should I be doing something differently? > > Does the river not utilize created_at and updated_at in this setup? I > don't have a where clause because I thought using the column strategy it > would take that in to account. > > This is an example of what I see in SQL server: > > SELECT id as _id, * FROM [MyDBName].[dbo].[MyTableName] WHERE ({fn > TIMESTAMPDIFF(SQL_TSI_SECOND,@P0,"createddate")} >= 0) > > Which when i populate the @P0 with a timestamp it seems to be working fine. > > On a restart I'm guessing it doesn't know when to start. > > Any way that I can check values in elasticsearch within the column > strategy? Such as using Max(CreatedDate) so that it can start there? > > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to elasticsearch+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/06e9ce54-8b71-4337-971b-440a5b56f00d%40googlegroups.com > <https://groups.google.com/d/msgid/elasticsearch/06e9ce54-8b71-4337-971b-440a5b56f00d%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFOXtchcMm%3D3PN2gwA6P%2B%2BZoDNtSpwRAk51e2yNXuAdNQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.