Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Connections
  4. Mappings in a Hadoop Environment
  5. Mapping Objects in a Hadoop Environment
  6. Mappings in the Native Environment
  7. Profiles
  8. Native Environment Optimization
  9. Data Type Reference
  10. Function Reference
  11. Parameter Reference

Sqoop Data Types

Sqoop Data Types

When you use Sqoop, some variations apply in the processing.
The following table summarizes the data types that Informatica supports when you use Sqoop:
Data Type
Aurora
IBM DB2
IBM DB2 for z/OS
Greenplum
Microsoft SQL Server
Netezza
Oracle
Teradata
Bigint
n/a
Yes
Yes
Yes
Yes
Yes
n/a
Yes *
Bigserial
n/a
n/a
n/a
Yes
n/a
n/a
n/a
n/a
Binary
Yes
n/a
n/a
n/a
No
n/a
n/a
n/a
Bit
Yes
n/a
n/a
n/a
Yes
n/a
n/a
n/a
Blob
Yes *
Yes *
Yes *
n/a
n/a
Yes *
Yes *
Yes *
Boolean
n/a
n/a
n/a
No
n/a
No
n/a
n/a
Bytea
n/a
n/a
n/a
Yes
n/a
n/a
n/a
n/a
Byteint
n/a
n/a
n/a
n/a
n/a
Yes
n/a
Yes
Char
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Char for bit data
n/a
No
n/a
n/a
n/a
n/a
n/a
n/a
Clob
n/a
Yes
Yes
n/a
n/a
n/a
No
Yes
Date
Yes
Yes
Yes
Yes
No
Yes
Yes **
Yes
Datetime
Yes
n/a
n/a
n/a
Yes
n/a
n/a
n/a
DBClob
n/a
Yes
Yes
n/a
n/a
n/a
n/a
n/a
Decimal
Yes
Yes
Yes
Yes
Yes
n/a
n/a
Yes
Double
Yes
No
Yes
Yes
n/a
Yes
n/a
Yes
Enum
Yes
n/a
n/a
n/a
n/a
n/a
n/a
n/a
Float
Yes
Yes
n/a
n/a
Yes
n/a
Yes **
Yes
Float4
n/a
n/a
n/a
n/a
n/a
Yes
n/a
n/a
Float8
n/a
n/a
n/a
n/a
n/a
Yes
n/a
n/a
Graphic
n/a
Yes
Yes
n/a
n/a
n/a
n/a
n/a
Integer
Yes
Yes
Yes
Yes
n/a ***
n/a
n/a
Yes
Long
n/a
n/a
n/a
n/a
n/a
n/a
Yes **
n/a
Long Varchar for bit data
n/a
No
n/a
n/a
n/a
n/a
n/a
n/a
LongVargraphic
n/a
Yes
n/a
n/a
n/a
n/a
n/a
n/a
Money
n/a
n/a
n/a
No
Yes
n/a
n/a
n/a
Nchar
n/a
n/a
n/a
Yes
No
n/a
No
n/a
Number
n/a
n/a
n/a
n/a
n/a
Yes
No
Yes
Number (P, S)
n/a
n/a
n/a
n/a
n/a
n/a
Yes
No
Numeric
Yes
Yes
Yes
Yes
Yes
n/a
n/a
Yes
Nvarchar
n/a
n/a
n/a
Yes
No
n/a
No
n/a
Real
Yes
Yes
Yes
Yes
Yes
n/a
n/a
Yes
Serial
n/a
n/a
n/a
Yes
n/a
n/a
n/a
n/a
Set
Yes
n/a
n/a
n/a
n/a
n/a
n/a
n/a
Smalldatetime
n/a
n/a
n/a
n/a
Yes
n/a
n/a
n/a
Smallint
No
Yes
Yes
Yes
Yes
n/a
n/a
Yes
Smallmoney
n/a
n/a
n/a
n/a
Yes
n/a
n/a
n/a
Text
Yes
n/a
n/a
Yes
Yes
n/a
n/a
n/a
Time
Yes
Yes
Yes
Yes
No
No
n/a
Yes
Timestamp
Yes
Yes
Yes
Yes
No
Yes
Yes **
Yes
Tinyint
n/a
n/a
n/a
n/a
Yes
n/a
n/a
n/a
Varbinary
Yes
n/a
n/a
n/a
No
n/a
n/a
n/a
Varchar
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Varchar for bit data
n/a
No
n/a
n/a
n/a
n/a
n/a
n/a
Varchar2
n/a
n/a
n/a
n/a
n/a
n/a
Yes
n/a
Vargraphic
n/a
Yes
Yes
n/a
n/a
n/a
No
n/a
XML
n/a
No
No
No
No
n/a
No
n/a
n/a indicates that the data type is not applicable to the database.
* The data type is supported only for import.
** If the Sqoop program uses OraOop, the data type is supported only for import.
*** Microsoft SQL Server supports the INT data type.


Updated July 03, 2018