[jira] [Created] (NIFI-8336) Change bulletinTimestamp in QueryNiFi BULLETINS table to Long

["Matt Burgess (Jira)" <ji...@apache.org>]

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)