Description:

Writes the contents of a RecordSet as SQL queries. All the incoming flow files will be written as SQL queries corresponding to the record fields given in schema.

Tags:

sql, result, set, record set, record, writer

Properties : Name	Default Values	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	* Use 'Schema Name' Property  * Use 'Schema Text' Property. * 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 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).
Table Name			Name of the table in which the records should be inserted.