Converting to HDFS CSV format

You can convert data in an extract file into comma-separated value (CSV) format for use with Hadoop Distributed File Systems (HDFS).

  1. Expand a folder in the Directory Explorer that contains the convert service, expand the Convert Services node, and double-click the convert service to edit. The Convert Service Editor opens.
  2. Select the Target File Options tab.
  3. In the Target file format list, select Hadoop Distributed File System (HDFS).
  4. In the Target file name field, enter a name of the target file, which will be used for tables that do not have a target files specified. Select Use file macro to enter Optim™ file macros that dynamically create unique target file names for each table.
  5. Use the Object Files tab to enter target file names for the converted tables if a macro is not used or to override the macro. The grid is populated with table names in the associated table map.

    The following guidelines apply to files generated for a specific table:

    • If you do not specify a file name, the service will create a file with the name specified in the Target file name for the service.
    • If you do not specify a fully-qualified path for the file, the converted file will use the same location as the Target file name for the service.
  6. Use the HDFS Options tab to define formatting options for the HDFS CSV files.
  7. Use the Actions tab to specify a utility to perform additional processing associated with a convert service action.
  8. Save the convert service.


Feedback