[SQOOP-906] Sqoop is always calling ConnectionManager.datetimeToQueryString with TIMESTAMP column type

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.2
• Fix Version/s: 1.4.4
• Labels: newbie
• Assignee: Raghav Kumar Gautam
• Reporter: Jarek Jarcec Cecho
• Created: 23/Feb/13 17:52
• Updated: 15/Jul/13 19:09
• Resolved: 15/Jul/13 17:36

Description

One user on CDH mailing list has risen issue 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 seems to be expected condition based on the column type. Unfortunately the caller code is always passing in Types.TIMESTAMP value instead of the original value. I think that we should fix that.

Issue Links

• links to: Review board