Expert Contributor
Posts: 109
Registered: ‎05-19-2016

sqoop incremental impor using IST Timezone

My connection string looks like this: If TZ is GMT, it works fine, however if I try to import in IST, I see a diff. of exact one hour. How do I fix it? Basically the timestamp it uses is 1 hour ahead of the actual time in IST at 4:30, it would take upper bound of 5: 30. How do I fix this please?


--connect 'jdbc:mysql://ip/db?zeroDateTimeBehavior=convertToNull&useTimZone=true'


This mysql DB TZ is in IST and so is my client server TZ.