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.
