[ https://issues.apache.org/jira/browse/SQOOP-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fero Szabo updated SQOOP-3082: ------------------------------ Attachment: SQOOP-3082-1.patch > Sqoop import fails after TCP connection reset if split by datetime column > ------------------------------------------------------------------------- > > Key: SQOOP-3082 > URL: https://issues.apache.org/jira/browse/SQOOP-3082 > Project: Sqoop > Issue Type: Bug > Affects Versions: 1.4.6 > Reporter: Sergey Svynarchuk > Priority: Major > Attachments: SQOOP-3082-1.patch, SQOOP-3082.patch > > > If sqoop-to-mssqlserver connection reset, the whole command fails with > "Connection reset with com.microsoft.sqlserver.jdbc.SQLServerException: > Incorrect syntax near '00'" . On reestablishing connection, Sqoop tries to > resume import from the last record that was successfully read by : > {code} > 2016-12-10 15:18:54,523 INFO [main] > org.apache.sqoop.mapreduce.db.DBRecordReader: Executing query: select * from > test.dbo.test1 WITH (nolock) where Date >= '2015-01-10' and Date <= > '2016-11-24' and ( Date > 2015-09-18 00:00:00.0 ) AND ( Date < '2015-09-23 > 11:48:00.0' ) > {code} > Not quoted 2015-09-18 00:00:00.0 in SQL. -- This message was sent by Atlassian JIRA (v7.6.3#76005)