Specifies the single delimiter character to use to separate Hive table records.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Aliases: | ROW_DELIM |
| ROW_DELIMIT | |
| Default: | \010 ('\n') |
| Restriction: | Hive rejects this delimiter if you specify it in any other way, such as ROW_DELIMITER=010 (=linefeed). |
| Requirement: | Specify a single-character or three-digit decimal ASCII value between 001 and 127. |
| Data source: | Hadoop |
| See: | COLUMN_DELIMITER= data set option |
| Examples: | ROW_DELIMITER='#' |
| ROW_DELIMITER=009 (tab) |