JDBC Multi table consumer Override offset columns

I'm using JDBC Multitable consumer origin and I don't want to use the default primary key that Stream Sets uses because in my case primary key is not an incremental key.

My deltas identifying column will be TimeStamp, But when I override the offset column with that it is asking me in the long value. Let's suppose my max(Timestamp) in the hive table is "2017-10-31 12:30:00" How do I start from there with the long value? I'm confused a bit here I can make it to long as "20171031123000" but that's not picking the right deltas.

I then realized it will epoch time as "1509453023000" But that's not working as well. I'm bringing in the data from RedShift database. Please help me understand this.

Comments

Looks like when I use the override offset column and add the epoch time, it's not actually using it in the where clause I guess. I looked at the snapshot data and validate the counts to validate that it's not using in the where clause. I've added the screenshots of what I'm using in the question.