sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jarek Jarcec Cecho (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-1031) Provide default Java type mapping for MS Sql Datetimeoffset type
Date Mon, 20 May 2013 14:37:16 GMT

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

Jarek Jarcec Cecho commented on SQOOP-1031:

Hi [~shuainie],
thank you for your contribution! I'm curious where the value {{-155}} is coming from? I did
not find it either in [Java 6|http://docs.oracle.com/javase/6/docs/api/constant-values.html#java.sql.Types.ARRAY]
nor in [Java 7|http://docs.oracle.com/javase/7/docs/api/constant-values.html#java.sql.Types.ARRAY]
docs, so I'm wondering whether it's some sort of private extension of Microsoft SQL Server?

> Provide default Java type mapping for MS Sql Datetimeoffset type
> ----------------------------------------------------------------
>                 Key: SQOOP-1031
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1031
>             Project: Sqoop
>          Issue Type: Bug
>    Affects Versions: 1.4.4
>            Reporter: Shuaishuai Nie
>            Assignee: Shuaishuai Nie
>         Attachments: SQOOP-1031.1.patch
> MS SQL database type datetimeoffset causes errors when importing to HDFS. We need to
provide a default mapping in SQLServerManager which could still be overriden by users if wanted.
> In order to preserve time zone offset we use String instead of TimeStamp. This would
still work when exporting the imported data back to MS SQL Server

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

View raw message