Hi Matt, we're having here the same issue but with InformixDB, where we can not fetch 'serial' type column. What is weird it only happens when we use ExecuteSQL processor, and with ExecuteSQLRecord with AvroRecordSetWriter (default settings) somehow it works. The reason why we don't use ExecuteSQLRecord is that it produces problems with 'datetime' type columns- it looks like it misinterprets data somehow producing records that are exactly 1h 'younger' for example record '2020-01-01 12:00:00' in db becomes '2020-01-01 11:00:00' in flowfile (also converted to unix epoch in milis). We think that it may be somehow caused by the fact that servers system time is in BST. Any thoughts about those issues? Kind Regards, Mateusz
-- Sent from: http://apache-nifi-users-list.2361937.n4.nabble.com/
