[NIFI-2165] PutCassandraQL is handling timestamps as strings

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.0.0, 0.6.1
• Fix Version/s: 1.0.0, 1.0.0-Beta
• Component/s: Extensions
• Labels: cassandra putcassandraql timestamp
• Environment: Ubuntu 14.04, openjdk version "1.8.0_91"
• Assignee: Unassigned
• Reporter: Jeff Oxenberg
• Created: 01/Jul/16 18:15
• Updated: 04/Aug/16 21:23
• Resolved: 05/Jul/16 17:39

Description

PutCassandraQL fails when attempting to insert a (iso-8601-formatted) timestamp on both Nifi 0.6 and 1.0 due to handling timestamps as strings.

Input:
FlowFile Attribute Map Content
Key: 'cql.args.1.type'
Value: 'text'
Key: 'cql.args.1.value'
Value: 'temp3'
Key: 'cql.args.2.type'
Value: 'timestamp'
Key: 'cql.args.2.value'
Value: '2016-06-30T20:04:36Z'
Key: 'cql.args.3.type'
Value: 'float'
Key: 'cql.args.3.value'
Value: '6.7'
Key: 'j.id'
Value: 'temp3'
Key: 'j.ts'
Value: '2016-06-30T20:04:36Z'
Key: 'j.value'
Value: '6.7'
--------------------------------------------------
INSERT INTO test.test2 (sensor, ts, value) VALUES(?,?,?)

Output:
com.datastax.driver.core.exceptions.CodecNotFoundException: Codec not found for requested operation: [timestamp <-> java.lang.String]
Record does not get inserted into Cassandra

Expected output:
Record gets inserted into Cassandra

Issue Links

• is related to: NIFI-2174 QueryCassandra is handling timestamps as strings
• links to: GitHub Pull Request #602