sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-3082) Sqoop import fails after TCP connection reset if split by datetime column
Date Fri, 18 May 2018 09:34:00 GMT

    [ https://issues.apache.org/jira/browse/SQOOP-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16480406#comment-16480406
] 

ASF subversion and git services commented on SQOOP-3082:
--------------------------------------------------------

Commit ad7d046ef1d68b46aacdf6e124056f5901e95e5c in sqoop's branch refs/heads/trunk from [~vasas]
[ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=ad7d046 ]

SQOOP-3082: Sqoop import fails after TCP connection reset if split by datetime column

(Sergey Svynarchuk via Szabolcs Vasas)


> 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)

Mime
View raw message