Description:

Writes the results of a RecordSet as a JSON Array. Even if the RecordSet consists of a single row, it will be written as an array with a single element.

Tags:

json, result set, writer, serialize, record, record set, row

Properties:

In the list below, the names of required properties appear in bold. Any other properties (not in bold) are considered optional. The table also indicates any default values, and whether a property supports the Expression Language Guide.

Name	Default Value	Allowable Values	Description
Schema Write Strategy	schema-name	Set 'schema.name' Attribute Set 'avro.schema' Attribute HWX Schema Reference Attributes HWX Content-Encoded Schema Reference	Specifies how the schema for a Record should be added to the data.
Schema Access Strategy	schema-name	Set 'schema.name' Attribute Set 'avro.schema' Attribute HWX Schema Reference Attributes HWX Content-Encoded Schema Reference	Specifies how to obtain the schema that is to be used for interpreting the data.
Schema Registry		Controller Service API: SchemaRegistry </br> Implementations: AvroSchemaRegistry HortonworksSchemaRegistry	Specifies the Controller Service to use for the Schema Registry
Schema Name	${schema.name}		Specifies the name of the schema to lookup in the Schema Registry property Supports Expression Language: true
Schema Text	${avro.schema}		The text of an Avro-formatted Schema Supports Expression Language: true
Date Format			Specifies the format to use when reading/writing Date fields. If not specified, Date fields will be assumed to be number of milliseconds since epoch (Midnight, Jan 1, 1970 GMT). If specified, the value must match the Java Simple Date Format (for example, MM/dd/yyyy for a two-digit month, followed by a two-digit day, followed by a four-digit year, all separated by '/' characters, as in 01/01/2017).
Time Format			Specifies the format to use when reading/writing Time fields. If not specified, Time fields will be assumed to be number of milliseconds since epoch (Midnight, Jan 1, 1970 GMT). If specified, the value must match the Java Simple Date Format (for example, HH:mm:ss for a two-digit hour in 24-hour format, followed by a two-digit minute, followed by a two-digit second, all separated by ':' characters, as in 18:04:15).
Timestamp Format			Specifies the format to use when reading/writing Timestamp fields. If not specified, Timestamp fields will be assumed to be number of milliseconds since epoch (Midnight, Jan 1, 1970 GMT). If specified, the value must match the Java Simple Date Format (for example, MM/dd/yyyy HH:mm:ss for a two-digit month, followed by a two-digit day, followed by a four-digit year, all separated by '/' characters; and then followed by a two-digit hour in 24-hour format, followed by a two-digit minute, followed by a two-digit second, all separated by ':' characters, as in 01/01/2017 18:04:15).
Pretty Print JSON	false	true false	Specifies whether or not the JSON should be pretty printed

State management:

This component does not store state.

Restricted:

This component is not restricted.