You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Sergey Svinarchuk (JIRA)" <ji...@apache.org> on 2016/12/13 15:36:58 UTC
[jira] [Created] (SQOOP-3082) Sqoop import fails after TCP
connection reset if split by datetime column
Sergey Svinarchuk created SQOOP-3082:
----------------------------------------
Summary: 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
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)