Matt Burgess created NIFI-8336:
----------------------------------
Summary: Change bulletinTimestamp in QueryNiFi BULLETINS table to
Long
Key: NIFI-8336
URL: https://issues.apache.org/jira/browse/NIFI-8336
Project: Apache NiFi
Issue Type: Improvement
Components: Extensions
Reporter: Matt Burgess
The table model for BULLETINS, which allows components like
QueryNiFiReportingTask to issue SQL queries against NiFi repositories such as
Bulletins, specifies the "bulletinTimestamp" column as a Date.
This makes it difficult to do comparisons, as Calcite (per the SQL standard)
doesn't assume integral values correspond to dates/times based on Epoch. In
order to get all bulletins after a certain Date (for example, five minutes
ago), the user would have to do the math on the milliseconds and then format
that as a String to be used as a Date literal in the SQL query.
Instead this Jira proposes to change the datatype of bulletinTimestamp to
"long", making it consistent with other table models' timestamp columns and
making it easier to generate SQL queries using this field (such as incremental
fetch).
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
