Github user ijokarumawak commented on the issue:
https://github.com/apache/nifi/pull/1798
**NOTE** This PR contains 3 commits, but only the last commit
[6c3080f](https://github.com/apache/nifi/pull/1798/commits/6c3080f5cc9662f45cf8792831eb25ee235a75dd)
is needed for NIFI-2624. NIFI-3873 (#1788) and NIFI-3895 (#1797) have
separated PRs those are under review currently and those can make it easier to
work with NIFI-2624 so I included those in this PR just for convenience.
Added 'Use Logical Types' property to ExecuteSQL and QueryDatabaseTable so
that user can choose from staying with the old behavior (outputs as string) or
as Logical types.
I've tested logical types with MySQL, PostgreSQL and Oracle databases.
Details for the test and database setup is written in this
[Gist](https://gist.github.com/ijokarumawak/69b29fa7b11c2ada656823db614af373).
I haven't touched HiveJdbcCommon yet and I think it should be done after
normal JdbcCommon is finished.
Thanks for reviewing!
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
