The ASCII "escape" character (octal: \033, hexadecimal: \x1B, or ^[, or, in decimal, 27) is used in many output devices to start a series of characters called a control sequence or escape sequence. Besides that how about replacing the escape character with something more familiar like ',' and then load into hive? this can be done with pig or simple sed command.
... View more
