[NIFI-2623] SelectHiveQL with Avro output doesn't handle binary types

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.0.0
• Component/s: Extensions
• Assignee: Matt Burgess
• Reporter: Matt Burgess
• Created: 22/Aug/16 17:58
• Updated: 23/Aug/16 15:45
• Resolved: 23/Aug/16 15:45

Description

SelectHiveQL, when specifying Avro output, and having columns of binary types, throws an error when run.

The error is a SQLException with text "Method not supported". This is coming from the Hive driver because HiveJdbcCommon is calling getBytes() on the ResultSet, and that method has not been implemented in the driver (HIVE-7134).

It may be possible to use getObject() and convert it into a byte array or ByteBuffer (if it is not already) for storage into an Avro record.

Issue Links

• is broken by: HIVE-7134 Implement ResultSet.getBytes()
• is related to: NIFI-2591 PutSQL has no handling for Binary data types
• links to: GitHub Pull Request #920