[NIFI-8336] Change bulletinTimestamp in QueryNiFi BULLETINS table to Long

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.14.0
• Component/s: Extensions
• Assignee: Matt Burgess
• Reporter: Matt Burgess
• Created: 17/Mar/21 17:08
• Updated: 17/Mar/21 18:59
• Resolved: 17/Mar/21 18:59

Description

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).

Issue Links

• links to: GitHub Pull Request #4909