This Confluence has been LDAP enabled, if you are an ASF Committer, please use your LDAP Credentials to login. Any problems file an INFRA jira ticket please.

Child pages
  • Sqoop2 Datatype Support
Skip to end of metadata
Go to start of metadata


Datatype Considerations

The key considerations for specifying datatype support in Sqoop is to ensure the following:

  • Easy for connectors to work with
  • Flexible enough to accomodate variations in different target systems.

Avro Types

According to Avro 1.7.0 specification, the following primitive types are supported:

Data Type



no value


binary value


32-bit signed integer


64-bit signed integer


single precision (32-bit) IEEE 754 floating-point number


double precision (64-bit) IEEE 754 floating-point number


sequence of 8-bit unsigned bytes


unicode character sequence

Apart from these, Avro also supports following non-primitive types:

  • Record: a free from collection of other types organized as a type
  • Enum: a value from a fixed set of predefined symbols
  • Array: an ordered collection of instance of the same type
  • Map: an unordered collection of string name and defined typed values
  • Union: a value that can be of any one of the defined types
  • Fixed: a value that can be defined as a fixed number of bytes.
  • No labels