As I understand, currently Hive does not honor escaping delimiter characters for input format. So is the best choice for delimiters when the fields can have freeform text?
Note that mysqldump only takes string as a specified delimiter.
See My Photos on Flickr
Also check out my Blog for answers to commonly asked questions.