Adapter type: toolkit_file_csv_output. The File/Hadoop CSV Output adapter writes delimiter-separated data to a file or a Hadoop Distributed File System (HDFS). Set these properties for the File/Hadoop CSV Output adapter in the ESP Studio adapter properties dialog.
If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.
| Property Label | Description |
|---|---|
| Directory |
Property ID: dir Type: directory (Required) Specify the location of the data files. |
| File (in Directory) |
Property ID: file Type: string (Required) Specify the file to write to. |
| Append Mode |
Property ID: appendMode Type: boolean (Advanced) Specify whether data should be appended to an existing file. The default value is false. |
| Column Delimiter |
Property ID: csvDelimiter Type: string (Advanced) Specify the symbol used to separate the columns. The default value is a comma, ",". |
| Date Format |
Property ID: csvDateFormat Type: string (Advanced) Specify the format for parsing date values. The default value is yyyy-MM-dd'T'HH:mm:ss. |
| Timestamp Format |
Property ID: csvTimestampFormat Type: string (Advanced) Specify the format for parsing timestamp values. The default value is yyyy-MM-dd'T'HH:mm:ss.SSS. |
| Has Header |
Property ID: csvHasHeader Type: boolean (Advanced) Indicate whether the first line of the file contains the description of the CSV fields. The default value is false. |
| Prepend stream name, opcode |
Property ID: csvPrependStreamNameOpcode Type: boolean (Optional) If set to true, the adapter prepends the stream name and the opcode in each row of data that is generated. The default value is true. |
|
PropertySet |
Property ID: propertyset Type: string (Advanced) Specifies the name of the property set. Property sets are reusable sets of properties that are stored in the project configuration file. Using these sets allows you to move adapter configuration properties out of the CCL file and into the CCR file. If you specify the same properties in the project configuration file and the ATTACH ADAPTER statement, the values in the property set override the values defined in the ATTACH ADAPTER statement. No default value. |