Multi-character field delimiter is not implemented in LazySimpleSerDe
and OpenCSVSerde
text file SerDe classes. There are two options to use multi-character field delimiter in Hive. The first option is MultiDelimitSerDe
class specially developed to handle multi-character field delimiters. The second one is to use RegexSerDe
class as a workaround. Those …