[
https://issues.apache.org/jira/browse/NIFI-2829?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15527324#comment-15527324
]
ASF GitHub Bot commented on NIFI-2829:
--------------------------------------
GitHub user paulgibeault opened a pull request:
https://github.com/apache/nifi/pull/1073
Nifi 2829
Implemented fix for JIRA
https://issues.apache.org/jira/browse/NIFI-2829
Provided logic that will attempt to string parse Dates and Time values if
they do not match LONG_PATTERN.
The parameter sql.args.#.format may be used to provide the Date, Time or
Timestamp parsing string.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/paulgibeault/nifi NIFI-2829
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/nifi/pull/1073.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1073
----
commit 5a37e1cf7854edf23fef66a6b7be5e82c9e9f174
Author: Paul Gibeault <[email protected]>
Date: 2016-09-27T18:39:27Z
Implemented changes to address Jira NIFI-2829
Now Date and Time fields can be provided in String or EPOCH (Long) formats
Implemented Unit Tests to validate new functionality
commit 5e2f0c0315bc775dbf0dedc018cb665102a690ed
Author: Paul Gibeault <[email protected]>
Date: 2016-09-27T18:39:27Z
Implemented changes to address Jira NIFI-2829
Now Date and Time fields can be provided in String or EPOCH (Long) formats
Implemented Unit Tests to validate new functionality
commit 234235e23e1625f8cc3c90a8004cbb8e58f2e10c
Author: Paul Gibeault <[email protected]>
Date: 2016-09-27T20:26:43Z
Merge remote-tracking branch 'origin/NIFI-2829' into NIFI-2829
----
> PutSQL assumes all Date and Time values are provided in Epoch
> -------------------------------------------------------------
>
> Key: NIFI-2829
> URL: https://issues.apache.org/jira/browse/NIFI-2829
> Project: Apache NiFi
> Issue Type: Bug
> Components: Core Framework
> Affects Versions: 1.0.0
> Reporter: Paul Gibeault
> Fix For: 1.1.0
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> This bug is the same as NIFI-2576 only extended to data types DATE and TIME.
> https://issues.apache.org/jira/browse/NIFI-2576
> When PutSQL sees a DATE or TIME data type it assumes that it's being provided
> as a Long in Epoch format.
> This doesn't make much sense since the Query Database tools that return Avro
> return DATES and TIME values as strings; and thus following the
> Avro->JSON->JSON To SQL Route leads to DATE and TIME fields as being strings.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
