Database Reference
In-Depth Information
Table 15-1. Escape sequences that can be used to specify nonprintable characters as field
and record delimiters in Sqoop
Escape Description
Backspaces.
\b
Newline.
\n
Carriage return.
\r
Tab.
\t
Single quote.
\'
Double quote.
\"
Backslash.
\\
NUL
. This will insert
NUL
characters between fields or lines, or will disable enclosing/escaping if
used for one of the
--enclosed-by
,
--optionally-enclosed-by
, or
--escaped-by
argu-
ments.
\0
\0
ooo
The octal representation of a Unicode character's code point. The actual character is specified by
the octal value
ooo
.
\0x
hhh
The hexadecimal representation of a Unicode character's code point. This should be of the form
\0x
hhh
, where
hhh
is the hex value. For example,
--fields-terminated-by '\0x10'
speci-
fies the carriage return character.
