I struggled with this today. I eventually made it work by using
convert(VARCHAR(35),TimeStamp,126) + '-0000' as TimeStampWtz
In addition, I think you have to make sure to output the timestamp. The pertinent components to inputs.conf:
output.format = kv
output.timestamp = 1
output.timestamp.column = TimeStampWtz
output.timestamp.format = yyyy-MM-dd'T'HH:mm:ss.SSSZ
The format is specified in Java SimpleDateFormat, though it doesn't seem to be completely implemented.
... View more