First I just want to say we are using DB Connect and DB Inputs with Rising columns extensively with DB2, Oracle and SQL Server database types - all without issues.
But recently we've been trying to setup a DB Input with Netezza database and the rising column is not working - not doing what it's supposed to be doing. I have a DB Input setup to run every 5 minutes and it pulls the same record everytime. Looking at the TIME column I am using as a rising column, and the checkpoint value Splunk DBConnects uses, it looks like the checkpoint value isn't precise enough to make the where statement work as intended.
The query is:
WHERE TIME > ?
ORDER BY TIME ASC
The value of the TIME column is:
The checkpoint value is (according to the Edit Input interface):
So of course if with statement "WHERE TIME > ?" then it is always true (19:34:04.884102 > 19:34:04.884).