[jira] [Created] (NIFI-1201) Allow ExecuteSQL to run queries with that use a variable timestamp or sequenced

["Randy Gelhausen (JIRA)" <ji...@apache.org>]

Randy Gelhausen created NIFI-1201:
-------------------------------------

             Summary: Allow ExecuteSQL to run queries with that use a variable timestamp or sequenced
                 Key: NIFI-1201
                 URL: https://issues.apache.org/jira/browse/NIFI-1201
             Project: Apache NiFi
          Issue Type: Bug
          Components: Extensions
            Reporter: Randy Gelhausen


Users are employing ExecuteSQL as a means to schedule periodic queries against remote databases. Other tools that do this type of task include the ability to maintain and automatically increment a sequence or timestamp used in query predicates.

For example:
select * from src_table where created_at > "2015-11-19 12:00:00"

Then a minute later:
select * from src_table where created_at > "2015-11-19 12:01:00"

Or:
insert into my_table values (${prev_id}+1, ${now()})

Today users can implement the same logic with a series of processors, but much work could be saved by allowing ExecuteSQL to maintain these bits of state.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)