Numeric to Text (HD)

Converts a numeric type column to a text type column.

Information at a Glance

Parameter

 Description
Category Transform
Data source type HD
Send output to other operators Yes
Data processing tool n/a
Note: The Numeric to Text (DB) operator is for database data only. For Hadoop data, use the Null Value Replacement (DB) operator.

Input

A data set from the preceding operator.

Bad or Missing Values
All null values from the input data set are kept as is.

Configuration

Parameter Description
Notes Notes or helpful information about this operator's parameter settings. When you enter content in the Notes field, a yellow asterisk appears on the operator.
Columns Click Select Columns to convert to text. Only numeric type columns are shown.
Storage Format Select the format in which to store the results. The storage format is determined by your type of operator.

Typical formats are Avro, CSV, TSV, or Parquet.

Compression Select the type of compression for the output.

Available Parquet compression options.

  • GZIP
  • Deflate
  • Snappy
  • no compression

Available Avro compression options.

  • Deflate
  • Snappy
  • no compression
Output Directory The location to store the output files.
Output Name The name to contain the results.
Overwrite Output Specifies whether to delete existing data at that path.
  • Yes - if the path exists, delete that file and save the results.
  • No - fail if the path already exists.
Advanced Spark Settings Automatic Optimization
  • Yes specifies using the default Spark optimization settings.
  • No enables providing customized Spark optimization. Click Edit Settings to customize Spark optimization. See Advanced Settings dialog for more information.

Output

Visual Output
A preview of the output table.

(Example: selected "credit_lines" to convert to text type)

Data Output
A data set with the same columns as in the input, but with the selected numeric columns converted to text columns.