[
https://issues.apache.org/jira/browse/SQOOP-2018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14280448#comment-14280448
]
Veena Basavaraj edited comment on SQOOP-2018 at 1/16/15 4:20 PM:
-----------------------------------------------------------------
I do not understand your example.
In JDBC if you are using INT(11) What does that mean? INT in JDBC is max 4
bytes.
http://stackoverflow.com/questions/5634104/what-is-the-size-of-column-of-int11-in-mysql-in-bytes
If you are the latest code in JDBC Connector, it will set the schema to be
FixedPoint with bytesize of 4L, and this will be treated as a Integer in JAVA,
since it is 4 bytes and we check " <= 4L"
So I am not sure what your explanation infers, it is always hard for me to
understand.
was (Author: vybs):
I do not understand your example.
In JDBC if you are using INT(11) What does that mean? INT in JDBC is max 4
bytes.
> GenericJDBCConnector SqlTypes INTEGER should be set 4 bytes
> -----------------------------------------------------------
>
> Key: SQOOP-2018
> URL: https://issues.apache.org/jira/browse/SQOOP-2018
> Project: Sqoop
> Issue Type: Bug
> Reporter: Veena Basavaraj
> Assignee: Veena Basavaraj
> Fix For: 1.99.5
>
> Attachments: SQOOP-2018-take2patch, SQOOP-2018.patch
>
>
> treat INT as 4 bytes since both MySQL and Oracle and Postgres do it so
> http://dev.mysql.com/doc/refman/5.0/en/integer-types.html
> https://docs.oracle.com/cd/E17952_01/refman-5.5-en/storage-requirements.html
> http://www.postgresql.org/docs/9.1/static/datatype-numeric.html
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
