CSVRecordSetWriter in Data Intergration

Writes the contents of a RecordSet as CSV data. The first line written will be the column names (unless the ‘Include Header Line’ property is false). All subsequent lines will be the values corresponding to the record fields.

Tags:

csv, result, set, record set, record, writer, serializer, row, tsv, tab, separated, delimited

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 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 Cache		Controller Service API: RecordSchemaCacheService Implementations: VolatileSchemaCache	Specifies a Schema Cache to add the Record Schema to so that Record Readers can quickly lookup the schema.
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).
CSV Format	custom	* Custom Format * RFC 4180 * Microsoft Excel * Tab-Delimited * MySQL Format * Informix Unload * Informix Unload Escape Disabled	Specifies which "format" the CSV data is in, or specifies if custom formatting should be used.
Value Separator			The character that is used to separate values/fields in a CSV Record
Include Header Line	true	* true * false	Specifies whether or not the CSV column names should be written out as the first line.
Escape Character	\		The character that is used to escape characters that would otherwise have a specific meaning to the CSV Parser.
Comment Marker			The character that is used to denote the start of a comment. Any line that begins with this comment will be ignored.
Null String			Specifies a String that, if present as a value in the CSV, should be considered a null field instead of using the literal value.
Trim Fields	true	* true * false	Whether or not white space should be removed from the beginning and end of fields
Quote Mode	MINIMAL	* Quote All Values * Quote Minimal * Quote Non-Numeric * Do Not Quote Values	Specifies how fields should be quoted when they are written
Record Separator	\n		Specifies the characters to use in order to separate CSV Records
Include Trailing Delimiter	false	* true * false	If true, a trailing delimiter will be added to each CSV Record that is written. If false, the trailing delimiter will be omitted.

State management:

This component does not store state.

Restricted:

This component is not restricted.