[
https://issues.apache.org/jira/browse/SQOOP-906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13708687#comment-13708687
]
ASF subversion and git services commented on SQOOP-906:
-------------------------------------------------------
Commit 5495113781286de00473eb3d8c535f4288454082 in branch refs/heads/trunk from
[~jarcec]
[ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=5495113 ]
SQOOP-906: Sqoop is always calling ConnectionManager.datetimeToQueryString with
TIMESTAMP column type
(Raghav Kumar Gautam via Jarek Jarcec Cecho)
> Sqoop is always calling ConnectionManager.datetimeToQueryString with
> TIMESTAMP column type
> ------------------------------------------------------------------------------------------
>
> Key: SQOOP-906
> URL: https://issues.apache.org/jira/browse/SQOOP-906
> Project: Sqoop
> Issue Type: Bug
> Affects Versions: 1.4.2
> Reporter: Jarek Jarcec Cecho
> Assignee: Raghav Kumar Gautam
> Labels: newbie
> Attachments: SQOOP-906.4.txt, SQOOP-906.txt, SQOOP-906.txt,
> SQOOP-906.txt
>
>
> One user on CDH mailing list has risen
> [issue|https://groups.google.com/a/cloudera.org/forum/?fromgroups=#!topic/cdh-user/YEsRyX2Lu-Q]
> with incremental import using {{lastmodified}} mode. Sqoop seems to be
> generating queries including {{TO_TIMESTAMP}} function even for column that
> is defined as {{Types.DATE}}. This is causing issues with Oracle Connector.
> The connector seems to be correctly written as appropriate
> [OracleManager.datetimeToQueryString|https://github.com/apache/sqoop/blob/trunk/src/java/org/apache/sqoop/manager/OracleManager.java#L575]
> seems to be expected condition based on the column type. Unfortunately the
> [caller
> code|https://github.com/apache/sqoop/blob/trunk/src/java/org/apache/sqoop/tool/ImportTool.java#L280]
> is always passing in {{Types.TIMESTAMP}} value instead of the original
> value. I think that we should fix that.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
