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.