[
https://issues.apache.org/jira/browse/SQOOP-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16480457#comment-16480457
]
Hudson commented on SQOOP-3082:
-------------------------------
SUCCESS: Integrated in Jenkins build Sqoop-hadoop200 #1167 (See
[https://builds.apache.org/job/Sqoop-hadoop200/1167/])
SQOOP-3082: Sqoop import fails after TCP connection reset if split by (vasas:
[https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=ad7d046ef1d68b46aacdf6e124056f5901e95e5c])
* (edit) src/java/org/apache/sqoop/mapreduce/db/SQLServerDBRecordReader.java
> 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
> Fix For: 1.5.0
>
> 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)
