sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-906) Sqoop is always calling ConnectionManager.datetimeToQueryString with TIMESTAMP column type
Date Mon, 15 Jul 2013 18:58:49 GMT

    [ https://issues.apache.org/jira/browse/SQOOP-906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13708824#comment-13708824
] 

Hudson commented on SQOOP-906:
------------------------------

SUCCESS: Integrated in Sqoop-ant-jdk-1.6-hadoop100 #778 (See [https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop100/778/])
SQOOP-906: Sqoop is always calling ConnectionManager.datetimeToQueryString with TIMESTAMP
column type (jarcec: https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=5495113781286de00473eb3d8c535f4288454082)
* src/java/org/apache/sqoop/manager/OracleManager.java
* src/java/org/apache/sqoop/tool/ImportTool.java
* src/test/com/cloudera/sqoop/TestMerge.java
* src/test/org/apache/sqoop/manager/oracle/OracleIncrementalImportTest.java
* src/test/com/cloudera/sqoop/testutil/BaseSqoopTestCase.java
* src/test/com/cloudera/sqoop/ThirdPartyTests.java
* src/test/com/cloudera/sqoop/TestIncrementalImport.java
* src/java/org/apache/sqoop/manager/ConnManager.java

                
> 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
>             Fix For: 1.4.4
>
>         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

Mime
View raw message