Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-7714

QueryCassandra loses precision when converting timestamps to JSON

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.13.0, 1.12.1
    • Extensions
    • None

    Description

      When QueryCassandra converts java.util.Date to JSON string value [1] the formatted string does not contain milliseconds.
      JSON date fields should be formatted conforming to the ISO 8601 standard, i.e. yyyy-MM-dd HH:mm:ss.SSSZ

       

      I suggest adding a new property to the QueryCassandra processor to be able to change the date format string.

       

      [1] https://github.com/apache/nifi/blob/main/nifi-nar-bundles/nifi-cassandra-bundle/nifi-cassandra-processors/src/main/java/org/apache/nifi/processors/cassandra/QueryCassandra.java#L473

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            denes Denes Arvay
            denes Denes Arvay
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 1h 50m
                1h 50m

                Slack

                  Issue deployment