Big Data Streaming User Guide

Back Next

JSON Data Types

The following table lists the JSON data types and the corresponding transformation data types:

JSON 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.
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
string	string	1 to 255 characters
struct	struct	Structs are represented as pairs of strings and integers delimited by the : character. String and integer pairs are delimited by commas.