Streamsets Multitable JDBC Consumer offset as timestamp

asked 2020-03-10 18:23:27 -0500

Ram gravatar image

Streamsets version : 3.13.0 ( built by ubuntu on 2020-01-09T06:28Z git: e80c478a42ef4886d3a39e20c16b04ea15d1f138) Requirements : Convert timestamp columns to String ( include nano seconds also) Connector : Multitable JDBC Consumer Under JDBC Section - Used Convert TimeStamp to String check box Using Timestamp as offset column, At the end of the timestamp its adding .0 which cause pipeline run errors.

partitioned=false;;;partitionSequence=-1;;;partitionStartOffsets=COMMITTIMESTAMP=1583643600000,CSN=1;;;partitionMaxOffsets=;;;usingNonIncrementalLoad=false" : "COMMITTIMESTAMP=2020-03-08 03:43:31.0

Any suggestions ?

edit retag flag offensive close merge delete