You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Attila Szabo (JIRA)" <ji...@apache.org> on 2016/12/20 12:42:58 UTC
[jira] [Commented] (SQOOP-3082) Sqoop import fails after TCP
connection reset if split by datetime column
[ https://issues.apache.org/jira/browse/SQOOP-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15764125#comment-15764125 ]
Attila Szabo commented on SQOOP-3082:
-------------------------------------
Hi [~ssvinarchuk],
Many thanks for this patch!
It's so good to see your recent activity around Sqoop, I hope you'll also like the community and working together with us!
To ensure your first patch will be successful, I'd like to guide you through your very first Sqoop patch, thus I'd like to attach a few questions + suggestions to your changes
As a first step: could you please create a review ticket for your patch on the reviews.apache.org review board? (if you need any guidance there please feel free to raise your questions to me)
Thanks,
[~maugli]
> 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 Svinarchuk
> Attachments: 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
(v6.3.4#6332)