Search

Big Data Streaming User Guide

Big Data Streaming User Guide

10.2.1
- 10.5.4
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 Service Pack 1
- 10.2.2

Back Next

Avro Data Types

Avro Data Types

The following table lists the Avro data types that Data Integration Service supports and the corresponding transformation data types:

Avro Data Type	Transformation Data Type	Range and Description
array	array	The elements in the array are of string, double, or int data type. The elements in the array are delimited by commas. For example, an array of fruits is represented as [apple,banana,orange]
boolean	integer	The default transformation type for boolean is integer. You can specify string data type with values of True and False. True is equivalent to the integer 1 and False is equivalent to the integer 0.
datetime	date/time	The time stamp format is YYYY-MM-DD HH:MM:SS.SSS. Precision 29, scale 9.
double	double	-1.79769313486231570E+308 to +1.79769313486231570E+308. Precision 15.
float	double	-1.79769313486231570E+308 to +1.79769313486231570E+308. Precision 15.
int	integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
long	bigint	-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19, scale 0.
map	map	Maps contain key-value pairs and are represented as pairs of strings and integers delimited by the =character. String and integer pairs are delimited by commas. For example, a map of fruits is represented as [1=apple,2=banana,3=orange].
record	struct	Unlimited number of characters.
string	string	1 to 104,857,600 characters.
struct	struct	Structs are represented as pairs of strings and integers delimited by the : character. String and integer pairs are delimited by commas. For example, a struct of fruits is represented as [1,apple]
union	Corresponding data type in a union of ["primitive_type\|complex_type", "null"] or ["null", "primitive_type\|complex_type"]	Dependent on primitive or complex data type.

Complex File Formats and Transformation Data Types

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.