You have to use the octal representation, e.g., ^A is \001. On Wed, Jan 9, 2013 at 8:32 PM, Ho Kenneth - kennho <kenneth...@acxiom.com>wrote:
> Hi all, > > I have an input file that has a unicode character as a delimiter, which is > þ (thorn) > > For example: > > col1þcol2þcol3 > > Þ has a value of UTF-8(hex) 0xC3 0xBE (c3be) > > And I have tried the following but no luck: > create table test(col1 string, col2 string, col3 string) row format > delimited fields terminated by '\c3be'; > > I'd appreciate your help! Thanks in advance. > > --ken > > > > *************************************************************************** > The information contained in this communication is confidential, is > intended only for the use of the recipient named above, and may be legally > privileged. > > If the reader of this message is not the intended recipient, you are > hereby notified that any dissemination, distribution or copying of this > communication is strictly prohibited. > > If you have received this communication in error, please resend this > communication to the sender and delete the original message or any copy > of it from your computer system. > > Thank You. > > **************************************************************************** > -- *Dean Wampler, Ph.D.* thinkbiganalytics.com +1-312-339-1330
