FIELDS TERMINATED BY '\001' is for chr(1). I'm not sure if it's decimal or octal. But you can test it out.
From: Chen, Stefanie (GBI) [mailto:stefanie.kim.c...@hp.com] Sent: Wednesday, April 04, 2012 1:10 PM To: user@hive.apache.org Subject: Field delimited by chr(28) I have a file which has fields delimited by chr(28) - fs. How do I specify this in field delimited by? Thanks, Stefanie Chen