You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sqoop.apache.org by Abraham Elmahrek <ab...@cloudera.com> on 2015/06/01 17:05:04 UTC

Re: Sqoop Support Data Type Matrix for Oracle / MySQL / SQL Server

Hey there,

The data typing will vary by database. Check out
http://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_supported_data_types
for information for the oracle direct connector for example. The
documentation is a little sparse in this area, but ideally Sqoop supports
most/all database types out of the box.

-Abe

On Mon, Jun 1, 2015 at 10:40 AM, Jazz Yao-Tsung Wang <ja...@gmail.com>
wrote:

> Hi,
>
> Is there a supported data type mapping matrix of Sqoop ?
> For example,
>  Oracle Hive   CHAR  VARCHAR STRING  VARCHAR2 STRING  RAW  NCHAR
> NVARCHAR2  CLOB  NCLOB  NUMBER  BINARY_FLOAT  BINARY_DOUBLE  DATE
> TIMESTAMP  BLOB  BFILE
> Regards,
> Jazz Yao-Tsung Wang
> Co-Founder of Taiwan Hadoop User Group
> http://about.me/jazzwang
>