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)
