Thank you. I'll try it On Apr 4, 2012, at 6:32 PM, "Alex Kozlov" <ale...@cloudera.com<mailto:ale...@cloudera.com>> wrote:
It's octal. On Wed, Apr 4, 2012 at 4:16 PM, Steven Wong <sw...@netflix.com<mailto:sw...@netflix.com>> wrote: 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<mailto:stefanie.kim.c...@hp.com>] Sent: Wednesday, April 04, 2012 1:10 PM To: user@hive.apache.org<mailto: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
