hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ho Kenneth - kennho <Kenneth...@acxiom.com>
Subject Re: unicode character as delimiter
Date Thu, 10 Jan 2013 16:08:23 GMT
Thanks for the quick response.

I try '\376', but still not working  :(



On 1/10/13 6:23 AM, "Dean Wampler" <dean.wampler@thinkbiganalytics.com>
wrote:

>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.Ho@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

Mime
View raw message