You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Matt Burgess (JIRA)" <ji...@apache.org> on 2019/04/05 21:21:00 UTC
[jira] [Updated] (NIFI-6100) JdbcCommon does not support binary
types for Phoenix
[ https://issues.apache.org/jira/browse/NIFI-6100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Matt Burgess updated NIFI-6100:
-------------------------------
Status: Patch Available (was: Open)
> JdbcCommon does not support binary types for Phoenix
> -----------------------------------------------------
>
> Key: NIFI-6100
> URL: https://issues.apache.org/jira/browse/NIFI-6100
> Project: Apache NiFi
> Issue Type: Bug
> Reporter: Aaron Leon
> Priority: Critical
> Time Spent: 20m
> Remaining Estimate: 0h
>
> The current implementation uses java.sql.PreparedStatement.setBinaryStream, which throws SQLFeatureNotSupportedException when used with org.apache.phoenix.jdbc.PhoenixPreparedStatement. A better alternative is to use setBytes. There will be no performance hit since the binary value is already read into memory in the current implementation, and it is implemented in PhoenixPreparedStatement so this will fix compatibility with Phoenix. It is also noted that PhoenixPreparedStatement should probably implement setBinaryStream anyways, so ideally a PR will be sent to Phoenix as well.
> https://github.com/apache/nifi/blob/rel/nifi-1.7.0/nifi-nar-bundles/nifi-standard-bundle/nifi-standard-processors/src/main/java/org/apache/nifi/processors/standard/util/JdbcCommon.java#L832
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)