You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Contents:

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

Description

null

no value

boolean

binary value

int

32-bit signed integer

long

64-bit signed integer

float

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

double

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

bytes

sequence of 8-bit unsigned bytes

string

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