When trying to import JSON data which has dates in UTC (ISO 8601) date format it error out. Added code to format the date to non ISO 8601.
UTC: "2014-07-10T11:47:45Z"
NON UTC: "2014-07-10 11:47:45" (Without "T" and "Z" chars)
Error Message: java.io.IOException: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
rcongiu
commented
7 years ago
When trying to import JSON data which has dates in UTC (ISO 8601) date format it error out. Added code to format the date to non ISO 8601. UTC: "2014-07-10T11:47:45Z" NON UTC: "2014-07-10 11:47:45" (Without "T" and "Z" chars) Error Message: java.io.IOException: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]