[NIFI-8748] PutKudu Incorrect Date Conversion from String

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.13.2
• Fix Version/s: 1.14.0
• Component/s: Extensions
• Assignee: David Handermann
• Reporter: David Handermann
• Created: 29/Jun/21 14:48
• Updated: 30/Jun/21 11:41
• Resolved: 30/Jun/21 11:41

Description

The PutKudu processor uses NiFi DataTypeUtils.toDate() when converting from a NiFi Record to a Kudu PartialRow for date fields. This works as expected when the Record field value is a java.sql.Date, but can result in subtracting one day from the original value when the Record field value is a String. The problem occurs as a result of DataTypeUtils.getDateFormat() using a default Time Zone of GMT. As a result of using SimpleDateFormat.parse(), an input string of 2000-01-01 results in a java.sql.Date of 1999-12-31.

Issue Links

• links to: GitHub Pull Request #5194