[
https://issues.apache.org/jira/browse/NIFI-8336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Matt Burgess reassigned NIFI-8336:
----------------------------------
Assignee: Matt Burgess
> 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
> Assignee: Matt Burgess
> Priority: Major
>
> 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)
