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